heey everyone, does anybody know how to put more t...
# prefect-ui
heey everyone, does anybody know how to put more than one variable in a secret, maybe as json? thanks :)
āœ… 1
Hi @Laura Vaida - yes you can use json for your secrets. If you click on the 'Type' button on the bottom right of the secret input box you can choose JSON and that will help you make sure your json is properly formatted.
Copy code
"host" : "___",
"port" : "___",
"username" : "___,
"password" : "___"
Thanks @Jenny, like that for example? :)
Looks good. The JSON formatter would pick this up for you but looks like you're missing an " at the end of username. šŸ˜ƒ
ah you're right, thanks! do you know how to infer to a specific value from that, e.g. username?
You should be able to access it like a python dictionary. E.g.
Copy code
from prefect import task, Flow
from prefect.tasks.secrets import PrefectSecret

def access_secret(secret_value):
    # Access your secret and now you can use it however you would like

with Flow("secret-retrieval") as flow:
    secret = PrefectSecret("MY_SECRET")

thanks, will try that! šŸ™‚
ok, i tried with the following:
Copy code
def create_engine(snowflake_salesforce):
    config = configparser.ConfigParser()
with Flow('UWG-Mail') as flow:
but it's resulting in that error:
Copy code
Unexpected error: TypeError("unhashable type: 'dict'")
Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/prefect/engine/runner.py", line 48, in inner
    new_state = method(self, state, *args, **kwargs)
  File "/usr/local/lib/python3.8/site-packages/prefect/engine/task_runner.py", line 863, in get_task_run_state
    value = prefect.utilities.executors.run_task_with_timeout(
  File "/usr/local/lib/python3.8/site-packages/prefect/utilities/executors.py", line 298, in run_task_with_timeout
    return task.run(*args, **kwargs)  # type: ignore
  File "<input>", line 36, in create_engine
  File "/usr/local/lib/python3.8/configparser.py", line 959, in __getitem__
    if key != self.default_section and not self.has_section(key):
  File "/usr/local/lib/python3.8/configparser.py", line 668, in has_section
    return section in self._sections
TypeError: unhashable type: 'dict'
do you know any help here?
Hi Laura - if you have new questions it's best to ask in a new thread. Iā€™m OOO today and other team members might not see this. Generally that error message means you're trying to use a dict as a key in another dict.
sure thing, well do so! thank you šŸ™‚
šŸ™‚ 1