query_collection_records
Fetch records from a custom data table by name, with optional filters, sorting, and pagination for targeted data retrieval.
Instructions
Query records from a collection (custom data table) by table name. Supports paging + an optional where filter and order_by sort. (Uses the CMS api-key auth the records endpoint requires.)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number | |
| limit | No | Items per page | |
| where | No | Filter object, e.g. { status: 'active' } — matches records by field value. | |
| order_by | No | Field to sort by (e.g. 'inserted_at'). | |
| table_name | Yes | Collection table name (e.g. 'subscribers', 'custom_orders') — from get_collection.table_name |