Forum Discussion

Srikanth7Gunnam's avatar
Srikanth7Gunnam
Helper I
4 years ago

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...
General Comment
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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-continuationtoken and use this for next request parameter as continuationToken.

 

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.2

 

Similar 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.

  • Srikanth7Gunnam's avatar
    Srikanth7Gunnam
    Helper I
    4 years ago

    Hello,

    Thank you so much for your response.

    Do you know how to generate this x-ms-continuationtoken parameter in Power Query?