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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,037)