# How to convert SQL to DSL in opensearch. sql,translate, plugins

**URL:** <https://forum.opensearch.org/t/how-to-convert-sql-to-dsl-in-opensearch-sql-translate-plugins/10686>\
**Category:** Open Source Elasticsearch and Kibana\
**Tags:** discuss, troubleshoot\
**Created:** [August 21, 2022, 10:24am UTC](https://forum.opensearch.org/t/how-to-convert-sql-to-dsl-in-opensearch-sql-translate-plugins/10686 "2022-08-21T10:24:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shivacharan](https://avatars.discourse-cdn.com/v4/letter/s/dbc845/32.png) [@shivacharan](https://forum.opensearch.org/u/shivacharan)\
**Post date:** [August 21, 2022, 10:24am UTC](https://forum.opensearch.org/t/how-to-convert-sql-to-dsl-in-opensearch-sql-translate-plugins/10686/1 "2022-08-21T10:24:21Z")

</div>

How to convert this below SQL to DSL

SELECT \* FROM contact\_names JOIN contacts\_profile\_data ON contact\_names.contact\_id = contacts\_profile\_data.contact\_id

When iam using the below approach  
POST /\_sql/translate  
{  
“query”:“SELECT \* FROM contact\_names JOIN contacts\_profile\_data ON contact\_names.contact\_id = contacts\_profile\_data.contact\_id;”  
}

iam getting this message,  
{“Message”:“Your request: ‘/\_sql/translate’ is not allowed.”}

How can i resolve it .  
please help me out with this.

---

<div class="post-metadata">

**Author:** ![nateynate](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/nateynate/32/4913_2.png) [@nateynate](https://forum.opensearch.org/u/nateynate)\
**Post date:** [August 30, 2022, 10:57pm UTC](https://forum.opensearch.org/t/how-to-convert-sql-to-dsl-in-opensearch-sql-translate-plugins/10686/2 "2022-08-30T22:57:00Z")

</div>

Hi @shivacharan -

I believe you want `POST /_plugins/_sql` - does that work any better for you?

Nate

---

<div class="post-metadata">

**Author:** ![shivacharan](https://avatars.discourse-cdn.com/v4/letter/s/dbc845/32.png) [@shivacharan](https://forum.opensearch.org/u/shivacharan)\
**Post date:** [September 28, 2022, 6:19pm UTC](https://forum.opensearch.org/t/how-to-convert-sql-to-dsl-in-opensearch-sql-translate-plugins/10686/3 "2022-09-28T18:19:23Z")

</div>

Hii @ nateynate  
It not worked  
How can we do multiple index join, like we do in sql (such as inner join left join etc)