Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
@natureorigin01 , refer if this can help
https://community.powerbi.com/t5/Desktop/API-Restfull-With-Multiple-Pages/td-p/448418
@natureorigin01 , refer if this can help
https://community.powerbi.com/t5/Desktop/API-Restfull-With-Multiple-Pages/td-p/448418
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |