How do I enter Get Parameters for a Rest API

Question

My REST API supports adding parameters such as Pagesize, Updated Dates and other filterable columns. How do I build these into the Data Factory copy activity?

Answer 1

Hello @Ryan James and welcome to Microsoft Q&A.

Typically, message body is not used in REST GET requests. The parameters are either encoded in the URI or added as headers. When in the URI it might look something like this:

https://myRestSite.net/api/tablename?filter=date&pagesize=200  

where the parameters are filter, and pagesize.

To build this we need to take advantage of the dataset base URL and relative URL. We also need to parameterize the dataset.

First go to the dataset and add some parameters:

Second, concatenate the parameters together in the relative URL

@concat(dataset().tablename,'?',dataset().param1,'&',dataset().param2)  

Third, pass in values through the copy activity to the dataset.