jq conditional update an array element

Question

I want to conditionally update an element value based on the value of another element within the same array.

For example, I want to find name=="weather" and change checked from "true" to "false"

[
  {
    "originalSourceId": null,
    "sourceConnection": {
      "id": null,
      "version": null,
      "properties": [
        {
          "id": null,
          "version": null
        }
      ],
      "name": "POSTGRESQL",
      "businessName": null
    },
    "checked": true,
    "newlyAdded": false,
    "discoveredEntities": [
      {
        "name": "weather",
        "checked": true,
        "checkedBeforeEdit": false,
        "storeFieldsAsStrings": false
      },
      {
        "name": "weather_2",
        "checked": true,
        "checkedBeforeEdit": false,
        "storeFieldsAsStrings": false
      }
    ],
    "defaultLevel": "MANAGED"
  }
]

the checked element will update to "false" for the same object with name = "weather"

[
  {
    "originalSourceId": null,
    "sourceConnection": {
      "id": null,
      "version": null,
      "properties": [
        {
          "id": null,
          "version": null
        }
      ],
      "name": "POSTGRESQL",
      "businessName": null
    },
    "checked": true,
    "newlyAdded": false,
    "discoveredEntities": [
      {
        "name": "weather",
        "checked": false,
        "checkedBeforeEdit": false,
        "storeFieldsAsStrings": false
      },
      {
        "name": "weather_2",
        "checked": true,
        "checkedBeforeEdit": false,
        "storeFieldsAsStrings": false
      }
    ],
    "defaultLevel": "MANAGED"
  }
]

I've tried jq . | jq '[.[].discoveredEntities[] | if (.name=="weather") then (.checked = "false") else . end]' ./test.json. But it is only return portion of it back with updated checked = false for weather. </pre>[ { "name": "weather", "checked": "false", "checkedBeforeEdit": false, "storeFieldsAsStrings": false }, { "name": "weather_2", "checked": true, "checkedBeforeEdit": false, "storeFieldsAsStrings": false } ]<code> — CLO
– CLO, Commented Sep 4, 2018 at 18:13

Jeff Mercado · Accepted Answer · 2018-09-05 06:17:57Z

4

Figured it out.

jq '[.[].discoveredEntities[] |= if (.name=="weather") then (.checked = "false") else . end]'\
    ./test.json

edited Sep 5, 2018 at 6:17

Jeff Mercado

136k34 gold badges268 silver badges282 bronze badges

answered Sep 4, 2018 at 18:38

CLO

1031 silver badge9 bronze badges

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

2 Comments

Jeff Mercado Over a year ago

You don't need the outer square brackets [], in this context, you're putting the results in an array. But since the body is just assignments, the initial input will always be returned. You'll end up with your original input updated, but in an array.

peak Over a year ago

It would be more consistent with the remainder of the document to use the boolean value false rather than the string "false".

Jeff Mercado · Accepted Answer · 2018-09-05 06:22:49Z

3

For these sorts of updates, it's easier to visualize if you think of it this way, locate the items you want to update first, then update them.

 (.[].discoveredEntities[] | select(.name == "weather").checked) = false
#[ locate the items to update                         ]
#                                                      [ update them   ]

answered Sep 5, 2018 at 6:22

Jeff Mercado

136k34 gold badges268 silver badges282 bronze badges

1 Comment

Sergii Shymko Over a year ago

While the update works, it has an unintended side effect of returning filtered results. Is there any way to include unmodified items to the result set?

peak · Accepted Answer · 2018-09-07 18:03:36Z

0

Using map here yields a very straightforward if somewhat pedestrian solution:

map( .discoveredEntities |=
        map(if .name == "weather" then .checked = false else . end))

Note that it is evidently more appropriate to use false here rather than "false".

answered Sep 7, 2018 at 18:03

peak

119k21 gold badges185 silver badges218 bronze badges

Collectives™ on Stack Overflow

jq conditional update an array element

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related