Forum Discussion

alexmoller's avatar
alexmoller
Frequent Visitor
1 year ago
Solved

Looping Through API with Next Link Parameter

Hello All,   I am trying to loop through a Graph API endpoint, using the next link value present in the response to get the next paginated list of values.    I am using list.generate in order to ...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    use try ... otherwise ... and return an empty list for the latter.

lbendlin's avatar
lbendlin
Super User
1 year ago

use try ... otherwise ... and return an empty list for the latter.

alexmoller's avatar
alexmoller
Frequent Visitor
1 year ago

Thanks for your reply, I'm not sure I follow what you mean, could you explain in more detail?

  • alexmoller's avatar
    alexmoller
    Frequent Visitor
    1 year ago

    Ah my apologies, I have worked it out - I just needed to add this code: 

    = List.Generate( () =>
    [URL = "https://graph.microsoft.com/v1.0/communications/callRecords",
    Result = Json.Document(Web.Contents("https://graph.microsoft.com/v1.0/communications/callRecords", [ Headers = [ Authorization = "Bearer " & access_token ], ExcludedFromCacheKey = {"Authorization"} ] ))],
    each [URL] <> null,
    each [URL = try [Result][#"@odata.nextLink"] otherwise null,
    Result = Json.Document(Web.Contents(URL,[ Headers = [ Authorization = "Bearer " & access_token ], ExcludedFromCacheKey = {"Authorization"} ]))]
    )