List Entries
list_entriesFetch content entries from a collection using advanced filters, sorting, and pagination. Supports powerful 'where' queries for precise results.
Instructions
List content entries for a collection with advanced filtering, sorting, and pagination. Use the 'where' parameter for powerful queries. Read the 'query-reference' resource for full documentation on operators and examples.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sort | No | Sort by field:direction, comma-separated for multiple. Examples: 'created_at:desc', 'title:asc,created_at:desc'. Supports core columns (id, created_at, updated_at, published_at) and custom field names. | |
| count | No | If true, return only the count of matching entries: { count: N } | |
| first | No | If true, return only the first matching entry as a single object instead of an array | |
| limit | No | Limit the number of results (ignored if paginate is set) | |
| state | No | Filter by state: 'draft' or 'published'. Defaults to published entries. | |
| where | No | Filter conditions as a nested object. Supports operators: eq, lt, lte, gt, gte, not, like, in, not_in, null, not_null, between, not_between. Simple: { "state": "published" }. With operators: { "price": { "lt": 50 }, "title": { "like": "news" } }. OR group: { "or": [{ "tags": "clearance" }, { "campaign": { "name": "Summer" } }] }. Relation filter: outer key = relation field on this collection; inner keys = field names on the related entry, e.g. { "author": { "name": { "eq": "John" } } }. Core columns (id, uuid, locale, state, created_at, updated_at, published_at) can be filtered directly. | |
| locale | No | Filter by locale (e.g. 'en') | |
| offset | No | Skip N results (requires limit to be set) | |
| exclude | No | Comma-separated field names to exclude from response (e.g. 'content,excerpt') | |
| paginate | No | Enable pagination with N items per page. Returns paginated response with meta data. Overrides limit/offset. | |
| collection_slug | Yes | The collection slug |