Update a data model external data model
You can try out this workflow at REST API Playground.
Learn more about Strategy REST API Playground here.
This workflow sample demonstrates how to update an external data model through the Modeling service.
Get the authorization token needed to execute the request with POST /api/auth/login.
Get the project ID from GET /api/projects.
Changesets are used in this workflow. For information on how to create and use changesets, see Changesets.
You can update an external data model in a data model using the following endpoint: PATCH /api/model/dataModels/{dataModelId}/externalDataModels/{externalDataModelId}. Only "alias" field can be modified by this API.
Sample Request Header:
"accept": "application/json"
"X-MSTR-AuthToken": "o0ak9privdo27nfo798j40m8aa"
"X-MSTR-MS-Changeset": "805C5F3FB78A436FAE37C943471C24AD"
Sample Request Body:
{
"alias": "updated external data model alias"
}
Sample Curl:
curl -X PATCH "https://demo.microstrategy.com/MicroStrategyLibrary/api/model/dataModels/04DCF4F028354FC0AE4B8120CB1983A6/externalDataModels/AE2FC8E446B14162BF2BCAC64981D5A2" -H "accept: application/json" -H "X-MSTR-AuthToken: o0ak9privdo27nfo798j40m8aa" -H "X-MSTR-MS-Changeset: 805C5F3FB78A436FAE37C943471C24AD" -H "Content-Type: application/json" -d '{"alias":"updated external data model alias"}'
Sample Response Body:
{
"id": "AE2FC8E446B14162BF2BCAC64981D5A2",
"baseDataModel": {
"objectId": "FF2970B298464D88806CCD39F1BA1919",
"subType": "report_emma_cube",
"name": "data model 1"
},
"alias": "updated external data model alias",
"objects": [
{
"objectId": "2877DDA7059B4FFE9DE2711F4D7CD29A",
"subType": "attribute",
"name": "Customer",
"hidden": false,
"alias": "Customer (2)"
},
{
"objectId": "B44A2F49F6B6441796FCA511F1BBFDA5",
"subType": "attribute",
"name": "Churn",
"hidden": false,
"alias": ""
},
{
"objectId": "3FDFCCEFB640428E9341D45B68073601",
"subType": "attribute",
"name": "Lifetime Value Score",
"hidden": false,
"alias": ""
}
]
}
Response Code: 200 (External data model is updated successfully in the changeset.)