topic Re: How to achieve renaming JSON field names? in Deployment Architecture

How to achieve renaming JSON field names?

dvuchev — Fri, 20 Jan 2023 17:18:51 GMT

Hey All,
wondering if I can get some input on this. I have data coming in as JSON. The fields follow this naming convention:

objects.Server::34385.fields.friendlyname = Server123
objects.Server::88634.fields.friendlyname = Server444

What I'm trying to do is to somehow rename the fields, so I omit the ::<number> after the Server part.
End result is needed to be like this:
objects.Server.fields.friendlyname = Server123
objects.Server.fields.friendlyname = Server444

It's worth mentioning that there are around 10k servers, so I can't list them out one by one.

Re: How to achieve renaming JSON field names?

ITWhisperer — Fri, 20 Jan 2023 18:07:53 GMT

Try something like this

| foreach *::*.* [| eval "<<MATCHSEG1>>.<<MATCHSEG3>>" = if(isnotnull('<<FIELD>>'),'<<FIELD>>','<<MATCHSEG1>>.<<MATCHSEG3>>')]

Re: How to achieve renaming JSON field names?

dvuchev — Fri, 20 Jan 2023 19:01:13 GMT

@ITWhisperer Thanks so much, was able to get what I needed with the | foreach

Marking as solution and DM