使用unix和jq从其余API输出中提取对象/数组值 [英] Extract object/array value from rest API output using unix and jq

问题描述

使用unix和jq从其他API输出中提取对象/数组值

当我运行下面的curl查询调用REST API时，它给了我两个记录条款的问题。我想获得密钥（SEA-739），状态（打开）和受让人（null或emailAddress）。另外，我怎么能得到计数没有。通过expand检索的问题：operations，versionedRepresentations，editmeta，changelog，renderedFields，

我试过curl | jq'.issues [0] .id'给我有效的id，但是我不能循环通过这两个问题，并得到提及3值两个？有人可以帮助我计数问题使用shell和所有问题逐个获得所需的输出？

来自jq的JSON输出：

  root @ server＃curl -u username：password -X GET  - H'Content-Type：application / json'--insecure --silent'https://myserver.com/rest/api/2/search?jql=project=SE&status=Closed%20order%20by%20key%20desc& ; maxResults = 2'| jq 
 
 {
expand：schema，names，
startAt：0，
maxResults：2， 
total：733，
issues：[
 {
expand：operations，versionedRepresentations，editmeta，changelog，renderedFields，
id ：292697，
self：https://testserver.com/rest/api/2/issue/292697，
key：SEA-739，
fields：{
customfield_10190：null，
customfield_13580：null，
customfield_10192：null，
customfield_10072：null，
customfield_13582：null，
customfield_10194：null，
customfield_13581：[]，
customfield_10074：null，
customfield_13980：[
 {
self：https://testserver.com/rest/api/2/customFieldOption/15071，
value：检查用户库，
id ：15071
} 
]，
customfield_10075：null，
customfield_11680：null，
customfield_13583：null，
 customfield_10076：null，
customfield_10230：null，
fixVersions：[]，
customfield_10231：null，
customfield_13189：null，
customfield_13981：null，
customfield_10232：null，
resolution：null，
customfield_10233：null，
customfield_10234：null，
customfield_14380：null，
lastViewed：null，
customfield_10580：null，
customfield_12880：null，
customfield_10581：null，
customfield_12882：null，
customfield_10220：null，
customfield_12881：null，
priority：{
self：https：// testserver .com / rest / api / 2 / priority / 4，
iconUrl：https://testserver.com/images/icons/priorities/minor.svg，
name customfield_10101：null，
customfield_10980：null，
customfield_10101：null，
 
self：https://testserver.com/rest/api/2/customFieldOption/10377，
value：NO，
id：10377 
}，
customfield_10222：null，
customfield_12883：0 | i16rjz：，
labels ：null，
aggregatetimeoriginalestimate：null，
timeestimate：null，
versions：[]，
issuelinks：[ assignee：null，
status：{
self：https://testserver.com/rest/api/2/status/1，
description： 这个问题是开放的，准备好让受让人开始工作。，
iconUrl：https://testserver.com/images/icons/statuses/open.png，
 name：Open，
id：1，
statusCategory：{
self：https://testserver.com/rest/api/ 2 / statuscategory / 2，
id：2，
key：new，
colorName：blue-grey ：To Do
} 
}，
components：[]，
customfield_13281：null，
customfield_13280：null，
customfield_13283：null，
customfield_13282：null，
customfield_13680：null，
customfield_11780：9223372036854775807，
customfield_11782：null，
customfield_13201：null，
customfield_11781：null，
customfield_10210：null，
customfield_13203：null，
customfield_13202：null，
customfield_13204：null，
aggregatetimeestimate：null，
customfield_14480：com.atlassian.servicedesk.plugins.approvals.internal.customfield.ApprovalsCFValue@7735d8eb，
creator：{
self：https://testserver.com/rest/api/2/user?username=user1，
name：user1，
key：user1，
emailAddress：[e-mail]，
avatarUrls：{
48x48：https：// testserver。 com / secure / useravatar？avatarId = 10312，
24x24：https://testserver.com/secure/useravatar?size=small&avatarId=10312，
16x16： https://testserver.com/secure/useravatar?size=xsmall&avatarId=10312，
32x32：https://testserver.com/secure/useravatar?size=medium&avatarId=10312 
}，
displayName：User1，
active：true，
timeZone：Asia / Kolkata
}，
customfield_12580：null，
subasks：[]，
customfield_10160：org.hakanai.jira.plugins.StatusColor@50，
 
reporter：{
self：https://testserver.com/rest/api/2/user?username=user1，
name：user1 ，
key：user1，
emailAddress：[e-mail]，
avatarUrls：{
48x48：https： /testserver.com/secure/useravatar?avatarId=10312，
24x24：https://testserver.com/secure/useravatar?size=small&avatarId=10312，
16x16 ：https://testserver.com/secure/useravatar?size=xsmall&avatarId=10312，
32x32：https://testserver.com/secure/useravatar?size=medium&avatarId = 10312
}，
displayName：User1，
active：true，
timeZone：Asia / Kolkata
} 
customfield_12980：null，
aggregateprogress：{
progress：0，
total：0 
}，
customfield_10200 ：null，
progress：{
progress：0，
total：0 
}，
customfield_14080：null，
issuetype：{
self：https://testserver.com/rest/api/2/issuetype/25，
id：25，
description：测试帐户检查，
iconUrl：https://testserver.com/download/resources/com.thed.zephyr.je/images/icons/ico_zephyr_issuetype.png，
name：Test，
subask：false 
}，
customfield_11080：null，
customfield_14191：null，
 customfield_11081：null，
customfield_11082：null，
customfield_11083：null，
customfield_10270：null，
customfield_11084：null，
 customfield_13780：null，
timespent：null，
customfield_10150：99999，
customfield_11480：null，
customfield_13782：null，
 customfield_10152：null，
customfield_13781：null，
project：{
self：https://testserver.com/rest/api/2/project/ 10162，
id：10162，
key：SEA，
name：Test Automation，
avatarUrls：{
48x48：https://testserver.com/secure/projectavatar?pid=10162&avatarId=10032，
24x24：https://testserver.com/secure/projectavatar？ size = small& pid = 10162& avatarId = 10032，
16x16：https://testserver.com/secure/projectavatar?size=xsmall&pid=10162&avatarId=10032，
32x32：https://testserver.com/secure/projectavatar?size=medium&pid=10162&avatarId=10032
}，
projectCategory：{
 self：https://testserver.com/rest/api/2/projectCategory/10020，
id：10020，
description：所有与IT相关的任务和项目，
name：Corporate IT
} 
}，
customfield_11880：null，
aggregateatetimespent resolutiondate：null，
workratio：-1，
customfield_14190：null，
customfield_14182：null，
customfield_14183：null，
 watches：{
self：https://testserver.com/rest/api/2/issue/SEA-739/watchers，
watchCount：1，
isWatching：false 
}，
customfield_14181：null，
customfield_14186：null，
customfield_10380：null，
customfield_12680 null，
created：2016-10-29T16：17：57.000-0400，
customfield_10260：null，
customfield_14185：null，
customfield_10140 ：null，
customfield_10261：null，
customfield_10020：{
self：https://testserver.com/rest/api/2/customFieldOption/10380 ，
value：S3，
id：10380
}，
customfield_10262：null，
customfield_10780 
updated：2016-10-29T16：17：57.000-0400，
customfield_13081：null，
customfield_13080：null，
customfield_13083 要由工程填写，
customfield_11180：null，
customfield_13082：null，
customfield_11181：null，
customfield_13085：null，
customfield_11182：null，
customfield_13084：null，
customfield_11580：null，
customfield_11183：null，
customfield_13087：null，
customfield_13086：null，
timeoriginalestimate：null，
customfield_13881：null，
customfield_10130：null，
description：请忽略测试bug ..，
customfield_13880：null，
customfield_10011：null，
customfield_10253：null，
customfield_10012：null，
 customfield_10007：null，
customfield_10008：null，
customfield_10009：null，
summary：请忽略测试bug ..，
customfield_13191 ：null，
customfield_13190：null，
customfield_14282：null，
customfield_13193：null， ：null，
customfield_13195：null，
customfield_14285：[
 {
self：https://testserver.com/rest/api/2/ customFieldOption / 15507，
value：YES，
id：15507
} 
]，
customfield_13194：null，
customfield_14283：null，
customfield_10480：null，
customfield_13196：null，
customfield_14284：null，
customfield_10085：null，
customfield_12780：null，
customfield_10120：null，
customfield_10241：null，
customfield_10088：null，
customfield_10121：null，
customfield_10000：null，
customfield_10122：null，
customfield_10880：null，
 b $ bcustomfield_10243：null，
customfield_10002：null，
customfield_10244：null，
customfield_10486：null，
customfield_10124：null，
customfield_10003：null，
customfield_10245：null，
customfield_10487：null，
customfield_10488：null，
customfield_10236：null，
customfield_10237：null，
environment：null，
duedate：null 
} 
}，
 
 {
expand：operations，versionedRepresentations，editmeta，changelog，renderedFields，
id：273625，
self：https://testserver.com/rest/api / 2 / issue / 273625，
key：SEA-738，
fields：{
customfield_10190：null，
customfield_13580：null ，
customfield_10192：null，
customfield_10072：null，
customfield_10193：null，
customfield_13582：null，
customfield_10194：null ，
customfield_13581：[]，
customfield_10074：null，
customfield_13980：null，
customfield_10075：null，
customfield_11680 null，
customfield_13583：null，
customfield_10076：null，
customfield_10230：null，
fixVersions：[ ：null，
customfield_13189：null，
customfield_13981：null，
customfield_10232：null，
customfield_11685：null，
resolution ：{
self：https://testserver.com/rest/api/2/resolution/1，
id：1，
description： 
name：Fixed
}，
customfield_10233：null，
customfield_10234 ：null，
customfield_12880：null，
customfield_10581：null，
customfield_12880：null，
lastViewed ：null，
customfield_12882：null，
customfield_10220：null，
customfield_12881：null，
priority：{
self https://testserver.com/rest/api/2/priority/3，
iconUrl：https://testserver.com/images/icons/priorities/major.svg，
name：P3，
id：3
}，
customfield_10221：null，
customfield_10980：null，
customfield_10101：{
self：https://testserver.com/rest/api/2/customFieldOption/10377，
value：NO，
 id：10377
}，
customfield_10222：null，
customfield_12883：0 | i13y67：，
labels：[]，
customfield_13208：null，
aggregatetimeoriginalestimate：null，
timeestimate：null，
versions：[]，
issuelinks：[ ，
assignee：{
self：https://testserver.com/rest/api/2/user?username=user2，
name：user2 ，
key：user2，
emailAddress：[e-mail]，
avatarUrls：{
48x48： //testserver.com/secure/useravatar?avatarId=10312，
24x24：https://testserver.com/secure/useravatar?size=small&avatarId=10312，
 16x16：https://testserver.com/secure/useravatar?size=xsmall&avatarId=10312，
32x32：https://testserver.com/secure/useravatar?size=medium& avatarId = 10312
}，
displayName：Russell Pratt，
active：true，
timeZone：EST5EDT
} 
status：{
self：https://testserver.com/rest/api/2/status/5，
description：采取并正在等待记者核实。从这里重新打开或关闭问题。，
iconUrl：https://testserver.com/images/icons/statuses/resolved.png，
name：已解决，
id：5，
statusCategory：{
self：https://testserver.com/rest/api/2/statuscategory/3 ，
id：3，
key：done，
colorName：green，
name：Done
 } 
}，
components：[]，
customfield_13281：null，
customfield_13280：null，
customfield_13283：null，
customfield_13782：null，
customfield_13201：null，
customfield_13880：null，
customfield_11780：9223372036854775807 
customfield_13204：null，
customfield_13204：null，
customfield_13204：null， 
aggregatetimeestimate：null，
customfield_14480：com.atlassian.servicedesk.plugins.approvals.internal.customfield.ApprovalsCFValue@c4b41a5，
creator：{
self：https://testserver.com/rest/api/2/user?username=userads，
name：userads，
key： ，
emailAddress：[e-mail]，
avatarUrls：{
48x48：https://testserver.com/secure/useravatar?ownerId=userads& ; avatarId = 15412，
24x24：https://testserver.com/secure/useravatar?size=small&ownerId=userads&avatarId=15412，
16x16：https ：//testserver.com/secure/useravatar？size = xsmall& ownerId = userads& avatarId = 15412，
32x32：https://testserver.com/secure/useravatar?size=medium&ownerId = userads& avatarId = 15412
}，
displayName：用户广告，
active：true，
timeZone：EST5EDT
}，
customfield_10280：null，
subasks：[]，
customfield_10160：org.hakanai.jira.plugins.StatusColor@54，
 customfield_12580：null，
reporter：{
self：https://testserver.com/rest/api/2/user?username=userads，
 name：userads，
key：userads，
emailAddress：[e-mail]，
avatarUrls：{
48x48 ：https://testserver.com/secure/useravatar?ownerId=userads&avatarId=15412，
24x24：https://testserver.com/secure/useravatar?size=small&ownerId = userads& avatarId = 15412，
16x16：https://testserver.com/secure/useravatar?size=xsmall&ownerId=userads&avatarId=15412，
32x32： https://testserver.com/secure/useravatar?size=medium&ownerId=userads&avatarId=15412
}，
displayName：用户广告，
活动：true，
timeRone：EST5EDT
}，
customfield_12980：null，
aggregateprogress：{
progress：0， 
total：0 
}，
customfield_10200：null，
progress：{
progress：0，
 ：0 
}，
customfield_14080：null，
issuetype：{
self：https://testserver.com/rest/api/2 / issuetype / 3，
id：3，
description：需要完成的任务，
iconUrl：https：// testserver.com/secure/viewavatar?size=xsmall&avatarId=14808&avatarType=issuetype，
name：Task，
subask：false，
avatarId ：14808 
}，
customfield_11080：null，
customfield_14191：null，
customfield_11081：null，
customfield_11082：null，
customfield_11083：null，
customfield_10270：null，
customfield_11084：null，
customfield_13780：null，
timespent：null，
customfield_10150：null，
customfield_11480：null，
customfield_13782：null，
customfield_10152：null，
customfield_13781：null，
project：{
self：https://testserver.com/rest/api/2/project/10162，
id：10162，
key：SEA，
name：Test Automation，
avatarUrls：{
48x48：https://testserver.com/secure/ projectavatar？pid = 10162& avatarId = 10032，
24x24：https://testserver.com/secure/projectavatar?size=small&pid=10162&avatarId=10032，
 16x16：https://testserver.com/secure/projectavatar?size=xsmall&pid=10162&avatarId=10032，
32x32：https://testserver.com/secure/projectavatar？ size = medium& pid = 10162& avatarId = 10032
}，
projectCategory：{
self：https://testserver.com/rest/api/2/ projectCategory / 10020，
id：10020，
description：所有IT相关任务和项目，
name：公司IT
 } 
}，
customfield_11880：null，
aggregatetimespent：null，
resolutiondate：2016-04-21T09：59：34.000-0400，
workratio：-1，
customfield_14190：null，
customfield_14182：null，
customfield_14183：null，
watches：{
self：https://testserver.com/rest/api/2/issue/SEA-738/watchers，
watchCount：2，
isWatching：false 
}，
customfield_14181：null，
customfield_14186：null，
customfield_10380：null，
customfield_12680：null，
 created：2016-04-07T13：11：56.000-0400，
customfield_10260：null，
customfield_14185：null，
customfield_10140：null，
customfield_10261：null，
customfield_10020：{
self：https://testserver.com/rest/api/2/customFieldOption/10380，
 value：S3，
id：10380
}，
customfield_10262：null，
customfield_10780：null，
 ：2016-04-21T10：27：28.000-0400，
customfield_13081：null，
customfield_13080：null，
customfield_13083：要填写工程，
customfield_11118：null，
customfield_11082：null，
customfield_11181：null， ：null，
customfield_13084：null，
customfield_13086：null，
 ：null，
timeoriginalestimate：null，
customfield_13881：null，
customfield_10130：null，
description：我们需要更新CTL登录和RC。目前自动化的设置方式，我们每个环境只能使用一个用户，因此请从下面选择一个用于UAT，另一个用于Prod.\\\\\\\ n1。 uat_centurylinknet：\r\\\
：username：[e-mail]\r\\\
：password：P @ ssw0rd！\r\\\
2。 uat_embarqmailcom：\r\\\
：username：[e-mail]\r\\\
：password：P @ ssw0rd！\r\\\
3。 uat_qcom：\r\\\
：username：[e-mail]\r\\\
：password：P @ ssw0rd！\r\\\
4。 prod_centurylinknet：\r\\\
：username：[e-mail]\r\\\
：password：test03\r\\\
5。 prod_embarqmailcom：\r\\\
：username：[e-mail]\r\\\
：password：test25\r\\\
6。 prod_qcom：\r\\\
：username：[e-mail]\r\\\
：password：test01，
customfield_13880：null，
customfield_11980：null，
customfield_10011：null，
customfield_10253：null，
customfield_10012：null，
customfield_10007：null，
customfield_10008：null，
customfield_10009：null，
summary：更新CTL登录，
customfield_13191：null，
customfield_13190：null，
customfield_14282 null，
customfield_13193：null，
customfield_13192：null，
customfield_14280：null，
customfield_13195：null，
customfield_14285 null，
customfield_13194：null，
customfield_14283：null，
customfield_10084：null，
customfield_10480：null，
customfield_13196 null，
customfield_14284：null，
customfield_10085：null，
customfield_12780：null，
customfield_10120：null，
customfield_10241 null，
customfield_10088：null，
customfield_10121：null，
customfield_10000：[
 {
self：https：// testserver .com / rest / api / 2 / customFieldOption / 10009，
value：CenturyLink，
id：10009
} 
] $ bcustomfield_10242：null，
customfield_10880：null，
customfield_10089：null，
customfield_10122：null，
customfield_10243：null，
customfield_10002：null，
customfield_10244：null，
customfield_10486：null，
customfield_10124：null，
customfield_10003：null，
customfield_10245：null，
customfield_10487：null，
customfield_10488：null，
customfield_10236：null，
customfield_10237：null，
environment：null，
duedate：null 
} 
} 
] 
} 
  pre> 
 
解决方案
您不会给出输出的预期形式的任何细节，但以下jq过滤器会生成您的信息似乎想要（但是你的一些要求对我来说不太清楚）：
  {key，status：.fields.status.name，assignee：.fields.assignee.emailAddress}），
（.issues | length）
  
输出：
  {
key 739，
status：Open，
assignee：null 
} 
 {
key：SEA-738，
status：已解决，
assignee：[e-mail]
} 
 2 
  
 
 
 
 Postscript 
 
 
 
如果你想要一个单行程序将数值生成为流，没有引号，考虑：
  $ jq -r'.issues | （（。[] |（.key，.fields.status.name，.fields.assignee.emailAddress）），length）'
  
输出：
  SEA-739 
打开
 null $ b b SEA-738 
已解决
 [e-mail] 
 2 
  
 
Extract object/array value from rest API output using unix and jq

When i run below curl query which makes call to REST API, it gives me two record in terms of issues. I would like to get "key" (SEA-739), "status" (Open) and "assignee" (null or emailAddress). Also how can i get count of no. of issues retrieved via "expand": operations,versionedRepresentations,editmeta,changelog,renderedFields",

I tried curl | jq '.issues[0].id' and it gives me valid id but I couldn't loop through both issues and get mentioned 3 values for both? Can someone please help me to count issue using shell and get required output for all issues one by one?

JSON output from jq:
root@server# curl -u username:password -X GET -H 'Content-Type: application/json' --insecure --silent 'https://myserver.com/rest/api/2/search?jql=project=SE&status=Closed%20order%20by%20key%20desc&maxResults=2' | jq

{
  "expand": "schema,names",
  "startAt": 0,
  "maxResults": 2,
  "total": 733,
  "issues": [
    {
      "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
      "id": "292697",
      "self": "https://testserver.com/rest/api/2/issue/292697",
      "key": "SEA-739",
      "fields": {
    "customfield_10190": null,
    "customfield_13580": null,
    "customfield_10192": null,
    "customfield_10072": null,
    "customfield_13582": null,
    "customfield_10194": null,
    "customfield_13581": [],
    "customfield_10074": null,
    "customfield_13980": [
      {
        "self": "https://testserver.com/rest/api/2/customFieldOption/15071",
        "value": "check user base",
        "id": "15071"
      }
    ],
    "customfield_10075": null,
    "customfield_11680": null,
    "customfield_13583": null,
    "customfield_10076": null,
    "customfield_10230": null,
    "fixVersions": [],
    "customfield_10231": null,
    "customfield_13189": null,
    "customfield_13981": null,
    "customfield_10232": null,
    "resolution": null,
    "customfield_10233": null,
    "customfield_10234": null,
    "customfield_14380": null,
    "lastViewed": null,
    "customfield_10580": null,
    "customfield_12880": null,
    "customfield_10581": null,
    "customfield_12882": null,
    "customfield_10220": null,
    "customfield_12881": null,
    "priority": {
      "self": "https://testserver.com/rest/api/2/priority/4",
      "iconUrl": "https://testserver.com/images/icons/priorities/minor.svg",
      "name": "P4",
      "id": "4"
    },
    "customfield_10221": null,
    "customfield_10980": null,
    "customfield_10101": {
      "self": "https://testserver.com/rest/api/2/customFieldOption/10377",
      "value": "NO",
      "id": "10377"
    },
    "customfield_10222": null,
    "customfield_12883": "0|i16rjz:",
    "labels": [],
    "customfield_13208": null,
    "aggregatetimeoriginalestimate": null,
    "timeestimate": null,
    "versions": [],
    "issuelinks": [],
    "assignee": null,
    "status": {
      "self": "https://testserver.com/rest/api/2/status/1",
      "description": "The issue is open and ready for the assignee to start work on it.",
      "iconUrl": "https://testserver.com/images/icons/statuses/open.png",
      "name": "Open",
      "id": "1",
      "statusCategory": {
        "self": "https://testserver.com/rest/api/2/statuscategory/2",
        "id": 2,
        "key": "new",
        "colorName": "blue-gray",
        "name": "To Do"
      }
    },
    "components": [],
    "customfield_13281": null,
    "customfield_13280": null,
    "customfield_13283": null,
    "customfield_13282": null,
    "customfield_13680": null,
    "customfield_11780": "9223372036854775807",
    "customfield_11782": null,
    "customfield_13201": null,
    "customfield_11781": null,
    "customfield_10210": null,
    "customfield_13203": null,
    "customfield_13202": null,
    "customfield_13204": null,
    "aggregatetimeestimate": null,
    "customfield_14480": "com.atlassian.servicedesk.plugins.approvals.internal.customfield.ApprovalsCFValue@7735d8eb",
    "creator": {
      "self": "https://testserver.com/rest/api/2/user?username=user1",
      "name": "user1",
      "key": "user1",
      "emailAddress": "[e-mail]",
      "avatarUrls": {
        "48x48": "https://testserver.com/secure/useravatar?avatarId=10312",
        "24x24": "https://testserver.com/secure/useravatar?size=small&avatarId=10312",
        "16x16": "https://testserver.com/secure/useravatar?size=xsmall&avatarId=10312",
        "32x32": "https://testserver.com/secure/useravatar?size=medium&avatarId=10312"
      },
      "displayName": "User1",
      "active": true,
      "timeZone": "Asia/Kolkata"
    },
    "customfield_10280": null,
    "subtasks": [],
    "customfield_10160": "org.hakanai.jira.plugins.StatusColor@50",
    "customfield_12580": null,
    "reporter": {
      "self": "https://testserver.com/rest/api/2/user?username=user1",
      "name": "user1",
      "key": "user1",
      "emailAddress": "[e-mail]",
      "avatarUrls": {
        "48x48": "https://testserver.com/secure/useravatar?avatarId=10312",
        "24x24": "https://testserver.com/secure/useravatar?size=small&avatarId=10312",
        "16x16": "https://testserver.com/secure/useravatar?size=xsmall&avatarId=10312",
        "32x32": "https://testserver.com/secure/useravatar?size=medium&avatarId=10312"
      },
      "displayName": "User1",
      "active": true,
      "timeZone": "Asia/Kolkata"
    },
    "customfield_12980": null,
    "aggregateprogress": {
      "progress": 0,
      "total": 0
    },
    "customfield_10200": null,
    "progress": {
      "progress": 0,
      "total": 0
    },
    "customfield_14080": null,
    "issuetype": {
      "self": "https://testserver.com/rest/api/2/issuetype/25",
      "id": "25",
      "description": "test account checking",
      "iconUrl": "https://testserver.com/download/resources/com.thed.zephyr.je/images/icons/ico_zephyr_issuetype.png",
      "name": "Test",
      "subtask": false
    },
    "customfield_11080": null,
    "customfield_14191": null,
    "customfield_11081": null,
    "customfield_11082": null,
    "customfield_11083": null,
    "customfield_10270": null,
    "customfield_11084": null,
    "customfield_13780": null,
    "timespent": null,
    "customfield_10150": 99999,
    "customfield_11480": null,
    "customfield_13782": null,
    "customfield_10152": null,
    "customfield_13781": null,
    "project": {
      "self": "https://testserver.com/rest/api/2/project/10162",
      "id": "10162",
      "key": "SEA",
      "name": "Test Automation",
      "avatarUrls": {
        "48x48": "https://testserver.com/secure/projectavatar?pid=10162&avatarId=10032",
        "24x24": "https://testserver.com/secure/projectavatar?size=small&pid=10162&avatarId=10032",
        "16x16": "https://testserver.com/secure/projectavatar?size=xsmall&pid=10162&avatarId=10032",
        "32x32": "https://testserver.com/secure/projectavatar?size=medium&pid=10162&avatarId=10032"
      },
      "projectCategory": {
        "self": "https://testserver.com/rest/api/2/projectCategory/10020",
        "id": "10020",
        "description": "All IT related tasks and projects",
        "name": "Corporate IT"
      }
    },
    "customfield_11880": null,
    "aggregatetimespent": null,
    "resolutiondate": null,
    "workratio": -1,
    "customfield_14190": null,
    "customfield_14182": null,
    "customfield_14183": null,
    "watches": {
      "self": "https://testserver.com/rest/api/2/issue/SEA-739/watchers",
      "watchCount": 1,
      "isWatching": false
    },
    "customfield_14181": null,
    "customfield_14186": null,
    "customfield_10380": null,
    "customfield_12680": null,
    "created": "2016-10-29T16:17:57.000-0400",
    "customfield_10260": null,
    "customfield_14185": null,
    "customfield_10140": null,
    "customfield_10261": null,
    "customfield_10020": {
      "self": "https://testserver.com/rest/api/2/customFieldOption/10380",
      "value": "S3",
      "id": "10380"
    },
    "customfield_10262": null,
    "customfield_10780": null,
    "updated": "2016-10-29T16:17:57.000-0400",
    "customfield_13081": null,
    "customfield_13080": null,
    "customfield_13083": "To be filled in by Engineering",
    "customfield_11180": null,
    "customfield_13082": null,
    "customfield_11181": null,
    "customfield_13085": null,
    "customfield_11182": null,
    "customfield_13084": null,
    "customfield_11580": null,
    "customfield_11183": null,
    "customfield_13087": null,
    "customfield_13086": null,
    "timeoriginalestimate": null,
    "customfield_13881": null,
    "customfield_10130": null,
    "description": "Please ignore test bug..",
    "customfield_13880": null,
    "customfield_10011": null,
    "customfield_10253": null,
    "customfield_10012": null,
    "customfield_10007": null,
    "customfield_10008": null,
    "customfield_10009": null,
    "summary": "Please ignore test bug..",
    "customfield_13191": null,
    "customfield_13190": null,
    "customfield_14282": null,
    "customfield_13193": null,
    "customfield_13192": null,
    "customfield_14280": null,
    "customfield_13195": null,
    "customfield_14285": [
      {
        "self": "https://testserver.com/rest/api/2/customFieldOption/15507",
        "value": " YES",
        "id": "15507"
      }
    ],
    "customfield_13194": null,
    "customfield_14283": null,
    "customfield_10480": null,
    "customfield_13196": null,
    "customfield_14284": null,
    "customfield_10085": null,
    "customfield_12780": null,
    "customfield_10120": null,
    "customfield_10241": null,
    "customfield_10088": null,
    "customfield_10121": null,
    "customfield_10000": null,
    "customfield_10242": null,
    "customfield_10880": null,
    "customfield_10089": null,
    "customfield_10122": null,
    "customfield_10243": null,
    "customfield_10002": null,
    "customfield_10244": null,
    "customfield_10486": null,
    "customfield_10124": null,
    "customfield_10003": null,
    "customfield_10245": null,
    "customfield_10487": null,
    "customfield_10488": null,
    "customfield_10236": null,
    "customfield_10237": null,
    "environment": null,
    "duedate": null
      }
    },

    {
      "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
      "id": "273625",
      "self": "https://testserver.com/rest/api/2/issue/273625",
      "key": "SEA-738",
      "fields": {
    "customfield_10190": null,
    "customfield_13580": null,
    "customfield_10192": null,
    "customfield_10072": null,
    "customfield_10193": null,
    "customfield_13582": null,
    "customfield_10194": null,
    "customfield_13581": [],
    "customfield_10074": null,
    "customfield_13980": null,
    "customfield_10075": null,
    "customfield_11680": null,
    "customfield_13583": null,
    "customfield_10076": null,
    "customfield_10230": null,
    "fixVersions": [],
    "customfield_10231": null,
    "customfield_13189": null,
    "customfield_13981": null,
    "customfield_10232": null,
    "customfield_11685": null,
    "resolution": {
      "self": "https://testserver.com/rest/api/2/resolution/1",
      "id": "1",
      "description": "A fix for this issue is checked into the tree and tested.",
      "name": "Fixed"
    },
    "customfield_10233": null,
    "customfield_10234": null,
    "customfield_14380": null,
    "lastViewed": null,
    "customfield_10580": null,
    "customfield_12880": null,
    "customfield_10581": null,
    "customfield_12882": null,
    "customfield_10220": null,
    "customfield_12881": null,
    "priority": {
      "self": "https://testserver.com/rest/api/2/priority/3",
      "iconUrl": "https://testserver.com/images/icons/priorities/major.svg",
      "name": "P3",
      "id": "3"
    },
    "customfield_10221": null,
    "customfield_10980": null,
    "customfield_10101": {
      "self": "https://testserver.com/rest/api/2/customFieldOption/10377",
      "value": "NO",
      "id": "10377"
    },
    "customfield_10222": null,
    "customfield_12883": "0|i13y67:",
    "labels": [],
    "customfield_13208": null,
    "aggregatetimeoriginalestimate": null,
    "timeestimate": null,
    "versions": [],
    "issuelinks": [],
    "assignee": {
      "self": "https://testserver.com/rest/api/2/user?username=user2",
      "name": "user2",
      "key": "user2",
      "emailAddress": "[e-mail]",
      "avatarUrls": {
        "48x48": "https://testserver.com/secure/useravatar?avatarId=10312",
        "24x24": "https://testserver.com/secure/useravatar?size=small&avatarId=10312",
        "16x16": "https://testserver.com/secure/useravatar?size=xsmall&avatarId=10312",
        "32x32": "https://testserver.com/secure/useravatar?size=medium&avatarId=10312"
      },
      "displayName": "Russell Pratt",
      "active": true,
      "timeZone": "EST5EDT"
    },
    "status": {
      "self": "https://testserver.com/rest/api/2/status/5",
      "description": "A resolution has been taken and is awaiting verification by reporter. From here issues are either reopened or are closed.",
      "iconUrl": "https://testserver.com/images/icons/statuses/resolved.png",
      "name": "Resolved",
      "id": "5",
      "statusCategory": {
        "self": "https://testserver.com/rest/api/2/statuscategory/3",
        "id": 3,
        "key": "done",
        "colorName": "green",
        "name": "Done"
      }
    },
    "components": [],
    "customfield_13281": null,
    "customfield_13280": null,
    "customfield_13283": null,
    "customfield_13282": null,
    "customfield_13680": null,
    "customfield_11780": "9223372036854775807",
    "customfield_11782": null,
    "customfield_13201": null,
    "customfield_11781": null,
    "customfield_10210": null,
    "customfield_13203": null,
    "customfield_13202": null,
    "customfield_13204": null,
    "aggregatetimeestimate": null,
    "customfield_14480": "com.atlassian.servicedesk.plugins.approvals.internal.customfield.ApprovalsCFValue@c4b41a5",
    "creator": {
      "self": "https://testserver.com/rest/api/2/user?username=userads",
      "name": "userads",
      "key": "userads",
      "emailAddress": "[e-mail]",
      "avatarUrls": {
        "48x48": "https://testserver.com/secure/useravatar?ownerId=userads&avatarId=15412",
        "24x24": "https://testserver.com/secure/useravatar?size=small&ownerId=userads&avatarId=15412",
        "16x16": "https://testserver.com/secure/useravatar?size=xsmall&ownerId=userads&avatarId=15412",
        "32x32": "https://testserver.com/secure/useravatar?size=medium&ownerId=userads&avatarId=15412"
      },
      "displayName": "User Ads",
      "active": true,
      "timeZone": "EST5EDT"
    },
    "customfield_10280": null,
    "subtasks": [],
    "customfield_10160": "org.hakanai.jira.plugins.StatusColor@54",
    "customfield_12580": null,
    "reporter": {
      "self": "https://testserver.com/rest/api/2/user?username=userads",
      "name": "userads",
      "key": "userads",
      "emailAddress": "[e-mail]",
      "avatarUrls": {
        "48x48": "https://testserver.com/secure/useravatar?ownerId=userads&avatarId=15412",
        "24x24": "https://testserver.com/secure/useravatar?size=small&ownerId=userads&avatarId=15412",
        "16x16": "https://testserver.com/secure/useravatar?size=xsmall&ownerId=userads&avatarId=15412",
        "32x32": "https://testserver.com/secure/useravatar?size=medium&ownerId=userads&avatarId=15412"
      },
      "displayName": "User Ads",
      "active": true,
      "timeZone": "EST5EDT"
    },
    "customfield_12980": null,
    "aggregateprogress": {
      "progress": 0,
      "total": 0
    },
    "customfield_10200": null,
    "progress": {
      "progress": 0,
      "total": 0
    },
    "customfield_14080": null,
    "issuetype": {
      "self": "https://testserver.com/rest/api/2/issuetype/3",
      "id": "3",
      "description": "A task that needs to be done.",
      "iconUrl": "https://testserver.com/secure/viewavatar?size=xsmall&avatarId=14808&avatarType=issuetype",
      "name": "Task",
      "subtask": false,
      "avatarId": 14808
    },
    "customfield_11080": null,
    "customfield_14191": null,
    "customfield_11081": null,
    "customfield_11082": null,
    "customfield_11083": null,
    "customfield_10270": null,
    "customfield_11084": null,
    "customfield_13780": null,
    "timespent": null,
    "customfield_10150": null,
    "customfield_11480": null,
    "customfield_13782": null,
    "customfield_10152": null,
    "customfield_13781": null,
    "project": {
      "self": "https://testserver.com/rest/api/2/project/10162",
      "id": "10162",
      "key": "SEA",
      "name": "Test Automation",
      "avatarUrls": {
        "48x48": "https://testserver.com/secure/projectavatar?pid=10162&avatarId=10032",
        "24x24": "https://testserver.com/secure/projectavatar?size=small&pid=10162&avatarId=10032",
        "16x16": "https://testserver.com/secure/projectavatar?size=xsmall&pid=10162&avatarId=10032",
        "32x32": "https://testserver.com/secure/projectavatar?size=medium&pid=10162&avatarId=10032"
      },
      "projectCategory": {
        "self": "https://testserver.com/rest/api/2/projectCategory/10020",
        "id": "10020",
        "description": "All IT related tasks and projects",
        "name": "Corporate IT"
      }
    },
    "customfield_11880": null,
    "aggregatetimespent": null,
    "resolutiondate": "2016-04-21T09:59:34.000-0400",
    "workratio": -1,
    "customfield_14190": null,
    "customfield_14182": null,
    "customfield_14183": null,
    "watches": {
      "self": "https://testserver.com/rest/api/2/issue/SEA-738/watchers",
      "watchCount": 2,
      "isWatching": false
    },
    "customfield_14181": null,
    "customfield_14186": null,
    "customfield_10380": null,
    "customfield_12680": null,
    "created": "2016-04-07T13:11:56.000-0400",
    "customfield_10260": null,
    "customfield_14185": null,
    "customfield_10140": null,
    "customfield_10261": null,
    "customfield_10020": {
      "self": "https://testserver.com/rest/api/2/customFieldOption/10380",
      "value": "S3",
      "id": "10380"
    },
    "customfield_10262": null,
    "customfield_10780": null,
    "updated": "2016-04-21T10:27:28.000-0400",
    "customfield_13081": null,
    "customfield_13080": null,
    "customfield_13083": "To be filled in by Engineering",
    "customfield_11180": null,
    "customfield_13082": null,
    "customfield_11181": null,
    "customfield_13085": null,
    "customfield_11182": null,
    "customfield_13084": null,
    "customfield_11580": null,
    "customfield_11183": null,
    "customfield_13087": null,
    "customfield_13086": null,
    "timeoriginalestimate": null,
    "customfield_13881": null,
    "customfield_10130": null,
    "description": "We need to update CTL logins for Cuke and RC.Currently the way the automation is setup, we can only use one user per environment, so please pick one from below for UAT and a different one for Prod.\r\n\r\n1. uat_centurylinknet:\r\n  :username: [e-mail]\r\n  :password: P@ssw0rd!\r\n2. uat_embarqmailcom:\r\n  :username: [e-mail]\r\n  :password: P@ssw0rd!\r\n3. uat_qcom:\r\n  :username: [e-mail]\r\n  :password: P@ssw0rd!\r\n4. prod_centurylinknet:\r\n  :username: [e-mail]\r\n  :password: test03\r\n5. prod_embarqmailcom:\r\n  :username: [e-mail]\r\n  :password: test25\r\n6. prod_qcom:\r\n  :username: [e-mail]\r\n  :password: test01",
    "customfield_13880": null,
    "customfield_11980": null,
    "customfield_10011": null,
    "customfield_10253": null,
    "customfield_10012": null,
    "customfield_10007": null,
    "customfield_10008": null,
    "customfield_10009": null,
    "summary": "Update CTL Logins",
    "customfield_13191": null,
    "customfield_13190": null,
    "customfield_14282": null,
    "customfield_13193": null,
    "customfield_13192": null,
    "customfield_14280": null,
    "customfield_13195": null,
    "customfield_14285": null,
    "customfield_13194": null,
    "customfield_14283": null,
    "customfield_10084": null,
    "customfield_10480": null,
    "customfield_13196": null,
    "customfield_14284": null,
    "customfield_10085": null,
    "customfield_12780": null,
    "customfield_10120": null,
    "customfield_10241": null,
    "customfield_10088": null,
    "customfield_10121": null,
    "customfield_10000": [
      {
        "self": "https://testserver.com/rest/api/2/customFieldOption/10009",
        "value": "CenturyLink",
        "id": "10009"
      }
    ],
    "customfield_10242": null,
    "customfield_10880": null,
    "customfield_10089": null,
    "customfield_10122": null,
    "customfield_10243": null,
    "customfield_10002": null,
    "customfield_10244": null,
    "customfield_10486": null,
    "customfield_10124": null,
    "customfield_10003": null,
    "customfield_10245": null,
    "customfield_10487": null,
    "customfield_10488": null,
    "customfield_10236": null,
    "customfield_10237": null,
    "environment": null,
    "duedate": null
      }
    }
  ]
}

解决方案
You don't give any details about the expected form of the output, but the following jq filter produces the information you seem to want (but some of your requirements are not too clear to me):
(.issues[] | {key, status: .fields.status.name, assignee: .fields.assignee.emailAddress}),
(.issues|length)
Output:
 {  
  "key": "SEA-739",
  "status": "Open",
  "assignee": null
}
{
  "key": "SEA-738",
  "status": "Resolved",
  "assignee": "[e-mail]"
}
2


Postscript

If you want a one-liner that will produce the values as a stream, without quotation marks, consider:
$ jq -r '.issues | ((.[] | (.key, .fields.status.name, .fields.assignee.emailAddress)),length)'
Output:
SEA-739
Open
null
SEA-738
Resolved
[e-mail]
2


                        
这篇关于使用unix和jq从其余API输出中提取对象/数组值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！