Skip to main content

Python interface for the Strategy One REST API

Project description

Strategy One Logo

image image image

mstrio-py: Simple and Secure Access to Strategy One Data

Installation

Prerequisites

  • Python in version 3.10.x, 3.11.x, 3.12.x or 3.13.x
  • MicroStrategy 2019 Update 4 (11.1.4)+

Install mstrio-py Package

Note: it is NOT recommended to install mstrio-py in an Anaconda environment. For a seamless experience, install and run it in Python's virtual environment instead.

Install latest version of mstrio-py using pip command in Terminal:

pip install mstrio-py

To install a specific, archived version of mstrio, choose the desired version available on PyPI package archive and install with pip, as follows:

pip install mstrio-py==10.11.1

Issues or specific use cases

If there are any issues with the installation process it is possible your setup may differ from usual. In that case, please see below some examples of most common situations and how to resolve them.

In all other cases, please refer to the official Python libraries installation guide.

Offline System or Proxy with Blacklisted PyPI

Note: optimally, you should contact your system administrator and either request access to PyPI or some proxy setup whitelisting all or some of the PyPI libraries.

If your setup does not allow to get packages online directly from Python Packages Index (PyPI) using pip, you can download the package manually and install it locally.

  1. download .whl file from here: https://pypi.org/project/mstrio-py/#files
  2. in the terminal cd into a folder where you want to install mstrio-py
  3. use the command provided below after filling the path
    • py -m tells the terminal to use default install execution of python available locally on the machine
    • --user flag says "install only for my user on this machine"
  4. If you have issues with py command, try the same with python instead
cd path/where/mstrio/will/be/installed
py -m pip install --user path/to/downloaded/wheel/file/mstrio-py.whl

No Python or pip Installed on the Machine

You cannot use mstrio-py without Python installed on your machine unless directly via Strategy Workstation.

Documentation

Detailed information about mstrio-py package can be found in official documentation.

Main Features

Main features of mstrio-py allows to access Strategy One data:

  • Connect to your Strategy One environment using Connection class (see code_snippets)

    Note: to log into Library and use mstrio-py user needs to have UseLibrary privilege.

  • Import and filter data from a OlapCube, SuperCube or Report into a Pandas DataFrame (see code_snippets)

  • Export data into Strategy One by creating or updating SuperCube (see code_snippets)

Since version 11.3.0.1, mstrio-py includes also administration modules:

Versioning & Changelog

Current version: 11.6.2.101 (13 February 2026). Check out CHANGELOG to see what's new.

mstrio-py is constantly developed to support newest Strategy One REST APIs. Functionalities may be added to mstrio on monthly basis. It is recommended to always install the newest version of mstrio-py, as it will be most stable and still maintain backwards compatibility with various Strategy One installations, dating back to 11.1.4.

Features that will be added to the package but require APIs not supported by your environment (I-Server), will raise VersionException.

mstrio-py can be used for both, data-science related activities and for administrative tasks. Former requires at least MicroStrategy 2019 Update 4 (11.1.4), latter works with 11.2.1 and higher.

If you intend to use mstrio with MicroStrategy 2019 Update 3 (11.1.3) or older, refer to the PyPI package archive to download mstrio 10.11.1, which is supported on:

  • MicroStrategy 2019 (11.1)
  • MicroStrategy 2019 Update 1 (11.1.1)
  • MicroStrategy 2019 Update 2 (11.1.2)
  • MicroStrategy 2019 Update 3 (11.1.3)

Refer to the PyPI package archive for a list of available versions.

Additional Information

mstrio-py Configuration

You can customize some global mstrio-py's behavior by setting global configuration. Learn more in config code snippets.

Search for ID without additional data

mstrio-py has a dedicated method to identify what a particular object is knowing only its ID. Learn more in search actions code snippet

Deprecating Features

When features (modules, parameters, attributes, methods etc.) are marked for deprecation but still accessed, the following DeprecationWarning will be shown (example below). The functionality will continue to work until the version specified in the warning is released.

Deprecation warning

More Resources

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mstrio_py-11.6.2.101.tar.gz (703.5 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

mstrio_py-11.6.2.101-py3-none-any.whl (735.5 kB view details)

Uploaded Python 3

File details

Details for the file mstrio_py-11.6.2.101.tar.gz.

File metadata

  • Download URL: mstrio_py-11.6.2.101.tar.gz
  • Upload date:
  • Size: 703.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.19

File hashes

Hashes for mstrio_py-11.6.2.101.tar.gz
Algorithm Hash digest
SHA256 4540264ac15d1f225fff5fd836804877ab38d72e10a276d3a35f6b17bdb8afa7
MD5 bbd7f2d3f48809d24cd2db8a76970df2
BLAKE2b-256 8702f84d85e550da80eff8d80ce055763d2346770a769c34642df5dd90fcfedc

See more details on using hashes here.

File details

Details for the file mstrio_py-11.6.2.101-py3-none-any.whl.

File metadata

  • Download URL: mstrio_py-11.6.2.101-py3-none-any.whl
  • Upload date:
  • Size: 735.5 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.10.19

File hashes

Hashes for mstrio_py-11.6.2.101-py3-none-any.whl
Algorithm Hash digest
SHA256 2bb9445319733d8403992254de5e3eba567ab0f9ec4363dad481e067b18f5462
MD5 36fd395ebb86b27d1b4102702a1e01db
BLAKE2b-256 4b5c28be97796b973a36c4373e289c121209e5d6395d2f4d5968102cc338fc34

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page