Forum Discussion
PowerQuery Post API call to return complete data from all pages.
Hi
Looping is done using List.Generate.
I recently answered some questions related to paging:
- https://community.powerbi.com/t5/Power-Query/how-to-iterate-the-data-of-several-sheets-of-a-web-page...
- and also you can have a look at https://learn.microsoft.com/en-us/power-query/helper-functions#tablegeneratebypage
If you cannot manage to fix it using the above links, please reply and I'll have a look at your code.
Also it will be important to know where is the next page token/number in the API response and how to request the next page.
Please mark this as answer if it helped.
i could see Authorization: Bearer , kvAccessToken is same for all the pages.
when i click on the next page --
{"query":"((end_time ge '2023-01-18T05:28:31Z' and start_time le '2023-02-17T05:28:31Z') and (file_type_name eq 'datalog'))","fields":[],"count":true,"start":100,"limit":100,"sort":{"fieldname":"end_time","order":"desc"}}
Next page ----
{"query":"((end_time ge '2023-01-18T05:30:02Z' and start_time le '2023-02-17T05:30:02Z') and (file_type_name eq 'datalog'))","fields":[],"count":true,"start":200,"limit":100,"sort":{"fieldname":"end_time","order":"desc"}}
seems "start" is the changed every time, then "limit":100 every time.
these days are same for all page, because i choose last 30 days in application...
end_time ge '2023-01-18T05:28:31Z' and start_time le '2023-02-17T05:28:31Z'