Delete on nested array with jq

Question

this is my data structure:

[
    {
        "name": "name1",
        "organizations": [
            {
                "name": "name2",
                "spaces": [
                    {
                        "name": "name3",
                        "otherkey":"otherval"
                    },
                    {
                        "name": "name4",
                        "otherkey":"otherval"
                    }
                ]
            }
        ]
    },
    {
        "name": "name21",
        "organizations": [
            {
                "name": "name22",
                "spaces": [
                    {
                        "name": "name23",
                        "otherkey":"otherval"
                    },
                    {
                        "name": "name24",
                        "otherkey":"otherval"
                    }
                ]
            }
        ]
    }
]

i just want to keep name=name1, remove the nested array object with name=name4 and want to keep the rest of the object intact. I tried with map(select) but this will just give me the full object. Is it possible to work with del on specific subarrays and keep the rest as it is?

result should be the following. in addition i want to avoid enumeration all attributes to keep on outer objects:

[
    {
        "name": "name1",
        "organizations": [
            {
                "name": "name2",
                "spaces": [
                    {
                        "name": "name3",
                        "otherkey":"otherval"
                    }
                ]
            }
        ]
    }
]

any idea? thanks!

peak · Accepted Answer · 2017-02-14 00:13:31Z

5

A very targeted solution would be:

path(.[0].organizations[0].spaces) as $target
| (getpath($target) | map(select(.name != "name4"))) as $new
| setpath($target; $new)

If permissible, though, you might consider:

walk(if type == "object" and .spaces|type == "array"
     then .spaces |= map(select(.name != "name4"))
     else . end)

or:

del(.. | .spaces? // empty | .[] | select(.name == "name4") )

(If your jq does not have walk/1 then its jq definition can easily be found by googling.)

edited Feb 14, 2017 at 0:13

answered Feb 13, 2017 at 23:53

peak

119k21 gold badges185 silver badges218 bronze badges

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

Comments

Vishnu · Accepted Answer · 2022-01-04 13:04:45Z

1

You can use the below and it will remove the "name": "name4" array only.

jq 'del(.[] | .organizations? | .[] | .spaces?|.[] | select(.name? == "name4"))' yourJsonFile.json

answered Jan 4, 2022 at 13:04

Vishnu

2201 silver badge8 bronze badges

Comments

jq170727 · Accepted Answer · 2017-08-16 07:51:22Z

0

Here is a solution using select, reduce, tostream and delpaths

map(  
    select(.name == "name1")
  | reduce (tostream|select(length==2)) as [$p,$v] (
      .
    ; if [$p[-1],$v] == ["name","name4"] then delpaths([$p[:-1]]) else . end
    )
)

answered Aug 16, 2017 at 7:51

jq170727

15.1k6 gold badges52 silver badges61 bronze badges

Comments

erstaples · Accepted Answer · 2023-02-02 20:47:24Z

0

I took a similar approach as @peak but inverted it, so instead of selecting what you want and setting that in the output we're selecting what we don't want and deleting it.

[path(.organizations[0].spaces[]| select(.name == "name4")] as $trash | delpaths($trash)

answered Feb 2, 2023 at 20:47

erstaples

2,0861 gold badge17 silver badges32 bronze badges

Collectives™ on Stack Overflow

Delete on nested array with jq

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related