☰

如何获取另一个字段为 true 的 JSON 对象的特定字段

tag-icon • tag-icon linux shell-script awk grep json
如何获取另一个字段为 true 的 JSON 对象的特定字段

我想从下面的命令中获取特定信息

[root@test opc]# /bin/oci compute instance list-vnics --instance-id ocid1.instance.oc1.ap-mumbai-1.anrg6ljrkfvuezyc6w4ytv75l55nscz7gg7rwzg55twubrza2uz4j7kzu66a

输出如下

{
  "data": [
    {
      "availability-domain": "ucJX:AP-MUMBAI-1-AD-1",
      "compartment-id": "ocid1.tenancy.oc1..aaaaaaaaqtzldjhvlvbaoheda67fuwkaldini7h6txiglp7yrx2nc4pm3nka",
      "defined-tags": {
        "Oracle-Tags": {
          "CreatedBy": "oracleidentitycloudservice/[email protected]",
          "CreatedOn": "2022-08-23T12:08:39.326Z"
        }
      },
      "display-name": "xx",
      "freeform-tags": {},
      "hostname-label": null,
      "id": "ocid1.vnic.oc1.ap-mumbai-1.abrg6ljrdvonadtpflqh2zqd5f4i6nuhppq2pzdvuvr75w4mz6mvy7hdhuia",
      "is-primary": false,
      "lifecycle-state": "AVAILABLE",
      "mac-address": "02:00:17:02:F1:53",
      "nsg-ids": [],
      "private-ip": "100.10.10.227",
      "public-ip": null,
      "skip-source-dest-check": false,
      "subnet-id": "ocid1.subnet.oc1.ap-mumbai-1.aaaaaaaaa2s7zfva3efszqdlacsel7pg2doxcc5yhqt4xt25jrzah5e6ntbq",
      "time-created": "2022-08-23T12:08:41.807000+00:00",
      "vlan-id": null
    },
    {
      "availability-domain": "ucJX:AP-MUMBAI-1-AD-1",
      "compartment-id": "ocid1.tenancy.oc1..aaaaaaaaqtzldjhvlvbaoheda67fuwkaldini7h6txiglp7yrx2nc4pm3nka",
      "defined-tags": {
        "Oracle-Tags": {
          "CreatedBy": "oracleidentitycloudservice/[email protected]",
          "CreatedOn": "2022-08-21T16:40:37.685Z"
        }
      },
      "display-name": "test",
      "freeform-tags": {},
      "hostname-label": "test",
      "id": "ocid1.vnic.oc1.ap-mumbai-1.abrg6ljriaxzes5wtacij7lwhcihv72sva3s5od5ngo6i4v6kv4d6zamypza",
      "is-primary": true,
      "lifecycle-state": "AVAILABLE",
      "mac-address": "02:00:17:01:DE:74",
      "nsg-ids": [
        "ocid1.networksecuritygroup.oc1.ap-mumbai-1.aaaaaaaadfnpmigo5wnx6ybvjwqziabtzqtgabhsnkbsnv7qjp3euk5jpwva"
      ],
      "private-ip": "100.10.10.214",
      "public-ip": "140.238.162.238",
      "skip-source-dest-check": false,
      "subnet-id": "ocid1.subnet.oc1.ap-mumbai-1.aaaaaaaaa2s7zfva3efszqdlacsel7pg2doxcc5yhqt4xt25jrzah5e6ntbq",
      "time-created": "2022-08-21T16:40:41.532000+00:00",
      "vlan-id": null
    },
    {
      "availability-domain": "ucJX:AP-MUMBAI-1-AD-1",
      "compartment-id": "ocid1.tenancy.oc1..aaaaaaaaqtzldjhvlvbaoheda67fuwkaldini7h6txiglp7yrx2nc4pm3nka",
      "defined-tags": {
        "Oracle-Tags": {
          "CreatedBy": "oracleidentitycloudservice/[email protected]",
          "CreatedOn": "2022-08-23T12:19:59.985Z"
        }
      },
      "display-name": "yy",
      "freeform-tags": {},
      "hostname-label": null,
      "id": "ocid1.vnic.oc1.ap-mumbai-1.abrg6ljrllmihlbt4rlhsag5jr6hewpofg6fzodmkbqnsdjqdmccyvcetpaa",
      "is-primary": false,
      "lifecycle-state": "AVAILABLE",
      "mac-address": "02:00:17:01:B1:78",
      "nsg-ids": [],
      "private-ip": "100.10.10.43",
      "public-ip": null,
      "skip-source-dest-check": false,
      "subnet-id": "ocid1.subnet.oc1.ap-mumbai-1.aaaaaaaaa2s7zfva3efszqdlacsel7pg2doxcc5yhqt4xt25jrzah5e6ntbq",
      "time-created": "2022-08-23T12:20:03.295000+00:00",
      "vlan-id": null
    }
  ]
}

我想要该部分的特定 id"is-primary": true, 值为

id
private-ip

在上述情况下，输出应为

100.10.10.214
ocid1.vnic.oc1.ap-mumbai-1.abrg6ljriaxzes5wtacij7lwhcihv72sva3s5od5ngo6i4v6kv4d6zamypza

在这种情况下有人可以帮助我吗？谢谢 ：）

答案1

jq是可用于从 JSON 对象中提取数据的多种工具之一。

  • json 输出：
$ jq '.data[] | select(."is-primary") | [.id, ."private-ip"]' file.json
[
  "ocid1.vnic.oc1.ap-mumbai-1.abrg6ljriaxzes5wtacij7lwhcihv72sva3s5od5ngo6i4v6kv4d6zamypza",
  "100.10.10.214"
]
  • .csv 输出：
$ jq -r '.data[] | select(."is-primary") | [.id, ."private-ip"] | @csv' file.json
"ocid1.vnic.oc1.ap-mumbai-1.abrg6ljriaxzes5wtacij7lwhcihv72sva3s5od5ngo6i4v6kv4d6zamypza","100.10.10.214"
  • 在单独的行上：
$ jq -r '.data[] | select(."is-primary") | [.id, ."private-ip"] | join("\n")' file.json
ocid1.vnic.oc1.ap-mumbai-1.abrg6ljriaxzes5wtacij7lwhcihv72sva3s5od5ngo6i4v6kv4d6zamypza
100.10.10.214

1 从技术上讲，如果有多个对象为is-primarytrue，您将得到每个对象对应一个 json 数组的串联，您可以将整个jq表达式包装在[...]包装起来以获取一json 输出由数组组成。

相关内容