How to pass variable to REST API call in synapse analytics

Question

How to pass variable to REST API call in synapse analytics

BalwinderKaur-5937 41

I have created a pipeline in Synapse Analytics with web activity and I will be using it to call REST API. Before I make REST API POST Call , In the Post call body I need to pass user credentials that I already saved in Azure Key Vault. I am able to retrieve the credentials using a web and set variable activity. But the issue is when I pass those variables to the Rest API Post call-body section it gives an error “Authentication failed for User” . How can I pass those variable in the Rest API call in the web activity.
Thank you

Answer accepted by question author

0 additional answers

Your answer

Answer 1

PRADEEPCHEEKATLA 91,846

Hello anonymous user,

Welcome to the Microsoft Q&A platform.

The only easy was as of now is using a web activity to connect to key vault REST API via MSI and fetch the secret value and pass it to the web activity.

You can store credentials or secret values in an Azure Key Vault and use them during pipeline execution to pass to your activities.

For more details, refer to Use Azure Key Vault secrets in pipeline activities.

And also, you may refer to the SO thread (Retrieve key vault in web activity in Azure Data Factory) which addressing similar issue.

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

BalwinderKaur-5937 41 Reputation points

2021-07-28T16:09:41.707+00:00

Hello Pradeep, I have already retrieved the secret values and pass from key vault using the web activity. I am having issue passing that values(login and Pass ) to another web activity which I'm using to call a third party Rest API. I have attached the screenshot for reference. The last web activity is to call a Rest API and I'm trying to pass the values that I retrieved from key vault in the body section of that call. In the below screenshot the first two web activities are retrieving login and password from azure key vault and Set variable activity is passing the variables to the Rest API call Web activity. The pipeline debugs but the last web activity is not returning the data, it says the input data must be an xml document. Thank you. ![118669-image.png][1] [1]: /api/attachments/118669-image.png?platform=QnA i
PRADEEPCHEEKATLA 91,846 Reputation points

2021-08-18T05:35:07.203+00:00

Hello anonymous user,

Apologize for the delay in response.

You pass your variables inside body field of Web activity as dynamic content to compose your request body dynamically.

Hope this helps. Do let us know if you any further queries.
BalwinderKaur-5937 41 Reputation points

2021-08-19T04:06:53.96+00:00

Hello Pradeep ,
No problem, I actually figured it out , used the same method. Thank you for your response.
PRADEEPCHEEKATLA 91,846 Reputation points

2021-08-19T06:02:31.803+00:00

Hello anonymous user,

Glad to know that your issue has resolved. You can accept it as answer. This can be beneficial to other community members. Thank you.

Share via

How to pass variable to REST API call in synapse analytics

0 additional answers

Your answer