Forum Discussion
natureorigin01
6 years agoHelper I
Help with looping through pages with JSON API
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!
1 Reply
- amitchandakSuper User
natureorigin01 , refer if this can help
https://community.powerbi.com/t5/Desktop/API-Restfull-With-Multiple-Pages/td-p/448418