Using jq and map to convert JSON objects with nested objects to Name=Value format

Question

Completely stuck with this one.

I've got JSON Like this:

{
  "create_option": "Restore",
  "disk_iops_read_write": 120,
  "disk_mbps_read_write": 25,
  "tags": {
    "Monitor": "No",
    "RSVaultBackup": "2dc504bd"
  }
}

and with the following jq

.|to_entries|map("nfs-0_\(.key)=\"\(.value)\"")|.[]

I've got to this

nfs-0_create_option="Restore"
nfs-0_disk_iops_read_write="120"
nfs-0_disk_mbps_read_write="25"
nfs-0_tags="{"Monitor":"No","RSVaultBackup":"2dc504bd"}"

but the nfs-0_tags line section also needs to be in name=value format. What I want to end up with is this

nfs-0_create_option="Restore"
nfs-0_disk_iops_read_write="120"
nfs-0_disk_mbps_read_write="25"
nfs-0_tags={Monitor="No", VaultBackup="2dc504bd"}

I feel I should be able to recursively apply the map but for the life of me I can't figure out how that might be achieved.

Any ideas?

Thanks :)

EDIT:

Okay I think I'm getting a bit closer now with this

.|.tags |= (to_entries | map("\(.key) = \(.value)"))|to_entries|map ("\(.key) = \(.value)")|.[]

I'm now getting

create_option = Restore
disk_iops_read_write = 120
disk_mbps_read_write = 25
tags = ["Monitor = No","RSVaultBackup = 2dc504bd"]

But I need the tags line in curly braces {} with the key unquoted and the value quoted. Like this

nfs-0_tags={Monitor="No", VaultBackup="2dc504bd"}

EDIT:

I still want the output to look like this

nfs-0_create_option="Restore"
nfs-0_disk_iops_read_write="120"
nfs-0_disk_mbps_read_write="25"
nfs-0_tags={Monitor="No", VaultBackup="2dc504bd"}

after the jq runs

Do you need to quote the value? In the first 3 lines of your expected output they're quoted while the last one is not. — dibery
– dibery, Commented Aug 7, 2020 at 16:03
@dibery yep - i've edited the post to reflect I still need the value to be quoted — Philip Lewis
– Philip Lewis, Commented Aug 7, 2020 at 16:10

peak · Accepted Answer · 2020-08-07 20:30:19Z

2

Here is a solution that allows arbitrarily deep nesting and illustrates the use of recursive inner functions:

def pairs:
  def q:
    if type == "string" then tojson
    elif type == "number" then "\"\(.)\""
    else . end;
  def ip:
    if type == "object"
    then "{" + (to_entries | map("\(.key)=\(.value|ip)") | join(",")) + "}"
    else q end;
  if type == "object"
  then to_entries[] | ("\(.key)=\(.value | ip)")
  else . end;

pairs

edited Aug 7, 2020 at 20:30

answered Aug 7, 2020 at 18:57

peak

119k21 gold badges185 silver badges218 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Philip Lewis Over a year ago

Thanks - another superb bit of information - I've learned so much from these two answers much more than wading through the docs and stumbling around with my own experiments - Great forum!!

dibery · Accepted Answer · 2020-08-07 17:09:24Z

1

In act.jq:

def f:
 if .value|type=="object" then
  "nfs-0_\(.key)={\([.value|to_entries|.[]|"\(.key)=\"\(.value)\""]|join(","))}"
 else
  "nfs-0_\(.key)=\"\(.value)\""
 end;

to_entries|.[]|f

Invocation:

jq -rf act.jq file.json

Use type to check if we should go down. If the type of .value is object then we split it again and then collect the result; otherwise we just interpolate it. You can also write f function inline (i.e., after to_entries|.[]).

answered Aug 7, 2020 at 17:09

dibery

3,6004 gold badges19 silver badges28 bronze badges

1 Comment

Philip Lewis Over a year ago

That's awesome! - Thank you so much. I'm going to take some time to dissect that but right off the bat sticking it in jqplay it works a treat.

Collectives™ on Stack Overflow

Using jq and map to convert JSON objects with nested objects to Name=Value format

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related