elasticsearch-rs icon indicating copy to clipboard operation
elasticsearch-rs copied to clipboard

[ENHANCEMENT] Passing parameters to query

Open Jasperav opened this issue 3 years ago • 1 comments

As stated here: https://www.elastic.co/guide/en/elasticsearch/reference/master/sql-rest-params.html

Jasperav avatar Feb 20 '22 20:02 Jasperav

Hey @Jasperav, it's already possible to do this

let client = Elasticsearch::default();
let response = client.sql()
    .query()
    .body(json!({
        "query": "SELECT YEAR(release_date) AS year FROM library WHERE page_count > ? AND author = ? GROUP BY year HAVING COUNT(*) > ?",
        "params": [300, "Frank Herbert", 0]
    }))
    .format("txt")
    .send()
    .await?;

let text = response.text().await?;

russcam avatar Aug 26 '22 13:08 russcam