Select value from array json using jq

Question

I have the following json file which this value

{
  "data": [
      {
          "id": 60573936,
          "timeCreated": 1615458564202,
          "timeUpdated": 1615458564202,
          "name": "name1",
          "desiredStatus": "UNMANAGED",
          "defaultStatus": "STARTED",
          "targets": [
              {
                  "id": 2520949,
                  "lastReportedStatus": "STOPPED"
              }, {
                  "id": 702881,
                  "lastReportedStatus": "STARTED"
              }
          ]
      }, {
          "id": 60574370,
          "timeCreated": 1615458812565,
          "timeUpdated": 1615458812565,
          "name": "name2",
          "desiredStatus": "UNMANAGED",
          "defaultStatus": "STARTED",
          "targets": [
              {
                  "id": 2520949,
                  "lastReportedStatus": "STARTED"
              }, {
                  "id": 702881,
                  "lastReportedStatus": "STOPPED"
              }
          ]
      }, {
          "id": 60574329,
          "timeCreated": 1615458775053,
          "timeUpdated": 1615458775053,
          "name": "name3",
          "desiredStatus": "UNMANAGED",
          "defaultStatus": "STARTED",
          "targets": [
              {
                  "id": 2520949,
                  "lastReportedStatus": "STOPPED"
              }, {
                  "id": 702881,
                  "lastReportedStatus": "STARTED"
              }
          ]
      }
    ]
  }

I would like to extract the "name" value only if "id"="2520949" and "lastReportedStatus"="STOPPED" using jq. In my example I would like to get "name1" and "name3". I tried using select feature but I'm not able to satisfy the "and" condition between "id" and "lastReportedStatus" key. What is the correct code with jq ?

choroba · Accepted Answer · 2021-04-21 21:57:32Z

7

jq '.data[] 
    | select(.targets[] | .lastReportedStatus=="STOPPED" and .id==2520949)
    | .name' file.json

answered Apr 21, 2021 at 21:57

choroba

245k27 gold badges221 silver badges304 bronze badges

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

1 Comment

choroba Over a year ago

"Thanks" on StackOverflow = Upvote / Accept :-)

Collectives™ on Stack Overflow

Select value from array json using jq

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related