Update data in a single-table dataset
PATCH {{baseUrl}}/api/datasets/:datasetId/tables/:tableId
Update a structured dataset with a single table, using external data uploaded to the MicroStrategy Intelligence Server. You obtain the authorization token needed to execute the request using POST /auth/login; you obtain the project ID using GET /projects. You pass the authorization token, the project ID, and the update operation to be performed ('add', 'update', 'upsert', or 'replace') in the request header. You specify the IDs of the dataset and table being updated in the path of the request. You provide the information needed to update the dataset in the body parameter of the request, including the name of the table to be updated, a description of the columns in the table, and the data used by the update operation.
Body
PARAM
| Key | Datatype | Required | Description |
fields
|
null | Comma-separated, top-level field whitelist that allows the client to selectively retrieve part of the response model. If specified, extra filtering is applied, and for top-level object (if root model is an array, each array element), only the listed fields are kept in the response. For example, "id,elements" keeps only the "id" field and whole "elements" array field, omitting all other fields in the top-level response model. |
HEADERS
| Key | Datatype | Required | Description |
X-MSTR-AuthToken
|
string | (Required) Authorization token | |
X-MSTR-ProjectID
|
string | (Required) Project ID | |
updatePolicy
|
string | Update operation type: Add, Update, Upsert, Replace |
RESPONSES
status
ENDPOINTS