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 UpdateDBScriptsResponse 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": ""

}