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.

[jlambatl]

@KrishnaJyothika here's a way to this..

Here's a playground link.

Here's the example, somewhat verbose but it does work.

keyValRegex = r'/(?P<key>[^/]+)/(?P<value>[^/]+)'
obj = object(.)

pairs, err = parse_regex_all(obj.resource, keyValRegex)
if err != null {
    abort
}
for_each(pairs) -> | _idx, match | {
    k = to_string(match.key)
    v = to_string(match.value)
    obj, err = set(value: obj, path: [ k ], data: v)
    if err != null {
        abort
    }
}
del(obj.resource)

. = obj