json-to-opensearch-format.py

#!/usr/bin/env python3

import json

with open("./target.json", "r") as file:
    target_file = json.load(file)
    for t in target_file["SearchWord"]:
        prefix = {"create": {"_index": "searchword", "_type": "_doc"}}
        words = {
            "word": t["SearchWord"],
            "min_age": t["Min_Age_Years"],
            "max_age": t["Max_Age_Years"],
            "sex": t["Gender"],
            "id": t["AlgorithmID"],
        }

        if not "\r\n" in t["SearchWord"]:
            print(json.dumps(prefix) + "\n" + json.dumps(words))

Usage:

1. Create a target.json file following the pattern:

{
 "SearchWord": [
   {
     "SearchWord": "content"
    }
  ]
}

2. Run the script

chmod u+x ./json-to-opensearch-format.py
./json-to-opensearch-format.py > output

3. Copy the output and insert at opensearch dashboard interactive panel