cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
* 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 🙂
Rate this article:
Comments
gowtham_sisense
Sisense Team Member
Sisense Team Member

*****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 🙂

 

Version history
Last update:
‎02-09-2024 01:26 PM
Updated by: