Creating a loop for API call with __next property to get next set of records

Question

Hi All,Working with an API which has a limited response of 1000 records.If there are more, a __next property will be given. Calling this link will provide the next 1000 records, etc.Although there are some similiar requests on the community, i didnt managed to connect the dots yet.&nbsp;My goal is to get the data from all _next property links and turn the response data into a table.See below for further explanation.&nbsp;Thanks!!Bas&nbsp;Example code:let&nbsp;&nbsp;&nbsp;&nbsp;Source&nbsp;=&nbsp;Json.Document(Web.Contents("&lt;LINK&gt;?$format=json",&nbsp;[Headers=[Authorization="Basic&nbsp;&lt;Auth.Code&gt;"]])),&nbsp;&nbsp;&nbsp;&nbsp;d&nbsp;=&nbsp;Source[d]in&nbsp;&nbsp;&nbsp;&nbsp;d&nbsp;&nbsp;

v-frfei-msft · Answer

Hi&nbsp;ClevHR&nbsp;,
&nbsp;
Hope the third party article can help you.
https://support.socrata.com/hc/en-us/articles/202949268-How-to-query-more-than-1000-rows-of-a-dataset
&nbsp;

pareshredkar · Answer

The link doe not explain the solution. Is ther any solution&gt;

Forum Discussion

Creating a loop for API call with __next property to get next set of records

2 Replies

Related content

Preserve IoT Hub system properties and user properties

Table Merge creates duplicate records

External Data Properties

Creating a record from list values

Counting Non-Blank Records