cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ParthNikhra
New Member

Handling Pagination of JSON response received from HTTP GET Custom API

Settings.PNGI am using MS flows and trying to retrieve Office 365 audit log search report using Office 365 management API there are more than 3000 items but only getting 100 results. I have already enabled the required Pagination settings(refer to the provided screen shot) and constructed the API as per the requirement. I am using HTTP connector to access the below API.

https://outlook.office365.com/psws/service.svc/UnifiedAuditLog?StartDate=@{variables('StartDate')}&E...

 

Could you please let me know how to retrieve all the items in a report ?

 

1 REPLY 1
v-yamao-msft
Community Support
Community Support

Hi @ParthNikhra,

 

Please check the doc about pagination at here:

https://flow.microsoft.com/en-us/blog/four-connector-action-settings/

 

From the doc we know that Pagination enables you to handle more records than are returned in a single call from a service. For example, some services only return back 50 items at a time, however, in the flow, you may want to get all the items in the list. By turning on pagination, the flow engine will continue to call the service until it has all of the items.

 

About your scenario, if you have more than 3000 items, you could turn on Pagination and set the limit to 5000. As currently the maximum items that flow can return is 5000. Please check the doc on limits for more details:

https://docs.microsoft.com/en-us/flow/limits-and-config

 

Please take a try with it on your side.

 

Best regards,

Mabel Mao

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,626)