I am trying to fetch all the items from the shared queries using GetQueryResults from AzureDevops. However, it limits to only 1000 records.
From the article https://docs.microsoft.com/en-us/connectors/visualstudioteamservices/#get-query-results it seems that we can fetch till 20000 records. Can someone please assist on this.
Can you confirm that you are using GetQueryResultsV2 endpoint and passing workItemsCount parameter to 20000 ?
Please have a try that click the Setting of the Get query results action, turn on Pagination to set the Threshold to 20000:
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have tried this method earlier and however tried again but ended up with same error as below:
The response is not a valid paginated response. The specified nextLink 'https://firstrelease-001.azure-apim.net/apim/visualstudioteamservices/shared-visualstudiot-ebaa1f8e-c4b9-462c-a8ec-45be95b3bf00/v2/MSUOrg/queryResults/07a52509-06d5-4a9e-91b2-4445585d46a5?account=msiorg&workItemsCount=20000&skip=1000' is not a well formed URI.
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!