>我有一个带有 JQ 的脚本 bash,但不知道如何执行查询以获得以下结果:
conversationId(1(,participant Id(1(,participant Name(1(,sessionId(1( 对话 Id(1(,参与者 Id(2(,参与者姓名 (2(,会话 ID(2( 对话 Id(1(,参与者 Id(3(,参与者姓名 (3(,会话 ID(3( 对话 Id(2(,参与者 Id(4(,参与者姓名 (4(,会话 ID(4( . . . conversationId(n(,participant Id(n(,participant Name(n(,sessionId(n(
我的文件: 数据.json
{
"conversations": [
{
"conversationId": "cxx-cccc-4444-9999-b11111111",
"conversationStart": "2016-06-5T00:10:15.412Z",
"conversationEnd": "2016-06-5T00:11:19.447Z",
"participants": [
{
"participantId": "2aaaa-1555-4590-99aa-4yyyyyyy",
"userId": "91111-7rrrr-4000-aqaa-23232323",
"purpose": "user",
"sessions": [
{
"mediaType": "voice",
"sessionId": "1111111-aaaa-4009-9000-488888",
"ani": "sip:user+localhost.com@localhost",
"direction": "outbound",
"dnis": "tel:+1111110000",
"edgeId": "e3e3e3-4ª4q-4b4b-9792-95959595",
"segments": [
{
"segmentStart": "2016-06-15T00:10:15.412Z",
"segmentEnd": "2016-06-15T00:10:10.485Z",
"segmentType": "contacting",
"conference": false
},
{
"segmentStart": "2016-06-15T00:10:10.485Z",
"segmentEnd": "2016-06-15T00:10:10.522Z",
"segmentType": "dialing",
"conference": false
},
{
"segmentStart": "2016-06-15T00:20:10.522Z",
"segmentEnd": "2016-06-15T00:11:09.436Z",
"disconnectType": "client",
"segmentType": "interact",
"conference": false
}
]
}
]
},
{
"participantId": "e9e9e9-d777-4a4a-8989-aeaeaeaeae",
"participantName": "Namek, Sayayin",
"purpose": "ivr",
"sessions": [
{
"mediaType": "voice",
"sessionId": "262626-6000-4cdd-a511-fafafafa",
"ani": "sip:goku%localhost.com@localhost",
"direction": "inbound",
"edgeId": "e3e3e3e3-4abc-4abc-9700-95959595",
"remoteNameDisplayable": "Namek, Sayayin",
"segments": [
{
"segmentStart": "2016-06-15T00:10:10.510Z",
"segmentEnd": "2016-06-15T00:10:10.521Z",
"segmentType": "system",
"conference": false
},
{
"segmentStart": "2016-06-15T00:10:20.521Z",
"segmentEnd": "2016-06-15T00:11:39.447Z",
"disconnectType": "peer",
"segmentType": "ivr",
"conference": false
}
]
}
]
}
]
},
{
"conversationId": "09090909-6b60-8888-xxxx-9yyyyyyyy",
"conversationStart": "2016-06-15T00:11:38.867Z",
"conversationEnd": "2016-06-15T01:54:55.744Z",
"participants": [
{
"participantId": "xxxc-cccc1-4123-7777-343434343e",
"userId": "9qwer-7zxc-40df-aghj-2323232323",
"purpose": "user",
"sessions": [
{
"mediaType": "voice",
"sessionId": "101010-0faz-4xxx-yyyy-4419441",
"ani": "sip:goku+localhost.com@localhost",
"direction": "outbound",
"dnis": "tel:+11112222333",
"edgeId": "nenene1-qwer-tyui-9000-9595gggh",
"segments": [
{
"segmentStart": "2016-06-15T00:11:18.867Z",
"segmentEnd": "2016-06-15T00:11:42.637Z",
"segmentType": "contacting",
"conference": false
}
]
} ]
} ]
} ]
}
我的查询 jq:
JQ .'{conversationId: .conversations[].conversationId, 参与者标识: .conversations[].參與者[].參與者Id,參與者姓名: .conversations[].參與者[].參與者名稱} | join(","('
但是字段 对话 ID 和参与者名称重复了几次......
根据您的输入,以下过滤器:
.conversations[]
| [.conversationId]
+ (.participants[] | [.participantId, .participantName])
生产:
[
"cxx-cccc-4444-9999-b11111111",
"2aaaa-1555-4590-99aa-4yyyyyyy",
null
]
[
"cxx-cccc-4444-9999-b11111111",
"e9e9e9-d777-4a4a-8989-aeaeaeaeae",
"Namek, Sayayin"
]
[
"09090909-6b60-8888-xxxx-9yyyyyyyy",
"xxxc-cccc1-4123-7777-343434343e",
null
]
变体
请注意,上面的过滤器不使用任何 jq 变量。 有时介绍它们会有所帮助,因此可能会对以下变体感兴趣:
.conversations[]
| (.participants | range(0;length)) as $j
| [.conversationId]
+ (.participants[$j] | [.participantId, .participantName])
在jq手册的帮助下,您应该可以从这里获取它。
补遗
参与者 Id(1(,sessionId(1(,mediaType(1(,sessionId(1(,ani(1(,dnis(1(
我不太确定你为什么要sessionsId
两次,但以下内容对应于你的第二个请求:
.conversations[].participants[]
| [.participantId] +
(.sessions[] | [.sessionId, .mediaType, .sessionId, .ani, .dnis])