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.

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"} ]))]
)