Forum Discussion
search for string value 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 activities.
Set Activity return value : Value= "{"aws_access_key_id":"XE6MX","aws_secret_access_key":"sgD6zEe"}"
We would like to get aws_access_key_id value XE6MX in separate variable so we can pass it to subsequent activities. And this value id dynamic and changes every day
tried with replace and search functions but couldn't work out.
I got the response from another group and below the syntax I should follow in my set variable. Since the variable returning value type of JSON. @json(variables('NEW')).aws_access_key_id
