# Request for Assistance in Extracting Fields and corresponding values from Elasticsearch

**URL:** <https://discuss.elastic.co/t/request-for-assistance-in-extracting-fields-and-corresponding-values-from-elasticsearch/376869>\
**Category:** Elasticsearch\
**Created:** [April 7, 2025, 12:32pm UTC](https://discuss.elastic.co/t/request-for-assistance-in-extracting-fields-and-corresponding-values-from-elasticsearch/376869 "2025-04-07T12:32:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![elastic\_interogation](https://avatars.discourse-cdn.com/v4/letter/e/d78d45/32.png) [@elastic\_interogation](https://discuss.elastic.co/u/elastic_interogation)\
**Post date:** [April 7, 2025, 12:32pm UTC](https://discuss.elastic.co/t/request-for-assistance-in-extracting-fields-and-corresponding-values-from-elasticsearch/376869/1 "2025-04-07T12:32:39Z")

</div>

Hi,

I am looking to extract all available fields from my Elasticsearch index along with their possible values. I have more than 500 fields to extract.

My goal is to create a comprehensive table where:

- Each column represents a different field, with the field name displayed at the top.
- Each column contains all possible values associated with that field.

Could you please provide guidance on how to achieve this in Kibana or suggest any best practices for visualizing this data effectively? Given that I don't have access to the Dev tools. (Only Analytics: Discover/Dashboard/Canvas)

Thank you!

---

<div class="post-metadata">

**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\
**Post date:** [April 8, 2025, 8:01am UTC](https://discuss.elastic.co/t/request-for-assistance-in-extracting-fields-and-corresponding-values-from-elasticsearch/376869/2 "2025-04-08T08:01:46Z")

</div>

Hi @elastic_interogation,

Welcome! To confirm, you don't have access to DevTools? The easiest way is to use the [`_mapping` API](https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-get-mapping.html) using either DevTools or via a cURL command in the terminal to extract the column names:

`curl -X GET "localhost:9200/my-index-000001/_mapping?pretty"`

To get all possible values you could write a script to get all fields using mapping and then use a simple [terms aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html) specifing the `size` parameter, but you would need to eb mindful of the buckets limit.

Hope that helps!