cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 184 members 2,187 guests
Please welcome our newest community members: