Forum Discussion
web api with cursor pagination
With Power Query in Excel I am retrieving data via an Open API that is using pagination (1000 pages per call). I use a function to get one page: //fnOnePage structure
(iCursor) =>
let
sCurs...
Please follow the documentation of Web.Contents to use Relative Path and Query options. If you don't do that your query will not work in the service.
Before you can combine the [res] values you need to translate the JSON into a table format.