Pagination in ADF

sam nick 286 Reputation points

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

User's image

And the source json looks like this.

User's image

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,491 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 45,892 Reputation points Microsoft Employee

    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.

    User's image

    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.

    User's image

    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful