Forum Discussion
Solved
parsing set variable string in Azure Data Factory
We have web activity and it always return below string with value change (value is dynamic everyday). We would need to extract key value. Please advise how to achieve this in Azure Data Factory activ...
The below solution should work to parse:
@json(<<Act output>>).aws_access_key_id
You should be able to use a set Variable to capture the result value of the web activity. Use that variable to save to an Azure database with a stored procedure or to some other store. I did this by making a call to the site to get a daily bearer token that I saved to an avure database table in a key value pair. Then I would use that token when making a cal to get the data. HTH.
Hi krishn
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.