How to merge 2 json objects?

youngstrommj — Tue, 06 Sep 2022 17:54:14 GMT

Hello, I have an existing json object and I'd like to merge another json object into it. I don't want to combine them into an array. I'd like them merged. Any ideas how I'd do this?

| eval object1=json_object("somekey","value")

| eval object2=json_object("someOtherKey","value")

Combined Value:

{"somekey":"value","someOtherKey":"value"}

Re: How to merge 2 json objects?

kamlesh_vaghela — Tue, 27 Sep 2022 07:16:35 GMT

@youngstrommj

Can you please try this?

My Sample Search :

| makeresults | eval object1=json_object("somekey","value") | eval object2=json_object("someOtherKey","value","aaa","bbb") | eval object2_keys = json_array_to_mv(json_keys(object2),false()) | eval object3=object1 | foreach mode=multivalue object2_keys [| eval object3=json_set(object3,<<ITEM>>,json_extract(object2,<<ITEM>>)) ] | table object1 object2 object3

I hope this will help you.

Thanks
KV
If any of my replies help you to solve the problem Or gain knowledge, an upvote would be appreciated.

topic Re: How to merge 2 json objects? in Getting Data In

How to merge 2 json objects?

Re: How to merge 2 json objects?