JsonToXml function with _x in element tag return wrong result

sameerp Nov 7, 2017 12:57 PM

On doing such queries on latest Teiid:

select jsontoxml('root', '{ "my_xvar" : "my_value"}');;

Would return an XML:

<?xml version='1.0' encoding='UTF-8'?><root xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><my_u005F_xvar>my_value</my_u005F_xvar></root>

. Is this expected? Or is there any other way to avoid it?

1. Re: JsonToXml function with _x in element tag return wrong result

shawkins Nov 7, 2017 1:51 PM (in response to sameerp)

> Is this expected?

Yes, it is expected. See the invalid name example - JSON Functions · Teiid Documentation

> Or is there any other way to avoid it?

No any invalid xml name is made valid as per the docs.

Unfortunately this is just a mismatch between the xml and json worlds. We would like at some point to offer a more direct option, such as JSONTABLE, for json processing.
Actions
2. Re: JsonToXml function with _x in element tag return wrong result

sameerp Nov 8, 2017 5:15 AM (in response to shawkins)

Thanks for the quick response!
Actions