Table Activities
In Automation, tables allow you to store structured in tables that are similar to a spreadsheet. You can also use them as the data source for a For Each Loop to iterate through each row in the table.
Note:
-
Table activities have a maximum variable size of 1 MB.
-
As of October 4, 2023, the size of the Large String workflow variable type is limited to 10 MB.
Tables do not use targets or account keys.
The Tables adapter provides the following activities:
- Add Row to Table
- Delete from Table
- Read Table from JSON/Text/XML
- Select from Table
- Update Row in Table
Where Clauses
When you want to select, update, or delete rows in a table, you can provide a where clause to limit the rows affected.
Here are a few examples:
| Sample | Description |
|---|---|
| id == [$variable$] | Where the row’s ID equals the variable provided |
| username == "[$variable$]“ | Where the row’s username equals the variable provided |
| firstName == "[$variable1$] AND lastName == "[$variable2$]“ | Where the row’s first name and last name match the variables provided |
| timestamp > [$variable$/] | Where the row’s timestamp is greater than the variable provided |