Converting key-values pairs

[KrishnaJyothika]

Hi Team,

We have an requirement where we want to convert one of the JSON field into key-value pairs

Here we want to convert value of resource into key-value pairs

Input:
{"Name":"List","Tier":"Hot","average":20,"count":1,"maximum":1,"metricName":"Availability","minimum":100,"resource":"/key1/value1/key2/value2/key3/values3","time":"2023-12-14T13:22:00.0000000Z","total":1}

Excepted Output:
{"Name":"List","Tier":"Hot","average":20,"count":1,"maximum":1,"metricName":"Availability","minimum":100,"key1":"value1","key2":"value2","key3":"value3","time":"2023-12-14T13:22:00.0000000Z","total":1}

Please help us understand how can we achieve this using vector.

[jszwedko]

Unfortunately I don't think that sort of thing would be possible in VRL. You should be able to use a Lua transform though.