APIs
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Export a table from the elasticube to a CSV

* Disclaimer: This works for Windows only. It will work in future with Linux versions as well. Once it does, I will update the post. Sometimes, we need to export a table from the Elasticube to a CSV file. We can then import it to the next build, to s...

intapiuser by Community Team Member
  • 1426 Views
  • 1 comments
  • 0 kudos

Schedule Download Of SQL API Queries To CSV

Introduction With the Python script below and the Window Scheduler, you can automate the download of csv files based on queries of the SQL API to the elasticube. This type of process comes in handy when a user needs to download information regularly...

intapiuser by Community Team Member
  • 1285 Views
  • 1 comments
  • 0 kudos

Get number of rows in elasticubes

Though there is no direct API endpoint to get the number of rows in an elasticube, there is an endpoint to run SQL directly against a cube. Using PySense, it is straightforward to iterate through all your elasticubes, run SELECT COUNT(*) from each ta...

intapiuser by Community Team Member
  • 1120 Views
  • 0 comments
  • 2 kudos