Skip to main content

Reload the schema synchronously

Available since 2021 Update 1
tip

You can try out this workflow at REST API Playground.

Learn more about MicroStrategy REST API Playground here.

This workflow sample demonstrates how to reload (update) the schema synchronously.

You want to reload (update) the schema synchronously in the MicroStrategy Tutorial project . The project ID is B7CA92F04B9FAE8D941C3E9B7E0CD754.

info

Get the authorization token needed to execute the request with POST /api/auth/login.

Get the project ID from GET /api/projects.

Reload (update) the schema synchronously using POST /api/model/schema/reload.

Sample Request Header:

"accept": "application/json"
"X-MSTR-AuthToken": "ouddou5qdd421ndfpjqd6ssman"
"X-MSTR-ProjectID": "B7CA92F04B9FAE8D941C3E9B7E0CD754

Sample Request Body

"updateTypes" is required in the request body. This field can be empty, contain any of the following options, or all of them:

  • "table_key": Use this option if you changed the key structure of a table.
  • "entry_level": Use this option if you changed the level at which a fact is stored.
  • "logical_size": Use this option to recalculate logical table sizes and override any modifications you made to logical table sizes.
{
  "updateTypes": ["table_key", "entry_level", "logical_size"]
}

Sample Curl:

curl -X POST "https://demo.microstrategy.com/MicroStrategyLibrary/api/model/schema/reload" \
-H "accept: application/json" \
-H "X-MSTR-AuthToken: ouddou5qdd421ndfpjqd6ssman" \
-H "X-MSTR-ProjectID: B7CA92F04B9FAE8D941C3E9B7E0CD754" \
-H "Content-Type: application/json" \
-d '{"updateTypes":["table_key, entry_level, logical_size"]}'

Sample Response Body: Empty

Response Code: 201 (The schema reload synchronous call executes successfully.)