Amazon Aurora Actions¶
Actions are the operations (or API operations) that you can perform on Amazon Aurora irrespective of the database engine by simple drag-drop and data mapping of elements and values from the input trigger, derived values using formulas or desired constant that you may wish to map.
All of the actions that you see below automate what you can do manually on Amazon Aurora MySQL or Amazon Aurora PostgreSQL database.
As shown in Figure 1, you can Create, Update, Delete and, Upsert (create new or update the existing) records from database table based in response to a trigger event.
Connect iPaas supports four types of actions irrespective of the database engine.
Create Record¶
Create record(s) on response to the event trigger into selected table. This operation will be performed on the database engine you select.
To create this action you first need to select the table from the database in which you want to create the new record. After the table selection all the required Not Null columns of your tables will be shown as required fields.
You can add optional fields of the table using the + button. You can map fields data using the trigger data panel or you can use Excel-style functions. In case of MySQL, you can also use the evaluate functionality to map values for enum type columns.
For example, in Figure 2, the table Customer Details is selected and the Email, First Name, Last Name, and Store ID fields are mapped from the trigger application, Magento. You can add more fields that are optional (if there is any) by clicking over the little + icon at bottom of the last field. To enable the + icon you need to fill or enter the values in all of the required fields. You also have an option to remove these optional filed by clicking the - icon.
Delete Record¶
Delete one or multiple AWS RDS database records on response to an event trigger. You can filter records based on the selection criteria.
To create this action you first need to select the table in the database from which you want to delete the record(s).
You can use the Choose where condition to add the conditions for selecting the records to be deleted. You can construct complex logic of AND (+) and OR (OR) conditions to select the records.
For example in the below figure, table name is selected from the dropdown and the fields from the table are generated inside the form where you can add where condition.
Update Record¶
Updates one or multiple AWS RDS database records in response to an event trigger. You can update the record from the table based on some condition.
To create this action you first need to select the table in your database in which you want to update the records.
Now you can add the conditions to select the records that will be updated. You can construct the conditions using complex conditional OR (OR) and AND (+) logics.
You can select the updates that you want to perform on the selected records. You can use data Mapping and Transformation and Excel-style functions. In case of MySQL database you can also use the evaluate functionality to map values for enum type columns.
For example in the below figure, table name is selected from the dropdown and you can add where condition on attributes of the table and then fields can be added in order to update the attributes.
Upsert Record¶
Upsert operation is the combination of Update and Create (insert) operations. Connect iPaaS will find if a record with matching Primary Key is present in the table.
If a record is found, the record will be updated with the data provided. If a record is not found, Connect iPaaS will create a new record with the data provided. Primary key can either be a single column or a combination of columns.
For example in Figure 5, the Customer Details table is selected from the dropdown and the required attributes Email, First Name, Last Name and Store ID are shown in the form. If the record does not exist this operation will create a record inside the selected table and update the record if it already exists.
