Panelstack

[ChristiaanEmpowerBI]

I want to get the information on a dossier that has a filter, panelstack and a visualization on the panelstack.

I am able to get the elementID from
GET: /api/cubes/8E0475AF4BD97ECC9C618189A9493A23/attributes/8D679D3C11D3E4981000E787EC6DE8A4/elements?offset=0&limit=-1
when I run:
GET: /api/dossiers/C3D32F6C48EC04BACC94D281C4ABC936/definition
I do not get a visualization key, nor is there any mention of a panelstack. So how do I get the information on the panelstack, the visualization on the panelstack, and the information inside the visualization that is on the panelstack?

[ChristiaanEmpowerBI]

I ended up using this python code to get it:

def GET_api_v2_dossiers_dossierid_instances_instanceid_chapters_chapterKey_visualizations_vizualizationKey(auth_token, dossier_id, project_id, dossier_instance_id, chapter_key, visualization_key, connection):

api_request = f'/api/v2/dossiers/{dossier_id}/instances/{dossier_instance_id}/chapters/{chapter_key}/visualizations/{visualization_key}'

print(seperator_api)
print('GET:', api_request)
print(seperator)

request_header = {'accept' : 'application/json', 'X-MSTR-AuthToken': auth_token, 'X-MSTR-ProjectID': project_id}

return connection.get(
    endpoint=api_request,
    headers=request_header,
)

[ChristiaanEmpowerBI]

I stopped using the GET: api/cubes/{cubeId}/attributes/{attributeId}/elements because when you have hundreds of thousands of attribute elements it takes more than 10 seconds to retrieve the result. So I enhanced it to create a report off of the cube, with a prompt.

def PUT_api_reports_reportid_instances_instanceid_prompts_answers(auth_token, project_id, report_id, report_instance_id, search_customer_id, JSON_data, connection):
print(seperator_api)

api_request = f'/api/reports/{report_id}/instances/{report_instance_id}/prompts/answers'

key_value = JSON_data[0]['key']
id_value = JSON_data[0]['id']
name_value = JSON_data[0]['name']
type_value = JSON_data[0]['type']
answers_value = search_customer

request_headers = {
    'accept': '*/*', 
    'X-MSTR-AuthToken': auth_token, 
    'X-MSTR-ProjectID': project_id,
    'Content-Type': 'application/json'
}

print('PUT:', api_request)

request_data = {
    'prompts': [
        {
            'key': key_value,
            'id': id_value,
            'name': name_value,
            'type': type_value,
            'answers': f'{answers_value}'
        }
    ]
}

#print('request_data:', request_data)

response = connection.put(
    endpoint=api_request,
    headers=request_headers,
    json=request_data
)

# Check the Response Content-Type
if 'application/json' in response.headers.get('Content-Type', ''):
    try:
        response_body = response.json()
    except Exception as e:
        print(f"Error parsing JSON: {e}")
        response_body = response.text
else:
    response_body = response.text

# Check the HTTP response status code
print("HTTP Response Status Code:", response.status_code)

return response.headers, response_body