How to use odata.next link from graph api response to pull the next page of record in adf ?

Amar Agnihotri 921 Reputation points
2022-08-08T17:25:08.453+00:00

Hi,
I am calling graph api to pull all the AD users data as shown
229178-image.png

As you can see in the above snap that in the api call i am having top 999 records along with odata.next link which means there are still more pending records to be pulled out.
I want to pull all the records to the end .Can anyone please suggest how can i achieve this in adf ?

Thanks in advance.

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,380 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,127 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. VinodKumar-0434 306 Reputation points
    2022-08-08T17:54:33.783+00:00

    @Amar Agnihotri , Thanks for reaching out to Microsoft Q&A.

    You can use Rest API Linked service to call the API and use pagination rule to set the absolute url.

    Here is a quick guide that will help you. You can ignore the managed identity part.

    To benefit the community, if you find the answer helpful please upvote and accept the answer. Thanks.

    Please feel free to drop a comment if you have any questions.