SharpenDB INSERT
- John Kargol
The "SharpenDB INSERT" panel is a powerful tool designed for users to execute INSERT queries on custom tables and data within SharpenDB. This feature enables users to customize table schemas and data fully. By utilizing this functionality, users can make informed decisions and enhance the customer experience with unique and engaging content.
Using the panel
The "SharpenDB INSERT" panel enables organizations to insert data in accordance with the configured Logic. For instance, a caller's Automatic Number Identification (ANI) can be recorded in a table based on the selections made during their interaction. This data can then be dynamically utilized to enhance the caller's experience during subsequent interactions.
Configuration
Set as Flow Initiator: Selecting "Set as Flow Initiator" designates this panel as the starting point of the IVR flow, initiating the sequence before progressing to subsequent panels within the Logic+ flow.
Panel Name: Choose a consistent name for the panel, and specify the variable to update. If the variable does not already exist, it will be created.
Panel Description: Provide a clear description detailing the panel's purpose and functionality. This acts as documentation, facilitating better understanding and identification of the panel's intended use by others.
Test: Evaluate the functionality of the configured query to ensure it performs as expected.
View JSON: Display the results of the query in JSON format for structured data analysis.
View Table: Present the query results in a tabular format for easy readability and comparison.
Table: Select an existing SharpenDB table to use and query
Use Dropdown: Select a table that exists in the environment.
Use Variable: A user-defined variable containing a string that matches a pre-existing SharpenDB table.
Fields: Selectable fields/column names that exist in a SharpenDB table.
Use Dropdown: Selectable “fields” that exist in the selected SharpenDB table.
Use Variable: A user-defined variable containing a string that matches a pre-existing field in the SharpenDB table.
Value: The value to be inserted into the selected field.
Timeout: Configurable amount of time, in seconds, to wait for the SharpenDB query to respond with a result set.
Use Dropdown: Specify a numerical value for when the time-out is met.
Use Variable: A user-defined variable containing a numerical value.
Exit Paths: Use the dropdown menu to select another panel in your flow. Any output from this panel will advance to the linked panel.
Default: The Default path is taken upon panel execution.
Timeout: The request time out was met, likely due to a non-performant query.
Related Article(s):