xml2json¶

Signature

xml2json(xml)

Description

Returns JSON as a string for given XML string

Examples

EUUSeurope-west1

select bigfunctions.eu.xml2json('<a><b>foo</b></a>')

select bigfunctions.us.xml2json('<a><b>foo</b></a>')

select bigfunctions.europe_west1.xml2json('<a><b>foo</b></a>')

+-------------------+
| json              |
+-------------------+
| {"a":{"b":"foo"}} |
+-------------------+

EUUSeurope-west1

select bigfunctions.eu.xml2json('<a></a>')

select bigfunctions.us.xml2json('<a></a>')

select bigfunctions.europe_west1.xml2json('<a></a>')

+----------+
| json     |
+----------+
| {"a":""} |
+----------+

EUUSeurope-west1

select bigfunctions.eu.xml2json('<a></a')

select bigfunctions.us.xml2json('<a></a')

select bigfunctions.europe_west1.xml2json('<a></a')

+------+
| json |
+------+
| null |
+------+