Pagination in ADF

Question

Hello folks,

In my source json response as below, I am trying to add pagination to get all the data but it doesnt seem to accept. Please can you advise on how to achieve this.

In my copy activity i have this

And the source json looks like this.

Answer 1

Hi @sam nick ,

Thanks for using Microsoft Q&A forum and posting your query.

Looks like you are using extra $ (nothing but root of the response body) which is causing the issue. Please configure the Absolute URL as below and it should help fix the problem.

After configuring as above and when you click on JSON payload of your copy activity, you will see the configuration as below in the JSON payload.

Hope this info helps.

---

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.