# Transforms API not admitting triple quotes

**URL:** <https://discuss.elastic.co/t/transforms-api-not-admitting-triple-quotes/232681>\
**Category:** Elasticsearch\
**Created:** [May 14, 2020, 3:53pm UTC](https://discuss.elastic.co/t/transforms-api-not-admitting-triple-quotes/232681 "2020-05-14T15:53:14Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Xavier\_Marti\_Bofill](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/xavier_marti_bofill/32/67923_2.png) [@Xavier\_Marti\_Bofill](https://discuss.elastic.co/u/Xavier_Marti_Bofill)\
**Post date:** [May 14, 2020, 3:53pm UTC](https://discuss.elastic.co/t/transforms-api-not-admitting-triple-quotes/232681/1 "2020-05-14T15:53:15Z")

</div>

We are trying to create a transform using painless scripts for aggregations, such as explained [here](https://www.elastic.co/guide/en/elasticsearch/reference/7.7/transform-painless-examples.html#painless-top-hits).

In Kibana's dev tools, we use Transforms Preview and it works wonderfully.

However, whenever we want to post the transform via API or through Kibana' transform creation interface, it seems that ES won't accept the triple quotes.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/e/6e290e42243194c8ba204111f405d98ba3a7805e.jpeg)

Any idea on what are we doing wrong?

---

<div class="post-metadata">

**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\
**Post date:** [May 14, 2020, 3:59pm UTC](https://discuss.elastic.co/t/transforms-api-not-admitting-triple-quotes/232681/2 "2020-05-14T15:59:01Z")

</div>

Triple quotes are a formatting nicety of Kibana. When it posts to the elasticsearch API however it converts it into legal JSON without the triple quotes. You can see this if you open the "network" part of Chrome's developer tools to see what content is actually sent to elasticsearch.

---

<div class="post-metadata">

**Author:** ![Hendrik\_Muhs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hendrik_muhs/32/25802_2.png) [@Hendrik\_Muhs](https://discuss.elastic.co/u/Hendrik_Muhs)\
**Post date:** [May 14, 2020, 6:25pm UTC](https://discuss.elastic.co/t/transforms-api-not-admitting-triple-quotes/232681/3 "2020-05-14T18:25:29Z")

</div>

Mark already answered regarding the API I will ask around regarding the UI, you mean the advanced editor, correct?.

---

<div class="post-metadata">

**Author:** ![Hendrik\_Muhs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hendrik_muhs/32/25802_2.png) [@Hendrik\_Muhs](https://discuss.elastic.co/u/Hendrik_Muhs)\
**Post date:** [May 14, 2020, 6:42pm UTC](https://discuss.elastic.co/t/transforms-api-not-admitting-triple-quotes/232681/4 "2020-05-14T18:42:10Z")

</div>

Good news, the advanced editor glitch is a known issue and has already been fixed in `7.7`: [https://github.com/elastic/kibana/pull/58015](https://github.com/elastic/kibana/pull/58015)

---

<div class="post-metadata">

**Author:** ![Xavier\_Marti\_Bofill](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/xavier_marti_bofill/32/67923_2.png) [@Xavier\_Marti\_Bofill](https://discuss.elastic.co/u/Xavier_Marti_Bofill)\
**Post date:** [May 15, 2020, 8:11am UTC](https://discuss.elastic.co/t/transforms-api-not-admitting-triple-quotes/232681/5 "2020-05-15T08:11:51Z")

</div>

Great, using single\_quote + one\_liner works. I will do this until we update to 7.7.  
Thanks both!

---

<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:** [June 12, 2020, 8:11am UTC](https://discuss.elastic.co/t/transforms-api-not-admitting-triple-quotes/232681/6 "2020-06-12T08:11:59Z")

</div>

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