Insert Record
Last updated
Was this helpful?
Last updated
Was this helpful?
The Insert Record Node is used to create a new record dynamically from a call plan into a using values stored in . A record is inserted by assigning a value to the predefined Data Table Key Field and adding additional fields and values to include in the record. If you are new to Data Tables, please see for a better understanding of Data Table records and the importance of the Data Table Key Field.
Branch Name
Mandatory
Description
Success
Yes
Taken when a record was successfully inserted into the Data Table.
Record Already Exists
Yes
Taken if the record could not be inserted because the Data Table already contains a record with the specified Key Value.
Failed
Yes
Taken if the Data Table 'Read Only' property is true or the number of records has reached the maximum of 100,000 records. Also taken in the unlikely event that an unexpected platform issue occurred while attempting to access the Data Table.
The first step is to choose the Data Table using the magnifying glass icon. Once this has been done the name of the Key Field for that Data Table is shown. The second step is to enter the value you want to enter for the new record in the Key Value field or select a variable that contains the information. The next step is to specify the fields you want to populate for the new record and the variables that contain the values for them. To do this press the [Add New] button to add to the field selection configuration. The following dialog will be shown:-
The Field Name drop down list will only contain values when the Data Table contains some records. This list is initially populated with the fields found in the first 10 records in the Data Table. Pressing the [Refresh Fields] button will force a full scan of all the Data Table records.
Field Names are not restricted to the values in the drop down list and can be entered manually.
By default, the value contained in the Source Variable will be converted to lowercase characters before the data is inserted into the data table. If you do not want this behaviour then select No from the dropdown list for the Convert To Lowercase option.
The Node Properties are where you to define the fields and values to use when inserting a new record. are used to assign values to the Data Table fields. The example below will insert a new record assigning '01132265408' to the Key Field named 'ServiceNumber'. The new record will also contain 3 additional fields, 'MyNewField' and will be assigned the value of the Custom Service Variable named '@MyNewFieldValue', 'RingDuration' with the value of '@RingDuration' variable and 'Destination' with the value of the '@Destination' variable.
Pressing the button will show the latest audit logs that have been generated by the node for inbound calls.
