cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
difg Frequent Visitor
Frequent Visitor

Connection to Wrike & pagination

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.
1 ACCEPTED SOLUTION

Accepted Solutions
ZappySys Regular Visitor
Regular Visitor

Re: Connection to Wrike & pagination

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/

 

 

 

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Connection to Wrike & pagination

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
difg Frequent Visitor
Frequent Visitor

Re: Connection to Wrike & pagination

Hi Xiaoxin

 

I'll review the article!

 

Thanks a lot!!!!  Smiley Happy

ZappySys Regular Visitor
Regular Visitor

Re: Connection to Wrike & pagination

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/

 

 

 

View solution in original post

difg Frequent Visitor
Frequent Visitor

Re: Connection to Wrike & pagination

Hi ZappySys

 

I'll review that.

 

Thank you so much!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors