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

Amar Agnihotri 891 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.
10,723 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,654 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. VinodKumar-0434 271 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.