# GET Kibana API output in table format to send health and nodes details

**URL:** <https://discuss.elastic.co/t/get-kibana-api-output-in-table-format-to-send-health-and-nodes-details/321039>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-alerting\
**Created:** [December 12, 2022, 2:12pm UTC](https://discuss.elastic.co/t/get-kibana-api-output-in-table-format-to-send-health-and-nodes-details/321039 "2022-12-12T14:12:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mangeshmj1992](https://avatars.discourse-cdn.com/v4/letter/m/d9b06d/32.png) [@mangeshmj1992](https://discuss.elastic.co/u/mangeshmj1992)\
**Post date:** [December 12, 2022, 2:12pm UTC](https://discuss.elastic.co/t/get-kibana-api-output-in-table-format-to-send-health-and-nodes-details/321039/1 "2022-12-12T14:12:03Z")

</div>

Hi team,  
I need to send kibana report which contains all values from below API. We need to send this in one email.

Is this possible to create table and send this report in table format.

GET \_cluster/health  
GET /\_cat/allocation?v=true&s=node  
GET \_cat/nodes?v=true&s=name

---

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [December 12, 2022, 2:56pm UTC](https://discuss.elastic.co/t/get-kibana-api-output-in-table-format-to-send-health-and-nodes-details/321039/2 "2022-12-12T14:56:05Z")

</div>

there is no direct way to put this in table. it is json format output.

you need to write your own script which pulls this information and then you create your own output for email.

---

<div class="post-metadata">

**Author:** ![mangeshmj1992](https://avatars.discourse-cdn.com/v4/letter/m/d9b06d/32.png) [@mangeshmj1992](https://discuss.elastic.co/u/mangeshmj1992)\
**Post date:** [December 12, 2022, 3:02pm UTC](https://discuss.elastic.co/t/get-kibana-api-output-in-table-format-to-send-health-and-nodes-details/321039/3 "2022-12-12T15:02:25Z")

</div>

Hi @elasticforme ,  
Thanks for your confirmation. Can you please help me out for variable name for below fields.

**GET \_cat/nodes?v=true&s=name** : ip heap.percent ram.percent cpu load\_1m load\_5m load\_15m node.role master name

**GET /\_cat/allocation?v=true&s=node** : shards disk.indices disk.used disk.avail disk.total disk.percent host ip node

---

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [December 13, 2022, 4:10pm UTC](https://discuss.elastic.co/t/get-kibana-api-output-in-table-format-to-send-health-and-nodes-details/321039/4 "2022-12-13T16:10:45Z")

</div>

what do you mean by variable name? I am not clear on question.

---

<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:** [January 10, 2023, 4:11pm UTC](https://discuss.elastic.co/t/get-kibana-api-output-in-table-format-to-send-health-and-nodes-details/321039/5 "2023-01-10T16:11:31Z")

</div>

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