Zoho Cliq icon

Zoho Cliq

Fully manage your Zoho Cliq workspace: messages, channels, teams, users, databases, events, reminders, bots, files, and more

Actions168

Cliq Database → List Records

AI-generated

Summary

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

Links

Discussion