jq - how to select nested objects in a single array

Question

I have a JSON file with multiple objects within multiple arrays, like below

[
  [
    {
      "instance_id": "i-35345353453",
      "account": "12344",
      "az": "ca-central-1a"
    },
    {
      "instance_id": "i-35345353453",
      "account": "12344",
      "az": "ca-central-1b"
    }
  ],
  [
    {
      "instance_id": "i-35345353453",
      "account": "12344",
      "az": "us-east-1d"
    },
    {
      "instance_id": "i-35345353453",
      "account": "12344",
      "az": "us-east-1d"
    }
  ],
  [
    {
      "instance_id": "i-35343453453",
      "account": "12344",
      "az": "eu-central-1a"
    }
  ]
]

I want the output to be a single array with all the nested objects, like below. Using the JSON input above, how do you use jq to produce the following output?

[
{
  "instance_id": "i-35345353453",
  "account": "12344",
  "az": "ca-central-1a"
},
{
  "instance_id": "i-35345353453",
  "account": "12344",
  "az": "ca-central-1b"
},
{
  "instance_id": "i-35345353453",
  "account": "12344",
  "az": "us-east-1d"
},
{
  "instance_id": "i-35345353453",
  "account": "12344",
  "az": "us-east-1d"
},
{
  "instance_id": "i-35343453453",
  "account": "12344",
  "az": "eu-central-1a"
}
]

How to get this done in JQ? Thanks in advance.

Does this answer your question? Flatten a JSON document using jq — Bishan
– Bishan, Commented Jan 2, 2021 at 4:34

pii_ke · Accepted Answer · 2021-01-02 06:30:34Z

1

Just use the flatten filter. See demo with your data: https://jqplay.org/s/kBxBJLxDKH

You can use it in a command like: jq flatten input_file.

edited Jan 2, 2021 at 6:30

answered Jan 2, 2021 at 5:10

pii_ke

2,9112 gold badges22 silver badges31 bronze badges

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

Comments

hobbs · Accepted Answer · 2021-01-02 04:35:59Z

0

[ .[][] ] works for your example (go down two levels from the root and put everything found into an array), or perhaps [ .. | objects ], which is insensitive to the depth of the array nesting (but does assume that none of your objects contain sub-objects... it just finds all objects at any depth).

answered Jan 2, 2021 at 4:35

hobbs

245k20 gold badges225 silver badges304 bronze badges

1 Comment

oguz ismail Over a year ago

add does the same with less code.

Collectives™ on Stack Overflow

jq - how to select nested objects in a single array

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related