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

CDS DataIntegration DataFlow JSON Endpoint Pagination

I'm using a JSON Connection to get through to Harvest time entry API.  This API supports passing auth vai query string so works as a standard connection.

 

I can get the first 100 rows then need to do another request to get the next page. Is there a way to iterate all the pages with a DataFlow?

https://help.getharvest.com/api-v2/introduction/overview/pagination/

 

In PowerQuery for excel there was a way to iterate the pages with some kind of scripting so was kind of hoping there's a way of doing this here.

 

Any help welcome,

Cheers

Si

 

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: CDS DataIntegration DataFlow JSON Endpoint Pagination

Hi @s1m0nj ,

I'm afraid there's no way to change this limit currently in PowerApps.

This is set by system by default.

I suggest you express your views on PowerApps Ideas Forum. Your precious feedback will be very helpful for our work.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: CDS DataIntegration DataFlow JSON Endpoint Pagination

Hi,

Thanks for replying. I really want guidance on a solution.

Can this be done with a custom connector and if so are there any examples I could use as guidance?

Many thanks
Si

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,254)