Use JQ to output JSON nested object into array, before conversion to CSV

Question

Question is an extension of previous solution:

Use JQ to parse JSON array of objects, using select to match specified key-value in the object element, then convert to CSV

Data Source:

{
  "Other": [],
  "Objects": [
    {
      "ObjectElementName": "Test 123",
      "ObjectElementArray": [],
      "ObjectNested": {
        "0": 20,
        "1": 10.5
      },
      "ObjectElementUnit": "1"
    },
    {
      "ObjectElementName": "Test ABC 1",
      "ObjectElementArray": [],
      "ObjectNested": {
        "0": 0
      },
      "ObjectElementUnit": "2"
    },
    {
      "ObjectElementName": "Test ABC 2",
      "ObjectElementArray": [],
      "ObjectNested": {
        "0": 15,
        "1": 20
      },
      "ObjectElementUnit": "5"
    }
  ],
  "Language": "en-US"
}

JQ command to extract [FAILS]

jq -r '.Objects[]
  | select(.ObjectElementName | test("ABC"))
  | [.ObjectElementName,.ObjectNested,.ObjectElementUnit]
  |@csv' input.json

Output CSV required (or variation, so long as ObjectNested appears into a single column in CSV)

ObjectElementName,ObjectNested,ObjectElementUnit
"Test ABC 1","0:0","2"
"Test ABC 2","0:15,1:20","5"

oguz ismail · Accepted Answer · 2019-11-22 14:58:11Z

2

With keys_unsorted and string interpolation, it's easy to turn ObjectNested into the form you desired:

.Objects[] | select(.ObjectElementName | index("ABC")) | [
    .ObjectElementName,
    ([.ObjectNested | keys_unsorted[] as $k | "\($k):\(.[$k])"] | join(",")),
    .ObjectElementUnit
] | @csv

edited Nov 22, 2019 at 14:58

answered Nov 22, 2019 at 14:51

oguz ismail

51.8k16 gold badges64 silver badges83 bronze badges

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

Collectives™ on Stack Overflow

Use JQ to output JSON nested object into array, before conversion to CSV

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest