Forum Discussion
Azure DevOps Testpoints Data in Power BI
Hello All,
Hello, I am currently working on a project where I need to retrieve complete test points data from Azure DevOps. I have written a function with testplanid and test suited as parameters below.
When I pass the continuationToken parameter, nothing is being retrieved. Please help me with this.
Thanks in advance,
Sri
2 Replies
Hi Srikanth7Gunnam ,
According to this article, generally, REST API will have paginated response and ADO REST API normally have limits of 100 / 200 (depending which API) per page in each response. The way to retrieve next page information is to refer the response header
x-ms-continuationtokenand use this for next request parameter ascontinuationToken.May refer to Example With continuation token
GET https://dev.azure.com/fabrikam/fabrikam-fiber-tfvc/_apis/test/configurations?$skip=10&$top=15&continuationToken=14;12&api-version=5.0-preview.2Similar threads:
https://developercommunity.visualstudio.com/t/devops-rest-api-continuationtoken/677467
https://community.powerbi.com/t5/Desktop/Help-with-List-Generate-in-making-API-calls/m-p/789773
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hello,
Thank you so much for your response.
Do you know how to generate this x-ms-continuationtoken parameter in Power Query?
