Export a table from the elasticube to a CSV

[intapiuser]

* 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 send it to a colleague, to back up or any other usage.

(In the Sisense Desktop version, we could have done it using the export to CSV post plugin. However, this is not available in the WEB ECM).

The method described below utilities the API call:

http://localhost:8081/api/datasources/LocalHost/ECName/sql?query=select%20*%20from%20TableName&format=csv

If there are spaces in the name of the EC or of the table name, use %20.

Happy exporting 🙂

[Anonymous]

*****UPDATE*****

Now, you can do the same thing on Linux as well. Using the 0.9 REST API: 
GET​/datasources​/{cubeName}​/sql 

https://something.sisense.com//api/datasources/ECName/sql?count=-1&includeMetadata=true&format=csv&query=Select%20%2A%20From%20TABLE_NAME

Hope this helps. 
Happy exporting 🙂