heey everyone does anybody know how to put more than one var

Question

heey everyone does anybody know how to put more than one variable in a secret maybe as json thanks

Jenny · Answer

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

Laura Vaida · Answer

``` host port username password ``` Thanks < Jenny> like that for example

Jenny · Answer

Looks good The JSON formatter would pick this up for you but looks like you re missing an at the end of username smiley

Laura Vaida · Answer

ah you re right thanks do you know how to infer to a specific value from that e g username

Jenny · Answer

You should be able to access it like a python dictionary E g ```from prefect import task Flow from prefect tasks secrets import PrefectSecret task def access secret secret value Access your secret and now you can use it however you would like print secret value username with Flow secret retrieval as flow secret = PrefectSecret MY SECRET access secret secret flow run ```

Laura Vaida · Answer

thanks will try that slightly smiling face

Laura Vaida · Answer

ok i tried with the following ``` task log stdout=True def create engine snowflake salesforce config = configparser ConfigParser engine=create engine URL config snowflake salesforce with Flow UWG Mail as flow snowflake credentials=PrefectSecret Snowflake Salesforce connection=create engine snowflake salesforce=snowflake credentials ```

Laura Vaida · Answer

but it s resulting in that error ```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 lt input gt 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 ```

Laura Vaida · Answer

do you know any help here

Jenny · Answer

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

Laura Vaida · Answer

sure thing well do so thank you slightly smiling face