# Invalid SQL query

**URL:** <https://forum.opensearch.org/t/invalid-sql-query/19742>\
**Category:** SQL\
**Created:** [June 10, 2024, 5:26am UTC](https://forum.opensearch.org/t/invalid-sql-query/19742 "2024-06-10T05:26:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![m\_pahlevanzadeh](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/m_pahlevanzadeh/32/7468_2.png) [@m\_pahlevanzadeh](https://forum.opensearch.org/u/m_pahlevanzadeh)\
**Post date:** [June 10, 2024, 5:26am UTC](https://forum.opensearch.org/t/invalid-sql-query/19742/1 "2024-06-10T05:26:53Z")

</div>

I have the following code with python:

```auto
import requests

response = requests.get("https://admin:mypasswd@localhost:9200/_cat/plugins?v", verify=False)
print(response.text)
query = {"query": "select service from fortigate-alias;"}
response = requests.post("https://admin:mypasswd@localhost:9200/_plugins/_sql/" , data=query, json=query, headers={"Content-Type": "application/json"}, verify=False)
print(response.text)

```

Then I get the following error:

```auto
{
 "error": {
       "reason": "Invalid SQL query",
       "details": "Failed to parse payload",
       "type": "IllegalArgumentException"
  },
  "status": 400
}

```

And I don’t have any error with curl:

```auto

curl --insecure -u 'admin:mypasswd' -XPOST https://localhost:9200/_plugins/_sql -d '{"query": "select * from fortigate-alias"}' -k -H 'Content-Type: application/json'

```

---

<div class="post-metadata">

**Author:** ![m\_pahlevanzadeh](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/m_pahlevanzadeh/32/7468_2.png) [@m\_pahlevanzadeh](https://forum.opensearch.org/u/m_pahlevanzadeh)\
**Post date:** [June 10, 2024, 5:36am UTC](https://forum.opensearch.org/t/invalid-sql-query/19742/2 "2024-06-10T05:36:27Z")

</div>

You have to `import json` module. Then pass `data=json.dumps(query)`

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/mauve_hedgehog/original/2X/3/33547ea01a5b12dcca2958411d3edd97ae2ea8c1.png) [@system](https://forum.opensearch.org/u/system)\
**Post date:** [August 9, 2024, 5:36am UTC](https://forum.opensearch.org/t/invalid-sql-query/19742/3 "2024-08-09T05:36:39Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.