cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
M_Sri_Prakash
Microsoft
Microsoft

Unable to fetch more than 1000 records using GetQueryResults from AzureDevops

Hello Team,

 

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.

5 REPLIES 5
anupam8555
Continued Contributor
Continued Contributor

Hi M_SRI_PRAKASH,

 

Can you confirm that you are using GetQueryResultsV2  endpoint and passing workItemsCount parameter to 20000 ? 

 

Thanks

v-litu-msft
Community Support
Community Support

Hi @M_Sri_Prakash,

 

Please have a try that click the Setting of the Get query results action, turn on Pagination to set the Threshold to 20000:

Annotation 2020-05-25 092019.jpg

 

Annotation 2020-05-25 092045.jpg

 

Best Regards,
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.

It just shows as "GetQueryResults" and I have entered the value as "20000" in Number of work items to return.

GetQueryResults.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

GetQueryResults1.png

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.

 

Hello, I have exactly the same problem. Is there any solution for this pagination error? Thanks

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Top Kudoed Authors
Users online (1,982)