Modify data actions

List of JSON DB API actions for modifying data

Abstract

This section lists the JSON actions that modify data in a FairCom database. You can use these actions to insert, update, delete, truncate, and run SQL Data Manipulation Language (DML) statements. SQL DML statements can insert, update, and delete records conditionally. These actions work for all FairCom products that include the FairCom database engine.

Action	Description
deleteRecords	`"deleteRecords"` deletes one or more records from a database table using one or more IDs.
insertRecords	`"insertRecords"` inserts one or more records into a database table - one record for each item in the `"data"` array.
runSqlStatements	`"runSqlStatements"` runs one or more SQL statements, such as drop, create, alter, call, insert, update, and delete statements.
truncateRecords	`"truncateRecords"` is the fastest way to delete all records from a database table because it deletes and recreates the data file. This action succeeds only when no process is using the table.
updateRecords	`"updateRecords"` updates one or more records in a database table.