Nested Json parsing using jq in bash

Question

I need to parse a json file , I tied bash script with jq and not getting expected output .

Json File :

[
  {
    "fqdn": "my-created-lb",
    "status": "Active",
    "members": {
      "10.45.78.9:80": {
        "dc": "NA",
        "state": "enabled",
        "port": 80
      },
      "10.45.78.10:80": {
        "dc": "NA",
        "state": "enabled",
        "port": 80
      },
      "10.45.78.11:80": {
        "dc": "NA",
        "state": "enabled",
        "port": 80
      },
      "10.45.78.12:80": {
        "dc": "NA",
        "state": "enabled",
        "port": 80
      }
    }
  }
]

I need output as :

"my-created-lb"
"10.45.78.9:80","enabled"
"10.45.78.10:80","enabled"
"10.45.78.11:80","enabled"
"10.45.78.12:80","enabled"

I tried below jq , but not getting expected output :

jq '.[] | .fqdn,.members,.members[].state'

But I am getting below output :

"my-created-lb"
{
  "10.45.78.9:80": {
    "dc": "NA",
    "state": "enabled",
    "port": 80
  },
  "10.45.78.10:80": {
    "dc": "NA",
    "state": "enabled",
    "port": 80
  },
  "10.45.78.11:80": {
    "dc": "NA",
    "state": "enabled",
    "port": 80
  },
  "10.45.78.12:80": {
    "dc": "NA",
    "state": "enabled",
    "port": 80
  }
}
"enabled"
"enabled"
"enabled"
"enabled"

Thor · Accepted Answer · 2021-05-29 01:49:42Z

7

Because you want the key's name, you could use to_entries like this:

jq -r '.[] | .fqdn, ( .members | to_entries | .[] | [ .key, .value.state ] | @tsv )'

Output:

my-created-lb
10.45.78.9:80   enabled
10.45.78.10:80  enabled
10.45.78.11:80  enabled
10.45.78.12:80  enabled

Edit

To get the exact output listed in the original post, modify the jq script to be:

jq -r '.[] | [.fqdn], ( .members | to_entries | .[] | [ .key, .value.state ] ) | @csv'

Output:

"my-created-lb"
"10.45.78.9:80","enabled"
"10.45.78.10:80","enabled"
"10.45.78.11:80","enabled"
"10.45.78.12:80","enabled"

edited May 29, 2021 at 1:49

answered May 28, 2021 at 15:45

Thor

47.7k12 gold badges125 silver badges140 bronze badges

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

Comments

glenn jackman · Accepted Answer · 2021-05-28 17:48:07Z

2

To get precisely your desired output:

jq -r '.[] | ([.fqdn]|@csv), (.members | keys[] as $k | [$k, .[$k].state] | @csv)' file.json

"my-created-lb"
"10.45.78.10:80","enabled"
"10.45.78.11:80","enabled"
"10.45.78.12:80","enabled"
"10.45.78.9:80","enabled"

answered May 28, 2021 at 17:48

glenn jackman

249k42 gold badges233 silver badges363 bronze badges

1 Comment

ikegami Over a year ago

You could factor out the common @csv. [...] | @csv, (... | @csv) simplifies to [...], (...) | @csv

Collectives™ on Stack Overflow

Nested Json parsing using jq in bash

2 Answers 2

Edit

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Edit

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related