Can we pass an array with ids as a query parameter in pagination?

Question

I am trying to make REST API request and for some reason, we need to pass some individual ids to the API to get the information from response.

I am thinking pagination rule, query parameter to pass the id which I could try to store in an array.

However, I could not find any mean to auto increase the index of the array to loop the request until the end of array.

Answer 1

Hi Melody,

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

consider having your Ids in array variable and pass that array variable to ForEach activity. Inside foreach activity frame your request URL with each id and then use that request URL in for API call.

I did little similar API calls using foreach loop in below video. Kindly refer that for better understanding.

Copy data from REST API which sends response in Pages using Azure data factory

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