Custom Table Actions

The Aisera AI Workflow Studio provides Custom Table Actions that you can choose when creating Workflow Action Nodes.

Each of the following Actions is discussed in this topic:

• Delete Custom Table Records

• Get Custom Table Records

• Update/Insert Records in Custom Table

---

Delete Custom Table Records

Description: Deletes one or more records from a custom table based on specified criteria or identifiers. The deletion is permanent and cannot be undone. Use with caution and ensure proper backup procedures are in place if necessary.

Configuration Parameters: This action has no configuration parameters.

Input:

• tableId (String, Required): The ID of the custom table from which records should be deleted.

• payload (String, Required): A JSON string containing the deletion criteria or record identifiers. The structure should specify which records to delete (e.g., by ID or filter conditions).

• botId (Long, Optional): The bot or application ID associated with this action. If not provided, the bot ID from the execution context is used.

Output:

• success (Boolean): A boolean flag indicating whether the delete operation was successful (true) or failed (false).

• response (String): The raw response as a string, including the number of deleted records and status messages.

• mapResponse (Map): The response parsed as a map, providing structured access to deletion results and confirmation data.

---

Get Custom Table Records

Description: Retrieves records from a custom table with optional filtering and pagination. Supports SQL-like WHERE clause filtering for advanced queries and maximum record count limits. Useful for retrieving specific or paginated data sets from custom tables.

Configuration Parameters: This action has no configuration parameters.

Input:

• tableId (String, Required): The ID of the custom table from which to retrieve records.

• maxRecordCount (String, Optional): The maximum number of records to return. Defaults to 100 if not specified.

• filter (String, Optional): A SQL-equivalent WHERE clause to filter records (e.g., status=active AND priority>5). If not specified, all records are returned subject to maxRecordCount.

• botId (Long, Optional): The bot or application ID associated with this action. If not provided, the bot ID from the execution context is used.

Output:

• success (Boolean): A boolean flag indicating whether the retrieve operation was successful (true) or failed (false).

• response (String): The raw response as a string, containing the retrieved records.

• mapResponse (Map): The response parsed as a map, providing structured access to the records and pagination metadata.

---

Update/Insert Records in Custom Table

Description: Updates or inserts records into a custom table. If a record with the same identifier exists, it will be updated; otherwise, a new record will be created.

Configuration Parameters: This action has no configuration parameters.

Input:

• tableId (String, Required): The ID of the custom table in which to update or insert records.

• payload (String, Required): A JSON string containing the record data to update or insert. The structure must conform to the custom table schema.

• botId (Long, Optional): The bot or application ID associated with this action. If not provided, the bot ID from the execution context is used.

Output:

• success (Boolean): A boolean flag indicating whether the update/insert operation was successful (true) or failed (false).

• response (String): The raw response as a string, including status messages or error details.

• mapResponse (Map): The response parsed as a map, providing structured access to response fields and data.