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.
Pairs well with https://support.sisense.com/hc/en-us/community/posts/360004369133-Get-CSV-Of-ElastiCube-Dependencies.
Prerequisites
Tested in Python 3.6. Requires Sisense 7.1+.
Python Packages
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
-
Hi Sam,
We've been using this script to document our Elasticubes, now I'm trying 7.2 it's stopped working reports that the keys from the datasource API call aren't right. I can't call that API from Swagger as it requires a / character for the fully formed Data Source name.
I'd also be interested in seeing the table Tag, Description and field Description fields in the output - is that possible?
Cheers
Ian
Please sign in to leave a comment.
Comments
1 comment