代码之家 › 专栏 › 技术社区 › Lee Wilson

如何使用jq返回这个JSON文件的“文本”字段?

jq ubuntu linux json

Lee Wilson · 技术社区 · 2 年前

我希望从这个JSON文件中提取cat事实:

[
  {
    "status": {
      "verified": true,
      "feedback": "",
      "sentCount": 1
    },
    "_id": "5887e1d85c873e0011036889",
    "user": "5a9ac18c7478810ea6c06381",
    "text": "Cats make about 100 different sounds. Dogs make only about 10.",
    "__v": 0,
    "source": "user",
    "updatedAt": "2020-09-03T16:39:39.578Z",
    "type": "cat",
    "createdAt": "2018-01-15T21:20:00.003Z",
    "deleted": false,
    "used": true
  },
  {
    "status": {
      "verified": true,
      "sentCount": 1
    },
    "_id": "588e746706ac2b00110e59ff",
    "user": "588e6e8806ac2b00110e59c3",
    "text": "Domestic cats spend about 70 percent of the day sleeping and 15 percent of the day grooming.",
    "__v": 0,
    "source": "user",
    "updatedAt": "2020-08-26T20:20:02.359Z",
    "type": "cat",
    "createdAt": "2018-01-14T21:20:02.750Z",
    "deleted": false,
    "used": true
  },
  {
    "status": {
      "verified": true,
      "sentCount": 1
    },
    "_id": "58923f2fc3878c0011784c79",
    "user": "5887e9f65c873e001103688d",
    "text": "I don't know anything about cats.",
    "__v": 0,
    "source": "user",
    "updatedAt": "2020-08-23T20:20:01.611Z",
    "type": "cat",
    "createdAt": "2018-02-25T21:20:03.060Z",
    "deleted": false,
    "used": false
  },
  {
    "status": {
      "verified": true,
      "sentCount": 1
    },
    "_id": "5894af975cdc7400113ef7f9",
    "user": "5a9ac18c7478810ea6c06381",
    "text": "The technical term for a catâs hairball is a bezoar.",
    "__v": 0,
    "source": "user",
    "updatedAt": "2020-11-25T21:20:03.895Z",
    "type": "cat",
    "createdAt": "2018-02-27T21:20:02.854Z",
    "deleted": false,
    "used": true
  },
  {
    "status": {
      "verified": true,
      "sentCount": 1
    },
    "_id": "58e007cc0aac31001185ecf5",
    "user": "58e007480aac31001185ecef",
    "text": "Cats are the most popular pet in the United States: There are 88 million pet cats and 74 million dogs.",
    "__v": 0,
    "source": "user",
    "updatedAt": "2020-08-23T20:20:01.611Z",
    "type": "cat",
    "createdAt": "2018-03-01T21:20:02.713Z",
    "deleted": false,
    "used": false
  }
]

它的网址是 https://cat-fact.herokuapp.com/facts .我知道获取信息不是问题,因为当我跑步时 curl 'https://cat-fact.herokuapp.com/facts' | jq '.' ,我得到了整个文件作为回报。

跑步后 curl 'https://cat-fact.herokuapp.com/facts' | jq '. | {text}' ,

我明白了 jq: error (at <stdin>:0): Cannot index array with string "text" .

跑步后 curl 'https://cat-fact.herokuapp.com/facts' | jq '. | {.text}' ,

这是返回的: (23) Failed writing body

跑步后 curl 'https://cat-fact.herokuapp.com/facts' | jq '.[] | {text: .commit.text}' ,

这是返回的:

 % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
Dload  Upload   Total   Spent    Left  Speed                                           100  1675
100  1675    0     0   9463      0 --:--:-- --:--:-- --:--:--  9463
{
"text": null
}
{
"text": null
}
{
"text": null
}
{
"text": null
}
{ 
"text": null
}

1 回复 | 直到 2 年前

Ted Lyngmo 2 年前

我会使用数组/对象值迭代器 .[] 然后 ["text"] 要筛选:

jq '.[]["text"]'

将示例文件作为输入将产生以下输出:

"Cats make about 100 different sounds. Dogs make only about 10."
"Domestic cats spend about 70 percent of the day sleeping and 15 percent of the day grooming."
"I don't know anything about cats."
"The technical term for a catâs hairball is a bezoar."
"Cats are the most popular pet in the United States: There are 88 million pet cats and 74 million dogs."

以上也是您(当前)可以从中获得的确切输出:

curl -s 'https://cat-fact.herokuapp.com/facts' | jq '.[]["text"]'