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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (64,392)