codelibs / Elasticsearch Dataformat
Licence: apache-2.0
Excel/CSV/BulkJSON downloads on Elasticsearch.
Stars: ✭ 135
Programming Languages
java
68154 projects - #9 most used programming language
Projects that are alternatives of or similar to Elasticsearch Dataformat
Pytablewriter
pytablewriter is a Python library to write a table in various formats: CSV / Elasticsearch / HTML / JavaScript / JSON / LaTeX / LDJSON / LTSV / Markdown / MediaWiki / NumPy / Excel / Pandas / Python / reStructuredText / SQLite / TOML / TSV.
Stars: ✭ 422 (+212.59%)
Mutual labels: excel, json, csv, elasticsearch
Dbwebapi
(Migrated from CodePlex) DbWebApi is a .Net library that implement an entirely generic Web API (RESTful) for HTTP clients to call database (Oracle & SQL Server) stored procedures or functions in a managed way out-of-the-box without any configuration or coding.
Stars: ✭ 84 (-37.78%)
Mutual labels: excel, json, csv
Filecontextcore
FileContextCore is a "Database"-Provider for Entity Framework Core and adds the ability to store information in files instead of being limited to databases.
Stars: ✭ 91 (-32.59%)
Mutual labels: excel, json, csv
Foxylink
An easy way to handle integration tasks in a reliable way and run them on 1C:Enterprise server
Stars: ✭ 77 (-42.96%)
Mutual labels: json, csv, elasticsearch
Vscode Data Preview
Data Preview 🈸 extension for importing 📤 viewing 🔎 slicing 🔪 dicing 🎲 charting 📊 & exporting 📥 large JSON array/config, YAML, Apache Arrow, Avro, Parquet & Excel data files
Stars: ✭ 245 (+81.48%)
Mutual labels: excel, json, csv
Sheetjs
📗 SheetJS Community Edition -- Spreadsheet Data Toolkit
Stars: ✭ 28,479 (+20995.56%)
Mutual labels: excel, json, csv
Elasticsearch loader
A tool for batch loading data files (json, parquet, csv, tsv) into ElasticSearch
Stars: ✭ 300 (+122.22%)
Mutual labels: json, csv, elasticsearch
Sqlitebiter
A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / SQLite / SSV / TSV / Google-Sheets to a SQLite database file.
Stars: ✭ 601 (+345.19%)
Mutual labels: excel, json, csv
Magento2 Import Export Sample Files
Default Magento 2 CE import / export CSV files & sample files for Firebear Improved Import / Export extension
Stars: ✭ 68 (-49.63%)
Mutual labels: excel, json, csv
Dataportals.org
Open Data Portals and Sites around the world
Stars: ✭ 87 (-35.56%)
Mutual labels: json, csv
Syliuselasticsearchplugin
Elasticsearch integration for Sylius apps.
Stars: ✭ 88 (-34.81%)
Mutual labels: elasticsearch, elasticsearch-plugin
Js2excel
😌 😃 👿 A simple module for excel and json converts each other, which works in the browser.
Stars: ✭ 83 (-38.52%)
Mutual labels: excel, json
Zentity
Entity resolution for Elasticsearch.
Stars: ✭ 97 (-28.15%)
Mutual labels: elasticsearch, elasticsearch-plugin
Ssl Checker
Python script that collects SSL/TLS information from hosts
Stars: ✭ 94 (-30.37%)
Mutual labels: json, csv
Elasticsearch Analysis Hanlp
HanLP Analysis for Elasticsearch
Stars: ✭ 77 (-42.96%)
Mutual labels: elasticsearch, elasticsearch-plugin
Combine Csv Files In The Folder
Tiny script to automate everyday task
Stars: ✭ 91 (-32.59%)
Mutual labels: excel, csv
Iso 3166 Countries With Regional Codes
ISO 3166-1 country lists merged with their UN Geoscheme regional codes in ready-to-use JSON, XML, CSV data sets
Stars: ✭ 1,372 (+916.3%)
Mutual labels: json, csv
Just Dashboard
📊 📋 Dashboards using YAML or JSON files
Stars: ✭ 1,511 (+1019.26%)
Mutual labels: json, csv
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
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.
By default, the 100 first hits are returned.
You can customize hits returned with from and size query parameters.
If you want to download all data, use scroll=1m query parameter.
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 |
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].