Forum Discussion
Solved
Need help with a parsing query
I'm having a hard time querying out this bit of JSON (extracted from a larger JSON) into their own columns: [{"name":"Category","value":"Direct Agent"},{"name":"Computer","value":"servername.dom...
- Simple but not elegant?
let a = todynamic('[{"name":"Category","value":"Direct Agent"},{"name":"Computer","value":"servername.domeain.net"}]');
print a=parse_json(a)
| extend agentCategory = tostring(a[0].value)
| extend serverName_ = tostring(a[1].value)
Simple but not elegant?
let a = todynamic('[{"name":"Category","value":"Direct Agent"},{"name":"Computer","value":"servername.domeain.net"}]');
print a=parse_json(a)
| extend agentCategory = tostring(a[0].value)
| extend serverName_ = tostring(a[1].value)
let a = todynamic('[{"name":"Category","value":"Direct Agent"},{"name":"Computer","value":"servername.domeain.net"}]');
print a=parse_json(a)
| extend agentCategory = tostring(a[0].value)
| extend serverName_ = tostring(a[1].value)
Thanks Clive! You came through again! 🙂