# Search records action (batch)

The Search records batch action retrieves a list of entries that match the search criteria you specify from a data table.

# Input

Input fields Description
Data table Select the data table you plan to search. Click the link in this field's description to view the selected data table.
Filters Add filters to the query. Filters are chained using AND logic. This field has some additional sub-fields:

  • Column name: Select the column you plan to filter by.
  • Operand: Specify an operator to define how to compare the returned column values against the Value you set. Refer to Available operands to see the valid operators for each column type.
  • Value: Provide the value to compare against the returned column values. The value you enter must match the data type of the column and the operand you select.
Sort by Select a property to sort the results by.
Sort direction Select whether to order search results in Ascending or Descending order.
Limit Enter the maximum number of entries you plan to retrieve each trigger event. The default value is 100 and the maximum is 200.
Next page token Optional. Provide the token from a previous response here to return the next page of results.
Choose the desired output format Optional. Specify how to map the retrieved record data to the table fields. Refer to the Output formats section for more information.

# Output

Output fields Description
Records Contains information about the retrieved records, such as their Record ID, List index, Updated at timestamp, and data from any of the data table's custom columns.
Next page token The token for the next page of results.

# Available operands

The operands you can use to filter your data table vary based on your selected column's data type:

Short text

The following operands are available:

  • Equals
  • Is not equal to
  • Starts with
  • Is null
  • Is not null
Long text

The following operands are available:

  • Equals
  • Is not equal to
  • Starts with
  • Is null
  • Is not null
Integer

The following operands are available:

  • Equals
  • Is not equal to
  • Is less than
  • Is greater than
  • Is less or equals
  • Is greater or equals
  • Is null
  • Is not null
Decimal

The following operands are available:

  • Equals
  • Is not equal to
  • Is less than
  • Is greater than
  • Is less or equals
  • Is greater or equals
  • Is null
  • Is not null
Boolean

The following operands are available:

  • Is true
  • Is false
  • Is null
  • Is not null
Date

The following operands are available:

  • Equals
  • Is not equal to
  • Is before
  • Is after
  • Is on or before
  • Is on or after
  • Is null
  • Is not null
DateTime

The following operands are available:

  • Equals
  • Is not equal to
  • Is before
  • Is after
  • Is on or before
  • Is on or after
  • Is null
  • Is not null
Link to a table

The following operands are available:

  • Equals
  • Is not equal to
  • In
  • Is null
  • Is not null
File

The following operands are available:

  • Equals
  • Is not equal to
  • Is null
  • Is not null
Multi-value

The following operands are available:

  • Contains
  • Is not null
  • Is null


Last updated: 2/18/2025, 8:26:30 PM