Parse JSON string within JSON and other fields

Question

I have a file in s3 which when unzipped has something of this format

{"a": "foo",
 "b": "bar",
 "c": : "{\"hello\": \"world\"}"}

Now I know I can parse the value of c by doing jq '.c | fromjson | .hello'

But let's say I want all the values from this json, a, b, and c. This is the code snippet I currently have:

aws s3 cp s3://somebucket/somekey.gz - | gunzip | jq '[.a, .b]'

How do I incorporate grabbing the value from c into this expression?

Is your JSON valid? It needs to have a bracket present "c": ["{\"hello\": \"world\"}"] — Inian
– Inian, Commented Jan 30, 2018 at 17:10
"c": : " is definitely not valid JSON. Please test your example data to make sure it's genuinely representative of the input format. — Charles Duffy
– Charles Duffy, Commented Jan 30, 2018 at 17:26

RomanPerekhrest · Accepted Answer · 2018-01-30 17:26:20Z

9

I want all the values from this json, a, b, and c

jq solution for valid JSON structure:

... | jq '[.a, .b, (.c | fromjson | .[])]'

The output:

[
  "foo",
  "bar",
  "world"
]

answered Jan 30, 2018 at 17:26

RomanPerekhrest

93.1k4 gold badges75 silver badges112 bronze badges

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

1 Answer 1