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.

Recreate Lookup table behavior

The Data tables connector doesn't include the Get all entries or Lookup entry actions from the Lookup tables connector.

You can recreate similar behavior using the Search records action, though the results and structure may differ:

• Get all entries: Leave the Filters section blank to return all entries. Use the Next page token field to paginate through results.
• Lookup entry: Set the Operand field to Equals, then use the first item in the output Records list as the matching result.

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