Limiting the number of records returned by a REST service

Previous Next

You can limit the number of records returned by a REST call that returns multiple records. You do this by passing boundary values that define a subset of the records contained in the query result. Only that subset is returned as the REST response. The boundary values are passed as input parameters in the request URL.

The following step-by-step instructions are for creating a custom REST service that retrieves a limited set of records from a tour catalogue offered by a travel agency.

This example also shows how you can quickly generate a REST service from a SQL statement.

In this particular example, matrix parameters are used, but you have a number of other options when designing input parameters.



collapseDefining SQL
collapseGenerating a REST method based on SQL
collapsePublishing the solution
collapseTesting the implementation


See also


Java output classes returned by Sql()