Need help with elasticsearch-dataformat?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

codelibs
129 Stars 30 Forks Apache License 2.0 309 Commits 24 Opened issues

Description

Excel/CSV/BulkJSON downloads on Elasticsearch.

Services available

!
?

Need anything else?

Contributors list

Elasticsearch Data Format Plugin

Overview

Elasticsearch Data Format Plugin provides a feature to allow you to download a response of a search result as several formats other than JSON. The supported formats are CSV, Excel, JSON(Bulk) and JSON(Object List).

Version

Versions in Maven Repository

Issues/Questions

Please file an issue.

Installation

$ $ES_HOME/bin/elasticsearch-plugin install org.codelibs:elasticsearch-dataformat:7.6.0

Supported Output Formats

This plugin allows you to download data as a format you want. If the query dsl contains "from" parameter, the query is processed as search query. If not, it's as scan query(all data are stored.).

CSV

$ curl -o /tmp/data.csv -XGET "localhost:9200/{index}/{type}/_data?format=csv&source=..."

| Request Parameter | Type | Description | |:------------------|:-------:|:------------| | append.header | boolean | Append column headers if true | | fields_name | string | choose the fields to dump | | source | string | Query DSL | | csv.separator | string | Separate character in CSV | | csv.quote | string | Quote character in CSV| | csv.escape | string | Escape character in CSV | | csv.nullString | string | String if a value is null | | csv.encoding | string | Encoding for CSV |

Excel

$ curl -o /tmp/data.xls -XGET "localhost:9200/{index}/{type}/_data?format=xls&source=..."

| Request Parameter | Type | Description | |:------------------|:-------:|:------------| | append.header | boolean | Append column headers if true | | fields_name | string | choose the fields to dump | | source | string | Query DSL |

Excel 2007

$ curl -o /tmp/data.xlsx -XGET "localhost:9200/{index}/{type}/_data?format=xlsx&source=..."

| Request Parameter | Type | Description | |:------------------|:-------:|:------------| | source | string | Query DSL |

JSON (Elasticsearch Bulk format)

$ curl -o /tmp/data.json -XGET "localhost:9200/{index}/{type}/_data?format=json&source=..."

| Request Parameter | Type | Description | |:------------------|:-------:|:------------| | source | string | Query DSL | | bulk.index | string | Index name in Bulk file | | bulk.type | string | Type name in Bulk file |

JSON (Object List format)

$ curl -o /tmp/data.json -XGET "localhost:9200/{index}/{type}/_data?format=jsonlist&source=..."

| Request Parameter | Type | Description | | :---------------- | :----: | :----------------------------------------------------------- | | source | string | Query DSL |

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.