mstr-report-data-service

Microstrategy Report Data Service Task

A Node function for calling Microstrategy's reportDataService task and returning the payload as JSON.

Note

I wrote this library out of necessity at work. - I needed to programatically run a report and receive the data as JSON, but our MSTR instance was pre v10.4. If you have an instance deployed thats v10.4 or higher, I recommend you check out the RESTful JSON API here.

Currently tested and working on Microstrategy v10.1.

Usage

Arg	Type	Description
url	string	url of the Microstrategy's taskProc endpoint.
user	string	username.
pass	string	password.
reportID	string	id of the report you'd like to run. (right click on report > properties)
server	string	name of the Microstrategy server.
project	string	project name.
port [optional]	string	port of the Microstrategy server.

import reportDataService from 'mstr-report-data-service'
// const reportDataService = require('mstr-report-data-service')
 
reportDataService({
    url: 'http://example-reports.com/MicroStrategy/servlet/taskProc',
    user: 'exampleUser',
    pass: 'P@ssw0rd',
    reportID: '20275B0811E6FD2400000080EFC52793',
    server: 'MSTR001',
    port: '0',
    project: 'BI-Reporting'
}).then(result => {
    console.log(result)
}).catch(err => {
    console.log(err)
})