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)
})