# POST SQL query using Python requests - not working
**URL:** https://discuss.elastic.co/t/post-sql-query-using-python-requests-not-working/185851
**Category:** Elasticsearch
**Tags:** elastic-stack-sql
**Created:** [June 14, 2019, 12:09pm UTC](https://discuss.elastic.co/t/post-sql-query-using-python-requests-not-working/185851 "2019-06-14T12:09:33Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Ged](https://discuss.elastic.co/u/Ged)
#### Post date: [June 14, 2019, 12:09pm UTC](https://discuss.elastic.co/t/post-sql-query-using-python-requests-not-working/185851/1 "2019-06-14T12:09:33Z")
Hi,
I'm trying run below SQL query which works in Kibana console:
> ```
> POST /_sql?format=csv
> {
> "query": "DESCRIBE \"as-log-metrics-2019.06.14\" "
> }
>
> ```
using Python and requests module:
> ```
> json_data = {"query": "DESCRIBE \"as-log-metrics-2019.06.14\" "}
> r = requests.post("http://localhost:9200/_sql?format=csv", data=json_data, headers={'Content-Type':'application/json'})
> print(r)
> print(r.text)
> print(r.request.headers)
> print(r.request.body)
>
> ```
but it's doesn't work.
> ```
>
> {"error":{"root_cause":[{"type":"x_content_parse_exception","reason":"[1:1] [sql/query] failed to parse object"}],"type":"x_content_parse_exception","reason":"[1:1] [sql/query] failed to parse object","caused_by":{"type":"json_parse_exception","reason":"Unrecognized token 'query': was expecting ('true', 'false' or 'null')\n at [Source: org.elasticsearch.transport.netty4.ByteBufStreamInput@63ec79a8; line: 1, column: 7]"}},"status":400}
> {'Accept': '*/*', 'Connection': 'keep-alive', 'Accept-Encoding': 'gzip, deflate', 'Content-Type': 'application/json', 'Content-Length': '47', 'User-Agent': 'python-requests/2.19.1'}
> query=DESCRIBE+%22as-log-metrics-2019.06.14%22+
>
> ```
What am i doing wrong ?
Thanks in advance !
Ged
---
### Author:  [@Ged](https://discuss.elastic.co/u/Ged)
#### Post date: [June 14, 2019, 12:52pm UTC](https://discuss.elastic.co/t/post-sql-query-using-python-requests-not-working/185851/2 "2019-06-14T12:52:30Z")
Got it resolved if anyone will face the same problem.
> ```
> json_data = json.dumps({"query": "DESCRIBE \"as-log-metrics-2019.06.14\" "})
> r = requests.post("http://localhost:9200/_sql?format=csv", data=json_data, headers={'Content-Type':'application/json'})
> print(r.text)
>
> ```
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 12, 2019, 12:52pm UTC](https://discuss.elastic.co/t/post-sql-query-using-python-requests-not-working/185851/3 "2019-07-12T12:52:34Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.