Tables
Returns records from the table
get/v3/tables/{tableName}/records
Request
- Base URL: https://demo.caspio.com/integrations/rest
- URL: https://demo.caspio.com/integrations/rest/v3/tables/{tableName}/records
- Auth: API key in header Authorization
Path parameters
tableNamestring required
Table name
Query parameters
q.selectstring
List of fields separated by comma
q.wherestring
WHERE clause
q.groupBystring
GROUP BY clause
q.orderBystring
ORDER BY clause
q.limitinteger
Maximum number of records returned (skipped when q.pageNumber or q.pageSize is not empty, max = 1000, default = 100)
q.pageNumberinteger
Page number (if q.pageSize is not empty then default = 1)
q.pageSizeinteger
Number of records per page (possible values from 1 to 1000, if q.pageNumber is not empty then default = 25)
q.getPaginationInfoboolean
Return pagination info (default is false)
q.sortFieldstring
Simple field name to sort by (e.g. "LastName"). Converted to an ORDER BY clause. Use orderBy for multi-column or expression-based sorting.
q.sortDescendingboolean
When true, sort in descending order. Default: false.
Response
OK
Changes
No recorded changes to this operation across all 1 revision of this API.