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 UpdateDBScriptsResponseelement. |
| XML | Returns the contents of an UpdateDBScriptsResponseelement (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": ""
}
|