Connection to Wrike & pagination

[difg]

We need to recover data from Wrike using an API, but there is a limitation of 1000 records. 

At the time of using the page number to retrieve all the pages, Wrike uses a token 
that is an alphanumeric value that represents the start identifier of the next batch.
I need to make a function in PowerBI that allows me to recover the way to recover 
all records using that value that the api returns.

I have written thousands of function attempts, 
but I can only retrieve the first 1000 records, 
the next token and an error in the next iteration.

If anyone has any idea how I can do it, I will be grateful for the help.

[ZappySys · Accepted solution]

Hi,

Not sure if you are open for 3rd party driver but ZappySys has very easy to use ODBC Drivers for REST API which can connect to any APi and it has many Pagination / Authentication options.

You can write queries like below

SELECT * FROM $
LIMIT 25
WITH(
	 src='https://wordpress.org/news/wp-json/wp/v2/categories?per_page=10'
	,PagingMode='ByResponseHeaderRfc5988'
	,WaitTimeMs='200' --//wait 200 ms after each request
)

Here is an article you can start with.

https://zappysys.com/blog/howto-import-json-rest-api-power-bi/

Check below link for more articles reklated to Power BI and Rest API Integration.

https://zappysys.com/blog/category/odbc-powerpack/odbc-app-integration/bi-reporting-power-bi/

[difg]

Hi ZappySys

I'll review that.

Thank you so much!

[v-shex-msft]

Hi @difg,

I think you can refer to following blog about how to get whole records from paged REST API:

Loading paged and related data from MS Graph API into Power BI using a recursive Power Query functio...

Regards,
Xiaoxin Sheng

[difg]

Hi Xiaoxin

I'll review the article!

Thanks a lot!!!!