Unable to fetch more than 1000 records using GetQueryResults from AzureDevops

Like (0) Share

Report

Posted on 22 May 2020 11:16:16 by M_Sri_Prakash Microsoft Employee

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.

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (5)

Answers (0)

esuna114 12 on 04 Jul 2020 at 14:38:48

Like (0)

Report

Re: Unable to fetch more than 1000 records using GetQueryResults from AzureDevops

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

Was this reply helpful? Yes No
M_Sri_Prakash Microsoft Employee on 25 May 2020 at 04:40:10

Like (0)

Report
Re: Unable to fetch more than 1000 records using GetQueryResults from AzureDevops

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.

Was this reply helpful? Yes No
M_Sri_Prakash Microsoft Employee on 25 May 2020 at 04:33:07

Like (0)

Report

Re: Unable to fetch more than 1000 records using GetQueryResults from AzureDevops

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

Was this reply helpful? Yes No
v-litu-msft on 25 May 2020 at 01:23:38

Like (0)

Report

Re: Unable to fetch more than 1000 records using GetQueryResults from AzureDevops

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:

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.

Was this reply helpful? Yes No
Anupam.khasia 366 on 24 May 2020 at 08:52:05

Like (0)

Report

Re: Unable to fetch more than 1000 records using GetQueryResults from AzureDevops

Hi M_SRI_PRAKASH,

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

Thanks

Was this reply helpful? Yes No