ResourceInfo: {
ID: "58",
User: "abc",
NVM: {
a: "522523632",
b: "80000000",
c: "442523632",
d: "14",
.
.
},
RAM: { [+]
...
See more...
ResourceInfo: {
ID: "58",
User: "abc",
NVM: {
a: "522523632",
b: "80000000",
c: "442523632",
d: "14",
.
.
},
RAM: { [+]
},
ROM: { [+]
}
} and for RAM ROM and NVM i want to get the specific data inside them. component Value a 522523632 b 80000000 c 442523632 d 14 . . . I want to form a table like this for RAM ROM and NVM. And i do it like this. But sometimes i get a error message like field tmp does not exist, even there is data. So i want to avoid mvzip and get this data in some other way. is there way present to deal with JSON data? | spath output=RAM ResourceInfo.RAM
| rex field=RAM max_match=0 "\"(?<component>[^\"]+)\":(?<Value>[\d\.]+)"
| eval tmp = mvzip(component,Value)
| mvexpand tmp
| eval component=mvindex(split(tmp,","),0)
| eval Value=mvindex(split(tmp,","),1)
|table component Value