Parsing arbitary JSON
Published: Sunday, Dec 15, 2013 Last modified: Thursday, Nov 14, 2024
For example.json:
{"menu": {
"id": "file",
"value": "File",
"popup": {
"menuitem": [
{"value": "New", "onclick": "CreateNewDoc()"},
{"value": "Open", "onclick": "OpenDoc()"},
{"value": "Close", "onclick": "CloseDoc()"}
]
}
}}
Desired output:
this.menu.popup.menuitem[0].value = "New"
this.menu.popup.menuitem[0].onclick = "CreateNewDoc()"
this.menu.popup.menuitem[1].value = "Open"
this.menu.popup.menuitem[1].onclick = "OpenDoc()"
this.menu.popup.menuitem[2].value = "Close"
this.menu.popup.menuitem[2].onclick = "CloseDoc()"
this.menu.value = "File"
this.menu.id = "file"
Python implementation
With thanks from Hyperair on Freenode’s #hackerspace.sg
#!/usr/bin/python3
import json
import sys
fmt = '{key} = {value}'
def dump_obj(prefix, obj):
if isinstance(obj, dict):
for k, v in obj.items():
if prefix:
k = prefix + '.' + k
dump_obj(k, v)
elif isinstance(obj, list):
for i, v in enumerate(obj):
if prefix:
k = "{prefix}[{idx}]".format(prefix=prefix, idx=i)
dump_obj(k, v)
else:
print(fmt.format(key=prefix, value=json.dumps(obj)))
obj = json.loads(sys.stdin.read())
dump_obj('this', obj)
Golang implementation
Since Golang is statically typed, the important element in the code is t := x.(type)
where they type of x gets asserted, which is a required step, so you
can then iterate over the resulting structure.
package main
import (
"encoding/json"
"fmt"
"io/ioutil"
"os"
"strconv"
)
func dumpobj(prefix string, x interface{}) {
switch t := x.(type) {
case map[string]interface{}:
for k, v := range t {
dumpobj(prefix+"."+k, v)
}
case []interface{}:
for i, v := range t {
dumpobj(prefix+"["+strconv.Itoa(i)+"]", v)
}
case string:
fmt.Printf("%s = %q\n", prefix, t)
default:
fmt.Printf("Unhandled: %T\n", t)
}
}
func main() {
j, err := ioutil.ReadAll(os.Stdin)
if err != nil {
panic(err)
}
var pj interface{}
err = json.Unmarshal(j, &pj)
if err != nil {
panic(err)
}
dumpobj("this", pj)
}
Alternative example with depth: http://play.golang.org/p/QOwxJQ4z4Z
Source is with thanks again from dsal from #go-nuts http://play.golang.org/p/pt4MLJ6HcV
However ideally you know the JSON structure beforehand, and you create a structure for it to map to, e.g. http://play.golang.org/p/bdjC6DLTqo. Only then you can access values easily like:
fmt.Println(myOb.Menu.Popup.Menuitem[0].Value)