Syntax

UNFLATTEN_JSON(object, [separator])

Usage examples
Input 1
{
2
"contact.address.0.city":"Huntsville",
3
"contact.address.0.geo.lat":"2.243232",
4
"contact.address.0.geo.lon":"1.23123",
5
"contact.address.0.state":"NC",
6
"contact.address.0.street":"1013rdSt",
7
"contact.address.0.type":"home",
8
"contact.address.1.city":"city",
9
"contact.address.1.geo.lat":"2.243232",
10
"contact.address.1.geo.lon":"1.23123",
11
"contact.address.1.state":"NC",
12
"contact.address.1.street":"15MainSt",
13
"contact.address.1.type":"work",
14
"contact.id":"557",
15
"contact.name":"JaneSmith"
16
}
Copy
Formula UNFLATTEN_JSON(json)
Output 1
{
2
"contact":{
3
"address":[
4
{
5
"city":"Huntsville",
6
"geo":{
7
"lat":"2.243232",
8
"lon":"1.23123"
9
},
10
"state":"NC",
11
"street":"1013rdSt",
12
"type":"home"
13
},
14
{
15
"city":"city",
16
"geo":{
17
"lat":"2.243232",
18
"lon":"1.23123"
19
},
20
"state":"NC",
21
"street":"15MainSt",
22
"type":"work"
23
}
24
],
25
"id":"557",
26
"name":"JaneSmith"
27
}
28
}
Copy