Forum Discussion

eladfe's avatar
eladfe
Copper Contributor
Feb 19, 2023

Unpacking JSON

Hay , I am trying to unpack the JSON string  IPAddresses  from the table  DeviceNetworkInfo:   DeviceNetworkInfo | take 10  | project IP = parse_json(IPAddresses)  | extend ADR = IP.IPAddress...
  • jbmartin6's avatar
    Feb 21, 2023
    Here IP is still an array of IPAddress,SubnetPrefix,AddressType values so a simple reference to property IPAddress is not unique. You have to index to which element of IP you want, such as IP[0].IPAddress, IP[1].IPAddress, etc.

Resources