Help with looping through pages with JSON API

[natureorigin01]

Hello,

I have the folling API with multiple pages:

let
Source = Json.Document(Web.Contents("https://dev.getflycrm.com/api/v3/accounts", [Headers=[#"X-API-KEY"="SIVnWouOVARaUuSoZPSvk89zf6uzmU"]]))
in
Source

I want to extract all the records but do not know how to create a loop to go through all the pages.

Please help me if you can, thank you!

[amitchandak · Accepted solution]

@natureorigin01 , refer if this can help

https://community.powerbi.com/t5/Desktop/API-Restfull-With-Multiple-Pages/td-p/448418