Azure Synapse - Web activity use variables in Body

Question

Azure Synapse - Web activity use variables in Body

Giri, Seshu 26

Hi Microsoft Community,

I am reading secrets etc from Azure Vault in Synapse pipeline, after I have values from Vault I wanted to use those in a 'Web activity' to get BEARER Token. Please see attached screen print (sample flow).

Below syntax is not working. How do I make it work? Thanks

grant_type=variables('fromVault1')&client_id=variables('fromVault2')&client_secret=variables('fromVault3')&scope=variables('fromVault4')

KranthiPakala-MSFT 35,522 Reputation points Microsoft Employee

2022-09-05T22:06:54.04+00:00
Hello @Giri, Seshu ,

Thanks for the question and using MS Q&A platform.

As per my understanding, you are trying to get the web activity body fields from Azure Key vault and assign those values to variables and use them in the body using dynamics content. Please correct me if I'm not accurate.

Are you receiving any specific error, or your pipeline is running but no message in the response body? What is the behavior you are seeing?
In order to troubleshoot further and understand where the flow is breaking, I would recommend troubleshooting backwards.

First hardcode the values in the body instead of variables and check if your web activity is working as expected. If it works well then follow step 2 for another test. If it fails then you might be using incorrect values in the body of your web activity.

If the above test goes well, then create the variables as needed and hardcode the values (which were working in above step 1) for those variables and use the variables in body of your web activity and test it. If that goes well it confirms that the variables values are mapped correctly. Else it confirms that the variables values passed are incorrect or something wrong with the dynamic content for forming the web activity body.

If step 2 goes well, then try with your original approach of getting AKV values and assign them set variable and make sure the values are getting as expected.

Hope this info helps. Let us know how the test goes.
Giri, Seshu 26 Reputation points

2022-09-06T15:24:53.793+00:00

Hi @KranthiPakala-MSFT

Thanks for your response. I tried below two wayts and I am getting below error

Input: grant_type=variables('fromVault1')&client_id=variables('fromVault2')&client_secret=variables('fromVault3')&scope=variables('fromVault4')
Error: "message": "{\"error\":\"unsupported_grant_type\",\"error_description\":\"AADSTS70003: The app requested an unsupported grant type 'variables('fromVault1')'.

Input: grant_type=@**variables('fromVault1')&client_id=@variables('fromVault2')&client_secret=@variables('fromVault3')&scope=@variables('fromVault4')
**Error: "message": "{\"error\":\"unsupported_grant_type\",\"error_description\":\"AADSTS70003: The app requested an unsupported grant type '**@**variables('fromVault1')'.

KranthiPakala-MSFT 35,522 Reputation points Microsoft Employee

2022-09-05T22:06:54.04+00:00

Hello @Giri, Seshu ,

Thanks for the question and using MS Q&A platform.

As per my understanding, you are trying to get the web activity body fields from Azure Key vault and assign those values to variables and use them in the body using dynamics content. Please correct me if I'm not accurate.

Are you receiving any specific error, or your pipeline is running but no message in the response body? What is the behavior you are seeing?
In order to troubleshoot further and understand where the flow is breaking, I would recommend troubleshooting backwards.

First hardcode the values in the body instead of variables and check if your web activity is working as expected. If it works well then follow step 2 for another test. If it fails then you might be using incorrect values in the body of your web activity.

If the above test goes well, then create the variables as needed and hardcode the values (which were working in above step 1) for those variables and use the variables in body of your web activity and test it. If that goes well it confirms that the variables values are mapped correctly. Else it confirms that the variables values passed are incorrect or something wrong with the dynamic content for forming the web activity body.

If step 2 goes well, then try with your original approach of getting AKV values and assign them set variable and make sure the values are getting as expected.

Hope this info helps. Let us know how the test goes.
Giri, Seshu 26 Reputation points

2022-09-06T15:24:53.793+00:00

Hi @KranthiPakala-MSFT

Thanks for your response. I tried below two wayts and I am getting below error

Input: grant_type=variables('fromVault1')&client_id=variables('fromVault2')&client_secret=variables('fromVault3')&scope=variables('fromVault4')
Error: "message": "{\"error\":\"unsupported_grant_type\",\"error_description\":\"AADSTS70003: The app requested an unsupported grant type 'variables('fromVault1')'.

Input: grant_type=@**variables('fromVault1')&client_id=@variables('fromVault2')&client_secret=@variables('fromVault3')&scope=@variables('fromVault4')
**Error: "message": "{\"error\":\"unsupported_grant_type\",\"error_description\":\"AADSTS70003: The app requested an unsupported grant type '**@**variables('fromVault1')'.

Answer 1

Giri, Seshu 26

@KranthiPakala-MSFT Issue resolved now. I used @markus.bohland@hotmail.de

KranthiPakala-MSFT 35,522 Reputation points Microsoft Employee

2022-09-06T22:14:41.58+00:00

Hello @Giri, Seshu ,

Glad to know the issue has been resolved and thanks for sharing your findings. Yes, when you use the dynamic expression, you will have to do concatenation when you mix the regular string with dynamic fields like parameters or variables.

Azure Synapse - Web activity use variables in Body

1 answer

Activity