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.
- Select Table as request type.
- Give a name to your request.
- Select your table in model field.
- Select the request method. Available options are Create, Delete, Get, List, Search, Update, Update partial
To set values dynamically, such as from your inputs, you can select Dynamic option and reference to your action components within double curlies -- {{}}
.
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.
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.
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.
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.
Search
Use this request to search records in the selected table.
After adding the request, on Query field, enter a search query.
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.
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.
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 -- {{}}
.