Hi,
I am converting nested json to excel in below format.
My nested object is not populating in seperate table.Can you please help.
I am using json_load.
json data:
I am converting nested json to excel in below format.
My nested object is not populating in seperate table.Can you please help.
I am using json_load.
json data:
Output:{
"domain": {
"Switch": [
{
"id": "1",
"Config": {
"details": {
"version": "0.0.1",
"description": "server software"
}
},
"Repo": {
"location": "N/A"
},
"Model": {
"modelid": "1233445",
"modelname": "N/A"
}
}
],
"zone": [
{
"zonename": "abc",
"Time": {
"setting": "UTC"
}
}
]
},
"network": {
"config": [
{
"sip": {
"log_ip": "1.1.1.1"
},
"dns": {
"ip": "1.2.3.4"
},
"ip": "1.2.3.4"
}
]
},
"model": "xyz"
}
Output format in excel,Output:-------------------------|
domain |
-------------------------|
model | serial |
----------|--------------|
xyz | 121423546|
----------|--------------
---------------------------------------------|
switch |
---------------------------------------------|
id | modelid | modelname |
---------|--------------------|--------------|
1 | test | n/a |
---------------------------------------------|
-----------------------|
config |
-----------------------|
details |
-----------------------|
version | description |
---------|-------------|
0.0.1 |server s/w |
-----------------------|