# Sql api error . status code 500

**URL:** <https://discuss.elastic.co/t/sql-api-error-status-code-500/365731>\
**Category:** Elasticsearch\
**Created:** [August 29, 2024, 2:01am UTC](https://discuss.elastic.co/t/sql-api-error-status-code-500/365731 "2024-08-29T02:01:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![pope](https://avatars.discourse-cdn.com/v4/letter/p/22d042/32.png) [@pope](https://discuss.elastic.co/u/pope)\
**Post date:** [August 29, 2024, 2:01am UTC](https://discuss.elastic.co/t/sql-api-error-status-code-500/365731/1 "2024-08-29T02:01:29Z")

</div>

when use sql rest api

```auto
post _sql
{
  "query": """
  select site_name,projectName,count(*) from dev_base_info where area_id is not null and dev_name="ss" group by site_name,projectName
  """
}

```

this return : Request failed to get to the server (status code: 500)

i check the es logs , nothing found.

when i change the sql like this:

```auto
post _sql
{
  "query": """
  select site_name,projectName,count(*) from dev_base_info where area_id is not null group by site_name,projectName
  """
}

```

it's ok

is there any config error? the es version is 8.15.0

---

<div class="post-metadata">

**Author:** ![Tortoise](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tortoise/32/147587_2.png) [@Tortoise](https://discuss.elastic.co/u/Tortoise)\
**Post date:** [August 29, 2024, 2:47am UTC](https://discuss.elastic.co/t/sql-api-error-status-code-500/365731/2 "2024-08-29T02:47:22Z")

</div>

Hello,

Could you please try below query and confirm

POST /\_sql?format=txt  
{  
"query": "select site\_name,projectName,count(\*) from dev\_base\_info where area\_id is not null and dev\_name='ss' group by site\_name,projectName"  
}

Thanks

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [August 29, 2024, 6:00am UTC](https://discuss.elastic.co/t/sql-api-error-status-code-500/365731/3 "2024-08-29T06:00:57Z")

</div>

Welcome!

Could you share the elasticsearch logs please?

---

<div class="post-metadata">

**Author:** ![thiagodsrodrigues](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thiagodsrodrigues/32/133778_2.png) [@thiagodsrodrigues](https://discuss.elastic.co/u/thiagodsrodrigues)\
**Post date:** [August 29, 2024, 7:11am UTC](https://discuss.elastic.co/t/sql-api-error-status-code-500/365731/4 "2024-08-29T07:11:11Z")

</div>

No Elasticsearch SQL, é recomendado usar aspas simples para strings em consultas. Alterar sua consulta para usar aspas simples pode resolver o problema:

POST \_sql  
{  
"query": """  
SELECT site\_name, projectName, COUNT(\*)  
FROM dev\_base\_info  
WHERE area\_id IS NOT NULL AND dev\_name = 'ss'  
GROUP BY site\_name, projectName  
"""  
}