Skip to main content

Table requests

Learn how to configure table requests in your actions.

Table requests 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.
  • List all the records on the table you select.
  • Search records on the table you select.
  • Update a record on the table you select.
  • Partially update a record on the table you select.

Adding a new table request​

Navigate to your action's Requests tab in Design mode and add a new request.

Add a new table request

Info

To set values dynamically, such as from your inputs, you can select Dynamic option and reference to your action components within double curlies -- {{}}.

Dynamic option in table request

Table request types​

Create​

Use this request to create a new record in the selected table.

After adding the request, on Fields tab, fill up the fields of your table.

Create table request

Info

To set values dynamically, such as from your inputs, you can reference to your action components within double curlies -- {{}}.

Delete​

Use this request to delete a record in the selected table.

After adding the request, on Fields tab, select the record you want to delete.

Delete table request

Info

Select Dynamic option to dynamically built the record's ID with your action's components, such as your inputs. You can reference to values in your components within double curlies -- {{}}.

Get​

Use this request to retrieve a record in the selected table.

After adding the request, on Fields tab, select the record you want to retrieve.

Get table request

Info

Select Dynamic option to dynamically built the record's ID with your action's components, such as your inputs. You can reference to values in your components within double curlies -- {{}}.

List​

Use this request to list all the records in the selected table.

This request does not require any parameters. After adding the request, you can Run request to see all records in your table.

List table request

Use this request to search records in the selected table.

After adding the request, on Query field, enter a search query.

Search table request

Info

Select Dynamic option to dynamically built the search query with your action's components, such as your inputs. You can reference to values in your components within double curlies -- {{}}.

Update​

Use this request to update a record in the selected table.

After adding the request, on Fields tab, select the record you want to update. When the Upsert option is enabled, if the given ID already exists in the table, this request will update it. If the given ID does not exist, it will create a new record.

Update table request

Info

Select Dynamic option to dynamically built the record's ID and your field values with your action's components, such as your inputs. You can reference to values in your components within double curlies -- {{}}.

Update partial​

Use this request to partially update a record in the selected table.

After adding the request, on Fields tab, select the record you want to update. Then select the field(s) you want to update. You can add, set, or remove the value of the selected field.

  • Add option appends the given value on the request to the current value of the record.

  • Set option replaces the current value of the record's field with the given one on the request.

  • Remove option empties the value of the record.

Partial update table request

Info

Select Dynamic option to dynamically built the record's ID and your field values with your action's components, such as your inputs. You can reference to values in your components within double curlies -- {{}}.