add value from an object into each element of an array

Question

I have a json object that looks like this:

{
    "data": {
        "id" : 1234,
        "details": [
            {
                "vid": "332",
                "long": -79,
                "lat": 45
            },
            {
                "vid": "33",
                "long": -77,
                "lat": 32
            }
        ]
    }
}

I would like output a csv file from this data that looks like this:

"1234","332","-79", "45"
"1234", "33", "-77", "32"

E.g. I want to add something from a node in each of another node's array's objects, essentially de-normalize the data.

Is there a way to access a value from somewhere else in the json data?

peak · Accepted Answer · 2020-08-12 18:35:03Z

2

Or without a variable:

jq -r '.data | [.id] + (.details[] | [.vid, .long, .lat]) | @csv' file.json

If you really want all the values to be quoted, simply add map(tostring) to the pipeline before the final @csv.

edited Aug 12, 2020 at 18:35

answered Aug 12, 2020 at 16:54

peak

119k21 gold badges185 silver badges218 bronze badges

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

1 Comment

user1279887 Over a year ago

Thank you very much.

choroba · Accepted Answer · 2020-08-12 16:41:13Z

1

You can use a variable to do so:

jq '.data.id as $id | .data.details[] | [$id, .vid, .long, .lat]' file.json

answered Aug 12, 2020 at 16:41

choroba

245k27 gold badges221 silver badges304 bronze badges

Collectives™ on Stack Overflow

add value from an object into each element of an array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related