Build Power Query connector within Power BI that fetches paginated results via authenticated API
Budget: $1,500 – $3,000 USD
I am working on building a custom query within Power Query. The connector calls a REST API, authenticates with a username and password, receives a token, and then makes a call to receive paginated data results. I've got the connector built to gather the token and receive the results, but I struggle with the paginated results portion.
Specifically, the API limits the results sent to 100 results per page, and passes a "nextToken" to (a) indicate an additional page of results and (b) use to fetch the next page of results.
I am specifically looking for some assistance in completing the connector to do the following:
1. Pull the first page of the results via the established API access, record the nextToken. Store this page of results in a 'master' table.
2. Using the nextToken from above, fetch the next page of results and append these results to the master table mentioned above.
3. Repeat this process until there is no more next Token, indicating that there are no more additional pages of results.
The end result will be a single master table that has combined all of the paginated results into a single table.
This sounds a lot like a while() loop in other programming languages, but my Power Query skills are not sufficient to code this myself.
Specifically, the API limits the results sent to 100 results per page, and passes a "nextToken" to (a) indicate an additional page of results and (b) use to fetch the next page of results.
I am specifically looking for some assistance in completing the connector to do the following:
1. Pull the first page of the results via the established API access, record the nextToken. Store this page of results in a 'master' table.
2. Using the nextToken from above, fetch the next page of results and append these results to the master table mentioned above.
3. Repeat this process until there is no more next Token, indicating that there are no more additional pages of results.
The end result will be a single master table that has combined all of the paginated results into a single table.
This sounds a lot like a while() loop in other programming languages, but my Power Query skills are not sufficient to code this myself.