Custom query

• GET

  Execute query with data set return

  Execute query with data set return

  Parameters:

  • Connection string, String
  • Custom query, String

  Returns:

  • result, Array [Object]
• GET

  Execute query with scalar return

  Execute query with scalar return

  Parameters:

  • Connection string, String
  • Custom query, String

  Returns:

  • result, Object

Data operations

• GET

  Delete items from table

  Delete items from table

  Parameters:

  • Connection string, String
  • Table name, String
  • Filter, String

  Returns:

  • rowsAffected, Integer
• GET

  Insert item into table

  Insert single row into table

  Parameters:

  • Connection string, String
  • Table name, String
  • Item to insert, Object
  • Enable identity insert, Boolean
  • Identity field name, String
  • Result format, Integer

  Returns:

  • updatedObject, Object
  • rowsAffected, Integer
• GET

  Insert items into table

  Insert items into table

  Parameters:

  • Connection string, String
  • Table name, String
  • Items to insert, Array [Object]
  • Identity field name, String
  • Enable identity insert, Boolean

  Returns:

  • rowsAffected, Integer
• GET

  Save items into table

  Save items into table (using INSERT or UPDATE)

  Parameters:

  • Connection string, String
  • Table name, String
  • Items to insert, Array [Object]
  • Identity field name, String
  • Enable identity insert, Boolean
  • Compare by fields, Array [String]

  Returns:

  • rowsAffected, Integer
• GET

  Select data from table

  Select data from table

  Parameters:

  • Connection string, String
  • Table name, String
  • Fields, String
  • Filter, String
  • Sort by, String
  • Result format, Integer

  Returns:

  • data, Array [Object]
  • count, Integer
• GET

  Update item

  Update single row in table

  Parameters:

  • Connection string, String
  • Table name, String
  • Identity field name, String
  • Item to update, Object
  • Result format, Integer

  Returns:

  • updatedItem, Object
• GET

  Update items in table

  Update items in table

  Parameters:

  • Connection string, String
  • Table name, String
  • Update functions (e.g. Count=Count+2, Name='Test'), String
  • Filter, String

  Returns:

  • rowsAffected, Integer

Database management

• GET

  Create table

  Create new table

  Parameters:

  • Connection string, String
  • Table name, String
  • Fields description, Array [Object]

  Returns:

  • tableMetadata, Object
  • success, Boolean
  • reason, String
• GET

  Delete table

  Delete table

  Parameters:

  • Connection string, String
  • Table name, String

  Returns:

  • success, Boolean
  • reason, String
• GET

  Get table

  Returns table metadata by name

  Parameters:

  • Connection string, String
  • Table name, String

  Returns:

  • tableName, String
  • fieldsMetadata, Array [Object]
• GET

  Tables list

  Get tables list for database

  Parameters:

  • Connection string, String

  Returns:

  • tablesMetadata, Array [Object]
  • databaseName, String
  • success, Boolean
  • reason, String

Stored procedures

• GET

  Execute procedure with objects list return

  Execute procedure and returns array of results

  Parameters:

  • Connection string, String
  • Procedure name, String
  • Parameters, Array [Object]

  Returns:

  • isSuccess, Boolean
  • result, Object
• GET

  Execute procedure with scalar return

  Execute stored procedure with single return value

  Parameters:

  • Connection string, String
  • Procedure name, String
  • Parameters, Array [Object]

  Returns:

  • isSuccess, Boolean
  • result, Object
• GET

  Execute procedure without return

  Execute stored procedure without return value

  Parameters:

  • Connection string, String
  • Procedure name, String
  • Parameters, Array [Object]

  Returns:

  • isSuccess, Boolean
  • result, Object

• No triggers available for this connector