Actioner tables integration
Learn about actions in Actioner tables integration and how to use them in your workflows.
Actioner tables integration allow you to perform operations on the records of your tables. You can
- Create new records on the table you select.
- Delete records on the table you select.
- Get a record on the table you select.
- Search records on the table you select.
- Conduct semantic search on your table records.
- Update a record on the table you select.
- Partially update a record on the table you select.
Actions in Actioner tables integration
Create record
Use this action to create a new record in the selected table. To create a new record in your data table,
Select Actioner tables integration on your node.
Select Create record action on the opening list.
Select your table on Table field. Available options are the tables in your app.
Fill out TABLE FIELDS. These are the fields in the selected table.
If you do not enter any value to ID field, Actioner automatically assigns a random UUID to the new record.
To dynamically generate the values for record fields, you can write expressions inside double curlies - {{ }}.
Expressions let you reference to values in your workflows, such as the inputs or the trigger event or the data in the responses of earlier nodes.
Delete record
Use this action to delete a record in the selected data table. To delete a record from your data table,
Select Actioner tables integration on your node.
Select Delete record action on the opening list.
Select your table on Table field. Available options are the tables in your app.
TABLE FIELDS open up. On ID field, select the record you want to delete.
To dynamically generate the record's ID, select Dynamic option from the gear ⚙️ right near the field and then write an expression inside double curlies - {{ }}.
Expressions let you reference to values in your workflows, such as the inputs or the trigger event or the data in the responses of earlier nodes.
Get record
Use this action to retrieve a record in the selected data table. This action returns the selected record. To retrieve multiple records, use Search record action instead. To retrieve a record from your data table,
Select Actioner tables integration on your node.
Select Get record action on the opening list.
Select your table on Table field. Available options are the tables in your app.
TABLE FIELDS open up. On ID field, select the record you want to retrieve.
To dynamically generate the record's ID, select Dynamic option from the gear ⚙️ right near the field and then write an expression inside double curlies - {{ }}.
Expressions let you reference to values in your workflows, such as the inputs or the trigger event or the data in the responses of earlier nodes.
Search records
Use this action to retrieve the records in the selected data table with the matching query. To search records in your data table,
Select Actioner tables integration on your node.
Select Search records action on the opening list.
Select your table on Table field. Available options are the tables in your app.
TABLE FIELDS open up. On Query field, enter your search query.
To dynamically generate values for the search query, you can write expressions inside double curlies - {{ }}.
Expressions let you reference to values in your workflows, such as the inputs or the trigger event or the data in the responses of earlier nodes.
Semantic search
This action only works for tables that semantic search is enabled. Visit Semantic search page to learn how to leverage AI for more powerful and accurate search results.
Use this action to retrieve the records by conducting a semantic search in your tables. To search records in your data table,
Select Actioner tables integration on your node.
Select Semantic search action on the opening list.
Select your table on Table field. Available options are the tables in your app.
TABLE FIELDS open up. On Text field, enter your semantic search keyword(s).
On Filter query field, enter your filter query.
On Limit field, enter the number of results that will be returned. You can enter a value between 1 and 25.
To dynamically generate values for the text or query, you can write expressions inside double curlies - {{ }}.
Expressions let you reference to values in your workflows, such as the inputs or the trigger event or the data in the responses of earlier nodes.
Update record
Use this action to update a record in the selected data table. To update a record in your data table,
Select Actioner tables integration on your node.
Select Update record action on the opening list.
Select your table on Table field. Available options are the tables in your app.
TABLE FIELDS open up. On ID field, select the record you want to update.
To dynamically generate the values for record fields, select Dynamic option from the gear ⚙️ right near the field and then write an expression inside double curlies - {{ }}.
Expressions let you reference to values in your workflows, such as the inputs or the trigger event or the data in the responses of earlier nodes.
This action also lets you perform upsert operation by enabling Upsert option. If a record exist with the given ID, this action updates that record with the new values you provide. If a record does not exist with the given ID, this action creates a new record with the new values you provide.
Click on Fields to see your record's fields. Here, you'll see the list of fields in the seleted data table. Enter the updated values for your record.
Partially update records
Use this action to update only the specific fields of your record in the selected data table. To partially update a record in your data table,
Select Actioner tables integration on your node.
Select Partially update record action on the opening list.
Select your table on Table field. Available options are the tables in your app.
TABLE FIELDS open up. On ID field, select the record you want to update its specific fields.
To dynamically generate the values for record fields, select Dynamic option from the gear ⚙️ right near the field and then write an expression inside double curlies - {{ }}.
Expressions let you reference to values in your workflows, such as the inputs or the trigger event or the data in the responses of earlier nodes.
Click on Fields to see your record's fields. Here, add the field(s) you want to update and then select Set or Remove option.
- Set option replaces the field's value with the new value.
- Remove option empties the value of the record.
If you selected Set option, enter the updated value for the selected field.