The SQL REST API accepts SQL in a JSON document, executes it, and returns the results. For example: POST /_xpack/sql?format=txt { "query": "SELECT * FROM library ORDER BY page_count DESC LIMIT 5" } author | name | page_count | release_date -----------------+--------------------+---------------+------------------------ Peter F. Hamilton|Pandora's Star |768 |2004-03-02T00:00:00.000Z Vernor Vinge |A
![SQL REST API | Elasticsearch Guide [6.3] | Elastic](https://cdn-ak-scissors.b.st-hatena.com/image/square/cbbc87b803e58787f8346841e5b65698d408f3c5/height=288;version=1;width=512/https%3A%2F%2Fwww.elastic.co%2Fstatic%2Fimages%2Felastic-logo-200.png)