Hi everyone,
I just face a problem in passing a param value in SQL command,
The request is something like this
{
"query": "select * from index where field in (?)",
"params": [
[
"value1",
"value2"
]
]
}
And I get this error
{
"error": {
"root_cause": [
{
"type": "x_content_parse_exception",
"reason": "[1:108] Failed to parse object: unexpected token [START_ARRAY] found"
}
],
"type": "x_content_parse_exception",
"reason": "[1:108] [sql/query] failed to parse field [params]",
"caused_by": {
"type": "x_content_parse_exception",
"reason": "[1:108] Failed to parse object: unexpected token [START_ARRAY] found"
}
},
"status": 400
}
Please let me know what's the thing I missed in this request and how can I correct this.
Thank you in advance.