Product UpdatesStatus PageAutomation Institute
English
Workflow apps
Builder experience
Workflow apps connector

# Search requests action

Search requests in a Workflow app matching criteria you specify.

# Input

Workflow app
Select the Workflow app from which you plan to retrieve lists.
Filters
Add one or more filters to the query. All filters must contain the Column name, Operand, and Value. All filters are chained using AND.
Column name
Available column names depend on the Workflow app you select and the columns available in its corresponding data table.
Operand
Available operands depend on the Workflow app you select and the column types present in its corresponding data table.
Short text
Available operands:
  • Equals
  • Is not equal to
  • Is null
  • Is not null
Long text
Available operands:
  • Equals
  • Is not equal to
  • Is null
  • Is not null
Integer
Available operands:
  • 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
Available operands:
  • 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
Available operands:
  • Is true
  • Is false
  • Is null
  • Is not null
Date
Available operands:
  • Equals
  • Is not equal to
  • Is before
  • Is after
  • Is on or before
  • Is on or after
  • Is null
  • Is not null
DateTime
Available operands:
  • Equals
  • Is not equal to
  • Is before
  • Is after
  • Is on or before
  • Is on or after
  • Is null
  • Is not null
Value
The value you enter must match the data type of the column and the operand you select.
Sort by
Organize search results by column name. The available options depend on the Workflow app you select and the columns available in its corresponding data table.
Sort direction
Order search results in ascending or descending order.
Limit
Determine how many records to fetch. Default value: 100 Maximum value: 1,000
Next page token
Get records starting from the specified offset.

# Output

Output is dynamic and may vary depending on the actions and triggers in your recipe, as well as the columns present in your Workflow app's corresponding data table.

To use this data in downstream steps, map in the relevant datapill from the datatree.

Request
This JSON object includes the following available attributes. Additional output is available depending on the Workflow app you select and its data table.
Record ID
Workato automatically generates a unique ID for each record in a Workflow app's corresponding data table.
Active task
A nested JSON object within the Request object.
This object is empty if there is not an active task associated with the request.
Available attributes include
Task ID:
The ID of the task.
Task name:
The name of the task.
Status:
The task's status.

Assigned user:
A nested JSON object within the Assigned task object.
This object is empty if the task is assigned to a group.
Available attributes include
User ID:
The ID of the user assigned to the task.
User name:
The name of the user assigned to the task.
Email:
The email of the user assigned to the task.
Status:
The status of the user assigned to the task.
Assigned group:
A nested JSON object within the Assigned task object.
This object is empty if the task is assigned to an individual user.
Available attributes include
User ID:
The ID of the user assigned to the task.
User name:
The name of the user assigned to the task.
Email
The email of the user assigned to the task.
Status
The status of the user assigned to the task.
Due date:
The due date of the task.
Created by
A nested JSON object within the Request object.
Available attributes include
User ID:
The ID of the user who created the request.
User name:
The name of the user who created the request.
Email:
The email of the user who created the request.
Status:
The status of the user.

Groups
A nested JSON object within the Created by object.
Available attributes include
Group ID:
The ID of the group this task is assigned to.
Group name:
The name of the group this task is assigned to.
List size
List index
Stage
A nested JSON object within the Request object.
Available attributes include
Stage ID:
The ID of the group this task is assigned to.
Group name:
The name of the group this task is assigned to.
Created at
The date the record was created.
Updated at
The date the record was most recently updated.
Next page token
Get records starting from the specified offset.
← Remove user action
Update request action →


Last updated: 2/13/2024, 1:10:22 AM

On this page