Share via

InvalidPageResponse

Sreeja VARANAMKUDATH 1 Reputation point
2022-06-02T05:11:59.447+00:00

Hi,

Get rows (Oracle) with paging turned on and threshold set to 100,000 throws error:
Currently the view has 30K rows.

InvalidPageResponse. The response is not a valid paginated response. The paginated response should not have the same non-empty 'nextLink' or 'odata.nextLink' property from the previous page when there are no items in the 'value' property.

Do you have a solution?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MayankBargali-MSFT 70,996 Reputation points Moderator
    2022-06-07T15:23:15.77+00:00

    @Sreeja VARANAMKUDATH Thanks for reaching out. As per the error it looks like the nextLink or odata.nextLink property was not present in the response. As you have mentioned you are able to retrieve the 30K rows so it looks like you might be hitting the response size limit of 8 MB as documented here. Please validate if the size is more than 8 MB? If now please share the failed run ID's, region where your logic app is deployed and the exact timeframe of the issue (in UTC) so I can validate it at my end.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.