Skip to main content

SQL actions

List of JSON DB API actions for running SQL

Abstract

List of SQL actions in the JSON DB API, which you can use to query data, manipulate data, and manage database objects. These actions work for all FairCom products that include the FairCom database engine.

List of SQL actions in the JSON DB API, which you can use to query data, manipulate data, and manage database objects. These actions work for all FairCom products that include the FairCom database engine.

Action

Description

"getRecordsUsingSQL"

"getRecordsUsingSQL" uses SQL to retrieve a set of records.

"runSqlStatements"

"runSqlStatements" runs one or more SQL statements, such as drop, create, alter, call, insert, update, and delete statements.