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

X-MSTR-ProjectID

Accept

Get the list of applicable properties for a given incremental refresh report.

Boolean value used to determine whether to show dynamic SQL preview or not.
Set to true by default.


showSqlPreview

"{\n    \"propertyCount\": 175,\n    \"applicableProperties\": {},\n    \"sqlDynamicPreview\": \"[VLDB Report].[Session Based PreStatement]\\n[VLDB Report].[Report PreStatement 1]\\n[VLDB Report].[Report PreStatement 2]\\n[VLDB Report].[Report PreStatement 3]\\n[VLDB Report].[Report PreStatement 4]\\n[VLDB Report].[Report PreStatement 5]\\n\\n[VLDB Create].[Table PreStatement 1]\\n[VLDB Create].[Table PreStatement 2]\\n[VLDB Create].[Table PreStatement 3]\\n[VLDB Create].[Table PreStatement 4]\\n[VLDB Create].[Table PreStatement 5]\\n\\ncreate [VLDB Create].[Table Qualifier] table [VLDB Create].[Table Descriptor] [VLDB Create].[Table Prefix] TABLENAME [VLDB Create].[Table\\nOption] (ATTRIBUTE_COL1 VARCHAR(20) [VLDB Create].[Attribute ID Constraint] , FORM_COL2 CHAR(20), [Attribute non-ID Constraint] FACT_COL3\\nFLOAT) [VLDB Create].[Table Space]\\nprimary index (ATTRIBUTE_COL1, FORM_COL2) [VLDB Create].[Create PostString]\\n\\n[VLDB Insert].[Insert PreStatement 1]\\n[VLDB Insert].[Insert PreStatement 2]\\n[VLDB Insert].[Insert PreStatement 3]\\n[VLDB Insert].[Insert PreStatement 4]\\n[VLDB Insert].[Insert PreStatement 5]\\n\\n[VLDB Insert].[Bulk Insert String] insert into TABLENAME [VLDB Insert].[Insert Table Option] select [VLDB Select].[SQL Hint] A1.COL1 [VLDB\\nSyntax].[Mid Name Alias Pattern] COLUMN1ALIAS, A2.COL2 [VLDB Syntax].[Mid Name Alias Pattern] COLUMN2ALIAS, A3.COL3 [VLDB Syntax].[Mid Name\\nAlias Pattern] COLUMN3ALIAS from TABLE1 A1, TABLE2 A2, TABLE3 A3 where A1.COL1 = A2.COL1 and A2.COL4=A3.COL5 [VLDB Insert].[Post Insert\\nString]\\n\\n[VLDB Insert].[Insert MidStatement 1]\\n[VLDB Insert].[Insert MidStatement 2]\\n[VLDB Insert].[Insert MidStatement 3]\\n[VLDB Insert].[Insert MidStatement 4]\\n[VLDB Insert].[Insert MidStatement 5]\\n\\n[VLDB Insert].[Bulk Insert String] insert into TABLENAME [VLDB Insert].[Insert Table Option] select [VLDB Select].[SQL Hint] A1.COL1 [VLDB\\nSyntax].[Mid Name Alias Pattern] COLUMN1ALIAS, A2.COL2 [VLDB Syntax].[Mid Name Alias Pattern] COLUMN2ALIAS, A3.COL3 [VLDB Syntax].[Mid Name\\nAlias Pattern] COLUMN3ALIAS from TABLE4 A1, TABLE5 A2, TABLE6 A3 where A1.COL1 = A2.COL1 and A2.COL4=A3.COL5 [VLDB Insert].[Post Insert\\nString]\\n\\n[VLDB Insert].[Insert PostStatement 1]\\n[VLDB Insert].[Insert PostStatement 2]\\n[VLDB Insert].[Insert PostStatement 3]\\n[VLDB Insert].[Insert PostStatement 4]\\n[VLDB Insert].[Insert PostStatement 5]\\n\\ncreate [VLDB Create].[Index Qualifier] index [VLDB Create].[Index Prefix] IDX_TEMP1(STORE_ID, STORE_DESC) [VLDB Create].[Index PostString]\\n\\n[VLDB Create].[Table PostStatement 1]\\n[VLDB Create].[Table PostStatement 2]\\n[VLDB Create].[Table PostStatement 3]\\n[VLDB Create].[Table PostStatement 4]\\n[VLDB Create].[Table PostStatement 5]\\n\\nselect [VLDB Select].[SQL Hint] A1.STORE_NBR [VLDB Syntax].[Mid Name Alias Pattern] STORE_NBR, max(A1.STORE_DESC) [VLDB Syntax].[Mid Name\\nAlias Pattern] METRICALIAS from LOOKUP_STORE A1 A1.STORE_NBR = 1 group by A1.STORE_NBR [VLDB Select].[SELECT PostString]\\n\\n[VLDB Report].[Report PostStatement 1]\\n[VLDB Report].[Report PostStatement 2]\\n[VLDB Report].[Report PostStatement 3]\\n[VLDB Report].[Report PostStatement 4]\\n[VLDB Report].[Report PostStatement 5]\\n[Drop Table PreStatement 1]\\n\\ndrop table TABLENAME\\n\\n[Drop Table PostStatement 1]\\n[VLDB Drop].[Post Cleanup Statement 1]\\n[VLDB Drop].[Post Cleanup Statement 2]\\n[VLDB Drop].[Post Cleanup Statement 3]\\n[VLDB Drop].[Post Cleanup Statement 4]\\n[VLDB Drop].[Post Cleanup Statement 5]\\n[VLDB Report].[Session Based PostStatement]\"\n}"

200 OK

Get the list of applicable properties for a given incremental refresh report. Cubes 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 the list of applicable properties for a given incremental refresh report. Cubes MicroStrategy REST API | MicroStrategy REST API Workspace | API documentation

Cubes

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

Cubes 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
showSqlPreview	boolean		Boolean value used to determine whether to show dynamic SQL preview or not. Set to true by default.

Key	Datatype	Required	Description
X-MSTR-AuthToken	string		(Required) Authorization Token
X-MSTR-ProjectID	string		(Required) Project ID
Accept	string