Forum Discussion
sujeesh
Helper I
6 years agoHow 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
1 Reply
- artemus
Microsoft Employee
You need to add the $top parameter: