The API Gateway doesn't currently support payload based logic/policy of that sort. For this purpose I'd suggest to implement in CAI process.
That said we do intend to add payload size based policies.
Thanks for your reply Could you please elaborate how to use Informatica CAI process to implement pagination as I am new to this.
Please can you send me email so we can discuss this offline.
This can be achieved using the Cloud Application Integration Product design.
Our JDBC connector supports OData (and OData standards support pagination). You may want to refer Create JDBC Connection - YouTube and Using JDBC Connection in a Process - Using OData and Pagination - YouTube to understand how such a process be created.
With 20.01-1 release, we have also enabled swagger for JDBC-OData connection that can be wrapper in a Process which can be later exposed in API manager. Needless to say, currently we do not expose OData endpoints into API Manager.
Informatica Cloud Product Management