Querying ElasticSearch using a JSON file through JAVA API

Question

I have a query in valid JSON format which works well in kibana or Sense when I use GET request.I am also able to create this query using XContentBuilder, but I need to send this query using its JSON form as it is to ElasticSearch. Is it possible to store the query in a JSON file and query ElasticSearch using this JSON file.

My query -

{
  "min_score":5,
  "sort" : [
    {
      "_geo_distance" : {
        "location" : [40.715, -73.988],
        "order" : "asc",
        "unit" : "km",
        "mode" : "min",
        "distance_type" : "arc"
      }
    }
  ],
  "query": {
    "bool": {
      "must": {
        "query_string": {
          "query": "hospital",
          "analyzer": "english"
        }
      },
      "filter": {
        "geo_distance": {
          "distance": "50000km",
          "location": {
            "lat": 40.715,
            "lon": -73.988
          }
        }
      }
    }
  }
}

What I want is to store this query in a JSON file and use this JSON file to send a search request directly without using Query builder.

This is not well supported by the offical ES API: discuss.elastic.co/t/… — MartinSchulze
– MartinSchulze, Commented Aug 26, 2017 at 12:46
Yeah, it was possible in the earlier versions, but the current version of ES does not support it. — Utkarsh Gupta
– Utkarsh Gupta, Commented Aug 26, 2017 at 15:33

alr · Accepted Answer · 2017-08-27 18:07:08Z

1

You can use a search template, and store this template in the cluster state, see the official documentation about search templates, especially about pre-registered templates.

answered Aug 27, 2017 at 18:07

alr

1,8041 gold badge12 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Utkarsh Gupta Over a year ago

Yeah, Search templates can be used to send this json query directly to elastic search.

Collectives™ on Stack Overflow

Querying ElasticSearch using a JSON file through JAVA API

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related