CODEWITHSUNDEEP
restparametersazure-data-factoryazure-data-lakequery-string
rushabh shah
rushabh shah

Reputation: 1

I am trying to download data from REST API to azure data lake via azure data factory. How can I pass query parameters for API in azure data factory?

I am doing this using ‘Copy Activity’. Is there any other activity that can better perform this operation? Example REST API URL:https://xzy.com/servicename?name=tom&age=50&city=boston&...... I am putting 'https://xzy.com/servicename/' as the base URL for the linked service. How to pass the query parameters 'name=tom' and 'age=50' and 'city=boston' to the base url in the azure data factory to get the response? Will the parameters be passed at linked service, dataset or pipeline level?

Upvotes: 0

Views: 663

Answers (1)

Jay Gong
Jay Gong

Reputation: 23782

It seems that your request method is Get. You could only set the query parameters behind base url directly.

For example,i test rest api from this sample website:

https://jsonplaceholder.typicode.com/comments?postId=1

Test result:

enter image description here

If your request method is Post,i suppose you have to define the parameters in the Body part.

enter image description here

Upvotes: 1

Related Questions