Unable to fetch more than 1000 records using GetQueryResults from AzureDevops

[M_Sri_Prakash]

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.

[anupam8555]

Hi M_SRI_PRAKASH,

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

Thanks

[v-litu-msft]

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.

[M_Sri_Prakash]

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

[M_Sri_Prakash]

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.

[esuna114]

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