Data Action Nodes
Data actions nodes are often used in workflows as they allow to access and manipulate data from your data models
As we have seen in the Application Data Model section, data models are at the core of your application to store useful data and ensure a dynamic access and update to it.
Data Records can be explored/created/updated/deleted from the app builder interface in the "Data Management" section but also within workflows with "Data Action Nodes".
To add a new data action node in a workflow, click on the "Plus" icon at the top right and then go in the Data section.
There are different types of data actions that you can use in workflows:
Use this node to retrieve a single data record of a given data source.
It requires the following configuration:
- Data Source: you first need to select from which data source (e.g. Users, Products, ...) you want to retrieve the data record
- Fields: usually, you don't want to retrieve all the information for a given data record and you need to specify which information you want to retrieve. If your data model has some relations (e.g. for an AirBnB clone, there is a relation between Places and Users for places owned by users of the platform) you can select information from other data sources that are linked with relations: for example, if I want to retrieve information about a given Place (for an AirBnB clone) I might also need information about the owner (e.g. name, profile picture) and I can specify that in the Field selection.
- Filter: finally you will filter the data record to retrieve by first choosing a UNIQUE field of the data source (by default there is the ID unique field but you might also define other unique fields like username, email, ... to select a data record), then the type of filter (to retrieve a single data record, you will only use "Equal to" filter type) and finally the value for the filter (e.g. email Equal to [email protected]). You can use either STATIC filter or a DYNAMIC filter (view example below where filter value is using a dynamic url parameter called "Place ID")
Example of usage of Get Data Record node in a workflow
You will the be able to use the output of this node in other workflow nodes (e.g. Update Variable, Send Email, ...).
Use this node to retrieve a collection of data records of a given data source.
It requires the following configuration:
- Data Source: (view "Get Data Record")
- Fields: (view "Get Data Record")
- Filters: for this node, you can combine multiple filters and not only one filter.
- Limit: you can limit the number of data records retrieved. This is useful for example to enable pagination (this parameter will be jointly used with the "Page" parameter.
- Page: if you chose to limit the number of data records retrieved, provide the "page" you want to retrieve (e.g. 1, 2, 3...). A classic usage is to bind this parameter to a url parameter called "Page" (when you define your url, you can choose a template like /list-of-users?page=:page, where "page" will be a parameter that can be accessed in workflow nodes configuration)
- Order By: choose a field on which ordering should be configured. You can also select a nested field in case of relations in your data model
- Ordering Type: choose whether the ordering should be Ascending or Descending (e.g. order users by name in an ascending order
Example of usage of a Get Data Collection node in a workflow
Use this node to create a new data record of a given data source.
It requires the following configuration:
- Data Source: select in which data source you want to create a new record
- Fields Mapping: define the properties of the new data record (e.g. in the example below, we create a new task and we have a define 3 properties for this new record: title, category and done status). For each field, you can choose between a STATIC value (e.g. for the done status, we set a default value to False for all the new tasks) or a DYNAMIC value using Data Mapping Tool (e.g. for the title, we use the value of a variable which is updated by an input in the creation form).
Example of usage of a Create Data Record node in a workflow
Use this node to update a single data record of a given data source.
It requires the following configuration:
- Data Source: select in which data source you want to create a new record
- Filter: (view "Filter" property of "Get Data Record") it allows to select which data record should be updated. In the example below, we use the task ID to filter which task will be updated. We use local data (from the parent repeated interface element)
- Fields Mapping: define the properties of the data record that will be updated. Near each field, a checkbox allows to specify which property will be updated. In the example below, we update the done status of a given task so we only select the "Done" field. For each updated field, you can also choose between a STATIC or DYNAMIC value.
Example of usage of a Update Data Record node in a workflow
Use this node to update many data records of a given data source.
Use this node to delete a single data record of a given data source.
Use this node to delete many data records of a given data source.
Use this node to perform an aggregation on data records on a given data source.
For example, you might want to count the number of records matching filters.
Last modified 3yr ago