Forum Discussion

sujeesh's avatar
sujeesh
Helper I
6 years ago
Solved

How to iteratively pass a header parameter in to a API url to get the complete list from the API.

Hi, I have a below requirement to iteratively pass a header parameter in to a API url to get the complete list from the API. 1.Load the below API URL https://vsrm.dev.azure.com/fe-tfs/Advisory%20p...
Tutorial Requests
  • artemus's avatar
    artemus
    6 years ago

    It will look something like:

     

    let
    NextResult = (token) =>
        let
            URL = "https://vsrm.dev.azure.com/fe-tfs/Advisory%20products/_apis/release/releases?api-version=5.1",
            URLWithContinuation = 
                if token = null then
                    URL
                else
                    URL & "&continuationToken=" & token, 
            Content = VSTS.Contents(URLWithContinuation),
            AsJson = Json.Document(Content)[value],
            continuationToken = Value.Metadata(Content)[Headers][#"x-ms-continuationtoken"]?,
            Result = 
                if continuationToken = null then
                    AsJson
                else
                    AsJson & @NextResult(continuationToken)
        in
            Result,
    AsTable = Table.FromRecords(NextResult(null))
in
    AsTable
artemus's avatar
artemus
Microsoft Employee
6 years ago

It will look something like:

 

let
    NextResult = (token) =>
        let
            URL = "https://vsrm.dev.azure.com/fe-tfs/Advisory%20products/_apis/release/releases?api-version=5.1",
            URLWithContinuation = 
                if token = null then
                    URL
                else
                    URL & "&continuationToken=" & token, 
            Content = VSTS.Contents(URLWithContinuation),
            AsJson = Json.Document(Content)[value],
            continuationToken = Value.Metadata(Content)[Headers][#"x-ms-continuationtoken"]?,
            Result = 
                if continuationToken = null then
                    AsJson
                else
                    AsJson & @NextResult(continuationToken)
        in
            Result,
    AsTable = Table.FromRecords(NextResult(null))
in
    AsTable
Srikanth7Gunnam's avatar
Srikanth7Gunnam
Helper I
4 years ago

Hello, I am currently working on a similar project where I need to retrieve complete test points data. I have written a function with testplanid and test suited as parameters.

 

let
  PointsAPICall = (TestPlanId as text,TestSuiteId as text) =>
    let
    Source =
    try
    Json.Document(Web.Contents("https://dev.azure.com/{Org}/{project}/_apis/testplan/Plans",[RelativePath= TestPlanId &"/Suites/" & TestSuiteId & "/TestPoint?api-version=6.0-preview.2"]))
    otherwise
    null
in
    Source
in
  PointsAPICall
But, I am only getting the first batch of test points.  Could you please help me pass "continuationToken" to the above code?

When I pass the continuationToken parameter, nothing is being retrieved.

 

Thanks in advance,

Sri