# Translate SQL into Elasticsearch queries


**GET /_sql/translate**

**All methods and paths for this operation:**

<div>
                      <span class="operation-verb post">POST</span>
                      <span class="operation-path">/_sql/translate</span>
                      </div>
                    <div>
                      <span class="operation-verb get">GET</span>
                      <span class="operation-path">/_sql/translate</span>
                      </div>
                    

Translate an SQL search into a search API request containing Query DSL.
It accepts the same request body parameters as the SQL search API, excluding `cursor`.

## Required authorization

* Index privileges: `read`



## Servers
- http://api.example.com: http://api.example.com ()


## Authentication methods
- Api key auth
- Basic auth
- Bearer auth


## Parameters



### Body: application/json (object)

- **fetch_size** (number)
  The maximum number of rows (or entries) to return in one response.
- **filter** (object)
  The Elasticsearch query DSL for additional filtering.
- **query** (string)
  The SQL query to run.
- **time_zone** (string)
  The ISO-8601 time zone ID for the search.


## Responses
### 200


#### Body: application/json (object)
- **aggregations** (object)

- **size** (number)

- **_source** (boolean | object)

- **fields** (array[object])

- **query** (object)

- **sort** (string | object | array[string | object])

- **track_total_hits** (boolean | number)



[Powered by Bump.sh](https://bump.sh)