I have tried quite a few different ways to capture data within a json object and return it as separate events, but my break-down always occurs when attempting to access the data in the nested arrays.
{
"Items": [
{
"CN": "AccountName",
"CV": "AccountOne",
"Props": [
{
"PN": "PropOne",
"PV": "5"
},
{
"PN": "PropTwo",
"PV": "3"
}
]
},
{
"CN": "AccountName",
"CV": "AccountOne",
"Props": [
{
"PN": "PropOne",
"PV": "5"
}
]
},
{
"CN": "AccountName",
"CV": "AccountTwo",
"Props": [
{
"PN": "PropOne",
"PV": "5"
},
{
"PN": "PropThree",
"PV": "8"
}
]
},
{
"CN": "PersonName",
"CV": "Bob",
"Props": [
{
"PN": "PropOne",
"PV": "5"
},
{
"PN": "PropThree",
"PV": "8"
}
]
},
{
"CN": "PersonName",
"CV": "Bob",
"Props": [
{
"PN": "PropThree",
"PV": "8"
}
]
}
]
}
Prepared version for testing:
{ \"Items\": [ { \"CN\": \"AccountName\", \"CV\": \"AccountOne\", \"Props\": [ { \"PN\": \"PropOne\", \"PV\": \"5\" }, { \"PN\": \"PropTwo\", \"PV\": \"3\" } ] }, { \"CN\": \"AccountName\", \"CV\": \"AccountOne\", \"Props\": [ { \"PN\": \"PropOne\", \"PV\": \"5\" } ] }, { \"CN\": \"AccountName\", \"CV\": \"AccountTwo\", \"Props\": [ { \"PN\": \"PropOne\", \"PV\": \"5\" }, { \"PN\": \"PropThree\", \"PV\": \"8\" } ] }, { \"CN\": \"PersonName\", \"CV\": \"Bob\", \"Props\": [ { \"PN\": \"PropOne\", \"PV\": \"5\" }, { \"PN\": \"PropThree\", \"PV\": \"8\" } ] }, { \"CN\": \"PersonName\", \"CV\": \"Bob\", \"Props\": [ { \"PN\": \"PropThree\", \"PV\": \"8\" } ] } ] }
I would want this to result in something like:
Thanks!
... View more