# Download data from data table visualization using webapi calls

**URL:** https://discuss.elastic.co/t/download-data-from-data-table-visualization-using-webapi-calls/242793
**Category:** Kibana
**Created:** [July 27, 2020, 6:18pm UTC](https://discuss.elastic.co/t/download-data-from-data-table-visualization-using-webapi-calls/242793 "2020-07-27T18:18:24Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![MyQuery](https://avatars.discourse-cdn.com/v4/letter/m/839c29/32.png) [@MyQuery](https://discuss.elastic.co/u/MyQuery)
#### Post date: [July 27, 2020, 6:18pm UTC](https://discuss.elastic.co/t/download-data-from-data-table-visualization-using-webapi-calls/242793/1 "2020-07-27T18:18:24Z")

</div>

Hi ,

I want to fetch my visualize/ dashboard data in Kibana from the API  
How do I approach this issue ?  
I need to get the data from data table and would like to use in format and send it to users

---

<div class="post-metadata">

### Author: ![kelk](https://avatars.discourse-cdn.com/v4/letter/k/13edae/32.png) [@kelk](https://discuss.elastic.co/u/kelk)
#### Post date: [July 27, 2020, 8:08pm UTC](https://discuss.elastic.co/t/download-data-from-data-table-visualization-using-webapi-calls/242793/2 "2020-07-27T20:08:29Z")

</div>

you could use the Kibana API (runs on port 5601)

Following is a sample...

```auto
db_id="7adfa750-4c81-11e8-b3d7-01146121b73e"
kibana_host_port="192.168.1.2:5601"
creds="elastic:changeme"
export_file="/tmp/sample.json"
space_uri="api" # Put this to s/<space_name>/api if you have configured your-own space

# GET
curl -u ${creds} -X GET "${kibana_host_port}/${space_uri}/kibana/dashboards/export?dashboard=${db_id}" -o ${export_file}

```

let me know how it goes

---

<div class="post-metadata">

### Author: ![MyQuery](https://avatars.discourse-cdn.com/v4/letter/m/839c29/32.png) [@MyQuery](https://discuss.elastic.co/u/MyQuery)
#### Post date: [July 28, 2020, 8:05pm UTC](https://discuss.elastic.co/t/download-data-from-data-table-visualization-using-webapi-calls/242793/3 "2020-07-28T20:05:54Z")

</div>

Thank you Kin for the script. Do you have equivalent windows script?

---

<div class="post-metadata">

### Author: ![kelk](https://avatars.discourse-cdn.com/v4/letter/k/13edae/32.png) [@kelk](https://discuss.elastic.co/u/kelk)
#### Post date: [July 28, 2020, 8:26pm UTC](https://discuss.elastic.co/t/download-data-from-data-table-visualization-using-webapi-calls/242793/4 "2020-07-28T20:26:02Z")

</div>

I don't unfortunately. But the above should be quite easy to convert into powershell  
(or could download git bash or mintty etc to do in Windows with the above linux style commands)

---

<div class="post-metadata">

### Author: ![MyQuery](https://avatars.discourse-cdn.com/v4/letter/m/839c29/32.png) [@MyQuery](https://discuss.elastic.co/u/MyQuery)
#### Post date: [July 28, 2020, 8:52pm UTC](https://discuss.elastic.co/t/download-data-from-data-table-visualization-using-webapi-calls/242793/5 "2020-07-28T20:52:56Z")

</div>

Hi Kin, I used the id of my visualization and getting below error. Looks like script is not recognizing the visualization id . I pulled the id from below section.

![image](https://us1.discourse-cdn.com/elastic/original/3X/1/5/158b3e4da4af13ba944241ae12cb2788f3f0a1e2.png)

Am i doing wrong in pulling the db\_id?  
u295488-C02RTA4MG8WP:Junk u295488$ more /tmp/sample.json  
{  
"version": "7.4.2",  
"objects": [  
{  
"id": "d1aae8a0-cd09-11ea-89ee-114cb6a733e9",  
"type": "dashboard",  
"error": {  
"statusCode": 404,  
"message": "Not found"  
}  
}  
]  
}

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 3, 2020, 6:50am UTC](https://discuss.elastic.co/t/download-data-from-data-table-visualization-using-webapi-calls/242793/7 "2020-09-03T06:50:16Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.