Hi Andrei_Y ,
It would be more helpful if you could specify the type of account you are trying to update.
However, in general, SnapLogic offers a feature called dynamic accounts. Dynamic Accounts provide expression-enabled fields, allowing you to use expressions for connection information rather than literal values. You can also leverage the concept of parent and child pipelines for processing per document or batch, passing values as Pipeline parameters. Below is a link that lists the account types that support dynamic accounts and their associated dynamic fields. https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2586148875/Dynamic+Account+Types
Thanks for suggesting. The HTTP client doesn't support any Dynamic Accounts. I guess REST Dynamic OAuth2 Account will work for the snap REST Post.
I already found a solution using the account OAuth2 Account which refreshes the access token automatically but that was tricky because I only have client id, client secret and refresh token and so I was not able to authorize and also the field Refresh token is not editable in the account. But I finally updated the field one time using the SnapLogic Update snap.
If your Oracle table has columns whose names contain a ‘$’ (or any other special character) in it, here’s how the execute query needs to look like:
Query: select “USER$ID” from testtable1
Note: Expression should not be enabled on the “Oracle Execute” snap
Thank you! That did the trick.
