CODEWITHSUNDEEP
jsonjq
Rehan Ch
Rehan Ch

Reputation: 853

How to filter an array of JSON objects with jq?

I have the following JSON input:

{
  "zk_kafka": [
    {
      "InstanceType": "t2.medium",
      "zkMemory": "16",
      "kafkaMemory": "8"
    },
    {
      "InstanceType": "t2.small",
      "zkMemory": "8",
      "kafkaMemory": "4"
    }
  ],
  "es_hdfs": [
    {
      "InstanceType": "t2.medium",
      "esMemory": "16",
      "hdfsMemory": "8"
    },
    {
      "InstanceType": "t2.small",
      "esMemory": "8",
      "hdfsMemory": "4"
    }
  ]
}

First I want to select an array by a property name. And then I want to select an object of the array by the value of the property InstanceType.

Example for the property zk_kafka and the value t2.medium:

{
  "InstanceType": "t2.medium",
  "zkMemory": "16",
  "kafkaMemory": "8"
}

I know how to select the array:

jq .zk_kafka

But I do not know how to filter the array of object by a property value.

Upvotes: 46

Views: 41016

Answers (2)

zabop
zabop

Reputation: 7832

Alternatively, you can also use map():

jq '.zk_kafka | map(select(.InstanceType == "t2.medium"))' input.json

Upvotes: 0

ceving
ceving

Reputation: 23774

Use the select filter of jq:

jq '.zk_kafka | .[] | select(.InstanceType == "t2.medium")'

Use the --arg option to pass an argument to the query to avoid injections.

jq --arg instance "t2.medium" '.zk_kafka | .[] | select(.InstanceType == $instance)'

jq has a manual, a tutorial and a cookbook.

Upvotes: 74

Related Questions