TO_XML

Converts an object into XML, root element name is optional.

Syntax 

TO_XML(object, root_element_name = "hash")

Usage examples 

Example 1

Input

1
{
2
"my_action": {
3
"object": {
4
"city": "Melbourne",
5
"country": "Australia",
6
"post_code": 3000,
7
"state": "Victoria"
8
}
9
}
10
}

Formula

TO_XML(my_action.object)

Output

"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<hash>\n <city>Melbourne</city>\n <state>Victoria</state>\n <post-code type=\"integer\">3000</post-code>\n <country>Australia</country>\n</hash>\n"

Example 2

Input

1
{
2
"my_action": {
3
"object": {
4
"city": "Melbourne",
5
"country": "Australia",
6
"post_code": 3000,
7
"state": "Victoria"
8
}
9
}
10
}

Formula

TO_XML(my_action.object, "Data")

Output

"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<Data>\n <city>Melbourne</city>\n <state>Victoria</state>\n <post-code type=\"integer\">3000</post-code>\n <country>Australia</country>\n</Data>\n"
Was this helpful?