# How to convert and use an API query into equivalent SQL query in a java class

**URL:** <https://discuss.elastic.co/t/how-to-convert-and-use-an-api-query-into-equivalent-sql-query-in-a-java-class/230026>\
**Category:** Elasticsearch\
**Created:** [April 27, 2020, 8:21pm UTC](https://discuss.elastic.co/t/how-to-convert-and-use-an-api-query-into-equivalent-sql-query-in-a-java-class/230026 "2020-04-27T20:21:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rahul\_layall](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rahul_layall/32/46899_2.png) [@Rahul\_layall](https://discuss.elastic.co/u/Rahul_layall)\
**Post date:** [April 27, 2020, 8:21pm UTC](https://discuss.elastic.co/t/how-to-convert-and-use-an-api-query-into-equivalent-sql-query-in-a-java-class/230026/1 "2020-04-27T20:21:43Z")

</div>

Hello Sir,  
I am executing simple SQL queries from my java class and they are giving me equivalent result as I am executing queries from my java class like this  
boolean ret1=stat.execute("select name from index\_name");

Now,  
I just want to know that  
In Kibana console i am using this query given below

```auto
POST _sql?format=txt
{
  "query": "select name from index_name"
} 

```

How do i write its equivanlent SQL query in my java class  
what should i add in my SQL query for this(POST \_sql?format=txt) part

---

<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:** [April 30, 2020, 8:40am UTC](https://discuss.elastic.co/t/how-to-convert-and-use-an-api-query-into-equivalent-sql-query-in-a-java-class/230026/2 "2020-04-30T08:40:24Z")

</div>

If you really want to use SQL to query elasticsearch, you can use the Low Level client to run whatever HTTP call against an elasticsearch cluster.

Instead I'd use the High Level client and run a "normal" search query.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 28, 2020, 8:40am UTC](https://discuss.elastic.co/t/how-to-convert-and-use-an-api-query-into-equivalent-sql-query-in-a-java-class/230026/3 "2020-05-28T08:40:31Z")

</div>

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