How to download workbook data using REST API?

Ramiro Sandoval

September 06, 2018 20:42

Hi everyone.

According to the Datameer REST API reference, to download data from workbook (7.x) you have to use the next URI syntax:

curl -u <username>:<password> -X GET 'http://<Datameer-serverIP>:<port-number>/rest/data/workbook/{configuration-id}/{sheet-name}/download

I have been trying with the online demo, with the next URI:

https://online-demo.datameer.com/rest/data/workbook/809/Bank_data/download

And datameer present me the message below:

We are sorry. The session is invalid or has timed out.
The current action was aborted, you have to start again.

What I am doing wrong?

Here the API reference to download data from workbook.

https://www.datameer.com/documentation/current/REST+API+Workbook#RESTAPIWorkbook-Read_GITReadWorkbook(version2)

Best,

Ramiro.

0

Comments

3 comments

Konsta Danyliuk

September 07, 2018 07:38
Hello Ramiro.

I've just tried to download this data from my machine, using my credentials to https://online-demo.datameer.com, via below REST call and got the record in response.
```
curl -u '<username>:<password>' -X GET 'https://online-demo.datameer.com/rest/data/workbook/809/Bank_data/download'
```
What exactly REST call have you tried and what tool you've used to execute it?

If you simply tried to open the URL https://online-demo.datameer.com/rest/data/workbook/809/Bank_data/download in your browser and got the error, I would recommend to clear browser cache, restart it, login into https://online-demo.datameer.com and then try to load this URL again.
0

Comment actions Permalink
Ramiro Sandoval

September 10, 2018 05:29
Actually I have been using Postman to do the request.

I tried with curl and I have been receiving the same message... See image bellow...

I believe that something is wrong with my user. The message said "408 - Invalid Session".
0

Comment actions Permalink
Joel Stewart

September 11, 2018 01:27
There are restricted privileges for users within the Online Demo system. I just double checked and verified that the Download Data privilege is not added to this role in this environment. This explains why you're observing an exception here.
0

Comment actions Permalink

Please sign in to leave a comment.