from mstrio import microstrategy
import pandas as pd
import json
from datetime import datetime
from mstrio.api import reports
from mstrio.utils.parsejson import parsejson

base_url = "http://192.168.0.17:8080/MicroStrategyLibrary/api"
project_id = "2916035E465E16431D6012B3FF137342"
login = "administrator"
password = ""

conn = microstrategy.Connection(base_url, username=str(login), password=str(password), project_name="MicroStrategy Tutorial")
conn.connect()
startTime = datetime.now()
limit_value = 500
response = reports.report_instance(connection=conn, report_id = "4B99AC5E41A66BB229D3ABAFEF812562", offset=0, limit=limit_value)
json_response = response.json()
instance_id_value = json_response['instanceId']
print("Instance retrieved")
pagination = json_response['result']['data']['paging']

table_data = [parsejson(response=json_response)]

for _offset in range(limit_value, pagination['total'], limit_value):
    response = reports.report_instance_id(connection=conn, report_id = "4B99AC5E41A66BB229D3ABAFEF812562", instance_id=instance_id_value, offset=_offset, limit=limit_value)
    json_response = response.json()
    table_data.append(parsejson(response=json_response))

    #print(str(json_response['result']['data']['root']['children'][0]['element']['formValues']['DESC']))
instance = pd.concat(table_data)
res_df = pd.DataFrame(instance)
print("CONTENT LOADED   ")
print(len(res_df))
print((datetime.now() - startTime))