MicroStrategy / mstrio-py

Python integration for MicroStrategy
Apache License 2.0
90 stars 60 forks source link

When I call the to_dataframe() method on the report object after establishing the connection, I receive an 'invalid fields parameter' error #200

Open bsrulku opened 2 months ago

bsrulku commented 2 months ago

python version is : 3.10.15 mstrio-py version is : 11.4.6.101 I tried to connect to MicroStrategy and fetch reports using Python. I encountered an error, but there is no clear information about which field is causing the issue. You can find the code snippet I wrote below.


from mstrio.project_objects import Report from mstrio.connection import get_connection, Connection

conn = Connection(base_url="my_url", username="my_username", password="pass", project_name="my_project") REPORT_ID = "report_id"

my_report = Report(connection=conn, id=REPORT_ID, parallel=False)

print(my_report.attributes) print(my_report.metrics)

Screenshot 2024-09-20 at 14 58 23

print(my_report.to_dataframe())


**Error getting report *** contents. I-Server Error ERR006, Invalid "fields" param. It should be either empty, or a comma-separated list of field names without whitespace. A field name can only contain alphanumeric character and must start with a letter.

apiotrowskiMicroStrategy commented 1 month ago

Hi @bsrulku

We will look into the issue and I'll get back to you with an update, when ready.