Forum Discussion
JohnFabric
1 year agoHelper I
How to get all data out of the Azure Devops API when multiple API calls are required
Hello, I'm trying to build a report in PowerBI about the pull requests in my organization. ADO has an API to support this: https://learn.microsoft.com/en-us/rest/api/azure/devops/git/pull-requests/ge...
- 1 year ago
Here is the code that ended up working for me. Put this in a Power Query function that I called.
= () => let baseUrl = "https://dev.azure.com/{organization}/{project}/_apis/git/pullrequests", pageSize = 1000, // Function to get a single page GetPage = (skip as number) => let url = baseUrl & "&$top=" & Text.From(pageSize) & "&$skip=" & Text.From(skip) & "&api-version=7.1-preview.1", response = Json.Document(Web.Contents(url)), values = response[value] in values, // Generate list of pages PageGenerator = List.Generate( () => [page = 0, result = GetPage(0)], each List.Count([result]) > 0, each [page = [page] + 1, result = GetPage(([page] + 1) * pageSize)], each [result] ), // Flatten the list of lists AllResults = List.Combine(PageGenerator), // Convert to table ResultTable = Table.FromList(AllResults, Splitter.SplitByNothing(), null, null, ExtraValues.Error) in ResultTable
lbendlin
1 year agoSuper User
Here is the standard approach for API paging
Handling paging for Power Query connectors - Power Query | Microsoft Learn
JohnFabric
1 year agoHelper I
I looked at that, but as I said, it doesn't appear this API supports pagination, or at the very least I don't understand how I would implement that function in this case. Could you provide some additional context please?
- Anonymous1 year agoNot applicable
Hi JohnFabric,
Azure DevOps uses manual pagination with $top and $skip parameters. Since it doesn't return a continuation token, you simulate paging using List.Generate, which is the standard approach for APIs without nextLink support.
Regards,
Vinay Pabbu