I’m using vscode for my project and I have 4 files in it.
Info about my spreadsheet is in the secrets.toml
My app is in connection.py
When I run my app I get a ValueError: ‘Spreadhseet must be specified’ even though it is specified in secrets.toml
How do I solve this? I have restarted my app many times I still get the error. Is there a way to connect the secrets.toml to my connection.py? Cause I think the py file doesn’t recognize it
It looks like connection.py might be stored inside of the .streamlit folder – can you try moving that Python file outside of the .streamlit folder?
Actually none of them are. The folder is empty. secrets.toml was in that folder but I moved it outside
secrets.toml should be stored inside the .streamlit folder
It was there the first time, din’t work then I moved it outside
It also looks like your private_key (in your secrets file) includes “------BEGIN PRIVATE KEY----” – can you try taking that part out so it’s just the private key?
Still gives an error
Can you share a screenshot of the current file structure?
One sanity check is to do st.write(st.secrets['connections']) – that should show you whether or not it is in fact loading the secrets.toml file.
Now it’s working thankyou
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.
These cookies are necessary for the website to function and cannot be switched off. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us understand how visitors move around the site and which pages are most frequently visited.
These cookies are used to record your choices and settings, maintain your preferences over time and recognize you when you return to our website. These cookies help us to personalize our content for you and remember your preferences.
These cookies may be deployed to our site by our advertising partners to build a profile of your interest and provide you with content that is relevant to you, including showing you relevant ads on other websites.
