beginTransaction( [datasource] )

Description

This method creates a database transaction against a datasource and returns a transactionId to be supplied with further requests to executeSQL, commitTransaction, and rollbackTransaction. By default the transaction will be opened against the default iCM datasource, but this can be changed by specifying the name of the datasource to use via the optional "datasource" parameter. Supported database types: MSSQL, MySQL, Postgres, and Oracle.

Parameters

datasource (string, optional)

The name of the datasource to open the transaction against. If not supplied this defaults to the iCM datasource.

Example request parameters with optional datasource parameter: { "datasource":"nameOfDataSource" }

Example response: { "transactionId": "de305d54-75b4-431b-adb2-eb6b9e546013" }