MicroStrategy REST API

MicroStrategy REST API integration on the QodexAI API Network: This public API documentation features ready-to-use APIs, Collections, and more from MicroStrategy SDK.

MicroStrategy REST API | MicroStrategy REST API Workspace | API documentation

X-MSTR-AuthToken

Get a datasource connection for given ID

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.

fields

"{\n    \"name\": \"Test Datasource Connection\",\n    \"id\": \"B5FBC35F1B439F5A4E6AC4B072193C96\",\n    \"description\": \"Test datasource connection.\",\n    \"acg\": 0,\n    \"executionMode\": \"synchronous\",\n    \"maxCancelAttemptTime\": 60,\n    \"maxQueryExeTime\": 0,\n    \"maxConnectionAttemptTime\": 60,\n    \"connectionLifetime\": 36000,\n    \"connectionIdleTimeout\": 60000,\n    \"charEncodingWindows\": \"multibyte\",\n    \"charEncodingUnix\": \"utf8\",\n    \"tablePrefix\": \"\",\n    \"connectionString\": \"\",\n    \"parameterizedQueries\": false,\n    \"extendedFetch\": false,\n    \"database\": {\n        \"login\": {},\n        \"type\": \"sql_server\",\n        \"version\": \"default\"\n    },\n    \"driverType\": \"odbc\",\n    \"oauthParameter\": \"\"\n}"

200 OK

Get a datasource connection for given ID Datasource Management MicroStrategy REST API integration on the QodexAI API Network: This public API documentation features ready-to-use APIs, Collections, and more from MicroStrategy SDK.

Get a datasource connection for given ID Datasource Management MicroStrategy REST API | MicroStrategy REST API Workspace | API documentation

Datasource Management

Datasource Management MicroStrategy REST API integration on the QodexAI API Network: This public API documentation features ready-to-use APIs, Collections, and more from MicroStrategy SDK.

Datasource Management MicroStrategy REST API | MicroStrategy REST API Workspace | API documentation

This workspace contains two collections. To use the collections, you need to select an environment.

<ol>
<li>MicroStrategy REST API: Use it as API Documentation. It contains examples and built-in scripts to saved the context information after some requests, such as authToken, userId.</li>
<li>MicroStrategy REST API Workflows: It contains workflow examples. You can pick a folder and run all the requests.</li>
</ol>

The workspace contains a demo environment file. You can make a copy and change it to your environment.

Log your questions and feedback on <a href="https://github.com/MicroStrategy/rest-api-playground">https://github.com/MicroStrategy/rest-api-playground</a>

Contributions are welcome!

Github

Twitter

Developer Website

MicroStrategy REST API projects on the QodexAI API Network: This public API documentation features ready-to-use APIs, Collections, and more from MicroStrategy SDK.

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.

Key	Datatype	Required	Description
X-MSTR-AuthToken	string		(Required) Authorization token