Get CSV Of ElastiCubes, Tables, And Fields Metadata
Introduction
This script exports to CSV a complete list of your ElastiCube servers, ElastiCubes, tables, fields, and field data types.
Prerequisites
Tested in Python 3.6. Requires Sisense 7.1+.
Tested in Python 3.6. Requires Sisense 7.1+.
Python Packages
Requests
JSON
Pandas
Requests
JSON
Pandas
Steps
1. Download and unzip the file here.
2. Update the configuration section. For authentication, you can hard-code a token or use the program to generate a token.
3. Run the script
Sample Output
Updated 03-02-2023
intapiuser
Admin
Joined December 15, 2022