Actions168
- Bot Actions
- Call & Meeting Actions
- Channel Actions
- Add Bot to Channel
- Add Channel Members
- Approve Channel
- Archive Channel
- Change Channel Member Role
- Change Channel Permission
- Create Channel
- Delete Channel
- Get Channel
- Get Channel Members
- Join Channel
- Leave Channel
- List Channels
- Reject Channel
- Remove Bot From Channel
- Remove Channel Members
- Remove Single Channel Member
- Unarchive Channel
- Update Channel
- Chat Actions
- Cliq Database Actions
- Custom Domain Actions
- Custom Email Actions
- Department Actions
- Designation Actions
- Event Actions
- File Actions
- Maintenance (Bulk Export) Actions
- Message Actions
- Message Component Builder Actions
- OAuth Helper Actions
- Reaction Actions
- Reminder Actions
- Remote Work Actions
- Role Actions
- Team Actions
- Thread Actions
- User Actions
- User Field Actions
- User Status Actions
- Widget Map Ticker Actions
Cliq Database → List Records
AI-generatedSummary
Retrieves records from a specified Zoho Cliq database table, with support for filtering, sorting, pagination, and AI error mode.
Inputs
- enableAiErrorMode — Whether to return errors as output items (continue-on-fail style) instead of stopping execution. Recommended for AI Tool runs that should recover from API errors.
- tableName (required) — Cliq database unique name (for example, neightntestdatabase). Use the exact unique name, not display label.
- additionalFields — Configuration for filtering, sorting, and limiting results. Includes Criteria (filter expression), From Index (0-based start), Limit (max results, default 50, min 1, max 100), Order By (sort expression), and Start Token (for pagination).
Output shape
A list of items, each containing a record from the database.
Supports pagination via the 'Start Token' field. Records are returned as JSON objects. The 'Criteria' parameter supports expressions like 'status==open'.
Examples
Example 1: Fetch the first 50 open records from a database named 'sales_data'.
tableName: 'sales_data', additionalFields.criteria: 'status==open', additionalFields.limit: 50
Example 2: Retrieve a specific page of records by providing the start token from a previous response.
tableName: 'sales_data', additionalFields.startToken: 'previous_token_string'
Example 3: Get a paginated list of records sorted by a specific column.
tableName: 'sales_data', additionalFields.orderBy: '+timestamp', additionalFields.limit: 20