Forum Discussion

sujeesh's avatar
sujeesh
Icon for Helper I rankHelper I
6 years ago

How to query the complete list of data from the API

Hi,

I am using the Azure DevOps Rest API as a data source to retrieve the data. but the API is displaying only the first 50 items.

Can you please on how to query the full list of data from the API.

 

the API I am using is : 

https://vsrm.dev.azure.com/fe-tfs/Advisory%20products/_apis/Release/releases

 

The query I am using is 

let
Source = VSTS.Contents("https://vsrm.dev.azure.com/fe-tfs/Advisory products/_apis/Release/releases?api-version=5.1-preview.6"),
ZIPFile = Table.FromRecords(Json.Document(Source,65001)[value]),
#"Expanded projectReference" = Table.ExpandRecordColumn(ZIPFile, "projectReference", {"id", "name"}, {"projectReference.id", "projectReference.name"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded projectReference",{{"id", Int64.Type}})
in
#"Changed Type"

 

Thanks & Regards,

Sujeesh