Extract elasticsearch data to json file

Extrect elasticsearch Data.md

1. Download transformEsData.py
2. Open your terminal and go to downloaded path
3. Copy this script and replace {your index path} with your index
4. Replace username:password for Kibana
5. Execute in terminal

curl -XGET -u username:password "http://localhost:9200/{your index path}/_search?filter_path=hits.hits._source" -H 'Content-Type: application/json' -d'{  "query": {    "match_all": {}  }}' | python transformEsData.py

A file named esdata.json is generated in the same folder

transformEsData.py

#!/usr/bin/env python
import sys
import json


def transform(data):
    with open('esdata.json', 'w') as file:
        jsonData = json.loads(data)["hits"]["hits"]
        jsonData = list(map(lambda x: x["_source"], jsonData))
        json.dump(jsonData, file)

data = sys.stdin.read()
transform(data)