Passing encoded value in URL in a get request from azure synapse copy activity

Question

I am able to send post request to Google search console from postman which requires the Urlsite name to be encoded and passed in the request.

How to achieve the same from azure synapse ?
I am able to get the response by sending as below along with body as well.
Looking to achieve the same from azure synapse.

Answer 1

Hi @Bhoopathiraju Deepthi ,

Thank you for posting query in Microsoft Q&A Platform.

Path variables should be part of your API URL. So, in Azure Synapse Copy activity, you need to use dataset which is REST connector type and in URL itself you need to include the path variable value.

Please check below screenshots:
Request from Postman :

To create same request from Synapse, create a linked service which is REST type and create a dataset REST type use this linked service and use that dataset in copy activity.

Hope this helps. Please let me know if any further queries.

----------

Please consider hitting Accept Answer button. Accepted answers help community as well.