REST API - updateDBScripts

The table summarizes the REST API - updateDBScripts.

Request

Format
PUT <baseurl>/globaldata/admin/casemodel/<caseModelID>/updatesql
Path parameters caseModelID. The unique identifier of the case model. This can be obtained by running REST API - getCaseModel or REST API - getCaseModelBasicInfo .
Body UpdateCaseModelScriptsType (required): the component from the UpdateDBScriptsRequest element (from the BusinessDataServicesAdminService schema) that contains the new database script with which to update the existing database scripts.

Response

JSON Returns a JSON representation of the contents of a UpdateDBScriptsResponse element.
XML Returns the contents of an UpdateDBScriptsResponse element (from the BusinessDataServicesAdminService schema)

Example

Request
PUT <baseurl>/globaldata/admin/casemodel/1/updatesql
Body
{
  "xml-fragment": {
    "UpdateCaseModelScripts": {
      "updateScript": "---------------------------------------- TIBCO HEADER ----------------------------------------
-- BOM Name           : ClaimModel.bom
-- BOM Namespace      : com.example.claimbom
-- Namespace Tag      : CLAIMBOM
-- BOM Major Version  : 1
-- Table Mappings     : (BOM Class -> DB Table)
--    com.example.claimbom.Claim                         BDS_1_CLAIMBOM_CLAIM
--    com.example.claimbom.Person                        BDS_1_CLAIMBOM_PERSON
--    com.example.claimbom.Policy                        BDS_1_CLAIMBOM_POLICY
--    com.example.claimbom.Claimant                      BDS_1_CLAIMBOM_CLAIMANT
--    com.example.claimbom.IncidentDetails               BDS_1_CLAIMBOM_INCIDENTDETAILS
--    com.example.claimbom.CustomerNotes                 BDS_1_CLAIMBOM_CUSTOMERNOTES
----------------------------------------------------------------------------------------------
alter table [BDS_1_CLAIMBOM_CLAIM] add [ATTRIBUTE1] nvarchar(400);",
      "operationDetails": "
         "
    }
  }
}
Response
{
       "xml-fragment": ""
}