MS Graph ODatalink paging

[briansull]

Hey Folks,

Looking for help to connect to Microsoft Graph and pull more than 999 records. Currently, below is working but not pulling all records

Thanks

(GraphURI as text) as record =>
let
    ResourceAppIdUrl = "https://graph.microsoft.com",
    OAuthUrl = "https://login.microsoftonline.com/",

    Resource = Text.Combine({"resource", Uri.EscapeDataString(ResourceAppIdUrl)}, "="),
    ClientId = Text.Combine({"client_id",ApplicationID}, "="),
    ClientSecret = Text.Combine({"client_secret", Uri.EscapeDataString(ApplicationSecret)}, "="),
    GrantType = Text.Combine({"grant_type", "client_credentials"}, "="),

    Body = Text.Combine({Resource, ClientId, ClientSecret, GrantType}, "&"),

    AuthResponse= Json.Document(Web.Contents(
        OAuthUrl, 
        [
            RelativePath= Text.Combine({TenantGUID,"/oauth2/token"}),
            Content=Text.ToBinary(Body)
        ]
    )),
    AccessToken= AuthResponse[access_token],
    Bearer = Text.Combine({"Bearer", AccessToken}, " "),

    Response = Json.Document(Web.Contents(
        ResourceAppIdUrl, 
        [
            RelativePath = GraphURI,
            Headers = [#"Content-Type"="application/json", #"Authorization"=Bearer]
        ]
    ))
in
    Response

[ams1]

Hi,

The results are paged.

From https://learn.microsoft.com/en-us/graph/paging

If the result contains more results, Microsoft Graph will return an @odata.nextLink property...

If you look at the request response, you should see the next link there and you can use it to request the next page

I recently answered a question related to paging:

• https://community.powerbi.com/t5/Power-Query/how-to-iterate-the-data-of-several-sheets-of-a-web-page...
• and also you can have a look at https://learn.microsoft.com/en-us/power-query/helper-functions#tablegeneratebypage

If this answer helped, please consider marking it as a solution.