14.5 Creating and Testing Read-Only APIs

Create and test read-only REST APIs for collections and single rows.

When your use case calls for reading data, you can build REST APIs using SQL queries. A Collection Query handler lets clients filter, sort, and page through the results, while a Collection Item handler returns a single row. You can test your REST APIs using curl on the command line or tools with a graphical interface like Postman.

• Defining a Read-Only Collection Query
  Define a Collection Query GET handler that returns action items with nested team data.
• Testing Handler with curl or Postman
  Test a GET endpoint with curl and jq or with Postman to inspect the JSON response.
• Filtering/Paging Collection Query Endpoints
  Use query string parameters to filter and page through Collection Query results.
• Configuring a Collection Item Handler
  Define a Collection Item GET handler that returns one action item, given its unique id.