Tibco Spotfire Actions¶
Actions are the operations (or API operations) that you can perform on database applications you select while creating the connection by a simple drag and drop and data mapping of elements and values from the input trigger, derived values using formulas or desired constants that you may wish to map.
To show you how Tibco Spotfire actions work in Connect iPaaS, we will use the use-case of a business wanting to put service outage incident data from ServiceNow in Spotfire to help build an analysis of outage history.
As shown below in Figure 1, you can Create, Update, Delete, and Upsert data in your dataset database based on the response to a trigger event.
Create data in response to an event trigger into the selected table.
Select the table from the database in which you have to create a record. After the table selection, all the
Not Null columns of your tables will be shown as required fields.
You can add optional fields of the table using
+ button. You can map field data using trigger data or you can use excel functions. You can also use the evaluate functionality to map values directly from the trigger attributes.
For example in Figure 2 below, some attributes from ServiceNow are mapped to values of multiple fields of a new data point in the dataset.
Delete one or multiple database records in response to an event trigger. You can selectively delete data from the dataset based on a configurable condition.
Select the table in your database from which you want to delete the data. You can use the
Choose where condition to add the conditions for selecting the data-points to be deleted. You can use simple
AND-OR conditions to select the data-points to delete.
For example, in Figure 3 below, for the data-set
Incident, all the data which have the
INCIDENT_STATE as "Open" and
INCIDENT_DESCRIPTION as the "Short Description" from the ServiceNow event trigger will be deleted in the dataset.
Updates one or multiple data-points in response to an event trigger. You can selectively update data-points in the dataset based on a configurable condition.
Select the data-set in your database where you want to update the data. Now you can add the conditions to select the records that will be updated. You can use simple
AND-OR conditions to have more control over what data-points to update.
In the figure below, whenever an Incident has been updated on ServiceNow, a data-point is updated in the Tibco Spotfire's data-set. In the
Incident data-set, the
CLOSED_BY is updated by the event triggers' "Closed-By" and the
TIME_OF_INCIDENT is updated to the current date and time can be added using the excel function
Now() only if the
INCIDENT_STATE is "Open".
Upsert operation is the combination of Update and Create operations. Connect iPaaS will check to see if the data-point exists within the data-set and update it if it exists. If it doesn't then it will create a new data-point.
In the figure below, whenever an Incident is updated in ServiceNow, a data-point will be updated or added in the Tibco Spotfire's data-set. The data-set or table
INCIDENT has a new data point that is updated or created by using the mapped data from the ServiceNow's incident's "Short Description" and "Closed By".