Other: an object not showing in conversations table in BQ coming from Kustomer
Answered
I want to expose “answers” field within the conversions table. Below is an example of where this field exists in the conversation json file.
{
"data":{
"type":"conversation",
"id":"62e2a005151cbaea4d9cf6e0",
"attributes":{
"name":"Luggage Storage",
"preview":"Thank you!",
"channels":[
"chat"
],
"status":"done",
"open":{
"statusAt":"2022-07-28T14:41:11.350Z"
},
"messageCount":32,
"noteCount":1,
"satisfaction":0,
"satisfactionLevel":{
"sentByTeams":[
"5d81171844ccc500131a4282",
"61ad0c66e17cc1b3855ec440",
"61ad0c8cc7b8962acc937d8b",
"624367f37a86e4e5c13afc1a",
"62d1e0b34ee55772794f60a2"
],
"formResponse":"62e2a45f3a9f6a2ceaf69001",
"form":"5d6924c5020700001a32531d",
"channel":"chat",
"status":"commented",
"scheduledFor":"2022-07-28T14:59:43.387Z",
"createdAt":"2022-07-28T14:59:43.387Z",
"sentAt":"2022-07-28T14:59:44.543Z",
"updatedAt":"2022-07-28T15:00:08.391Z",
"rating":5,
"score":1,
"firstAnswer":"you are awesome..",
"answers":[
{
"selections":[
],
"selectionsRaw":[
],
"questionId":"5d6924c5020700001a32531c",
"answer":"you are awesome.."
},
{
"selections":[
],
"selectionsRaw":[
],
"questionId":"62cdd7288a7e9d1133b46a26",
"answer":"Strongly Agree",
"answerRaw":"Strongly Agree"
}
],
"sentBy":"612fe4ad5e6d6700191d4177"
},
"createdAt":"2022-07-28T14:41:11.350Z",
"updatedAt":"2022-07-28T15:10:10.391Z",
"modifiedAt":"2022-07-28T14:59:43.030Z",
"lastActivityAt":"2022-07-28T15:10:10.391Z",
"spam":false,
"ended":true,
"endedAt":"2022-07-28T14:59:42.976Z",
"endedReason":"user_ended",
"endedByType":"user",
"tags":[
"5e9f7242dfc261001979e9e4",
"613a74d396b2250dfc335a66",
"61112db89df93fb89dfd638a",
"60347299204a7634142bcc3f"
],
"suggestedTags":[
],
"predictions":[
],
"sentiment":{
},
"suggestedShortcuts":[
],
"firstMessageIn":{
"firstDelivered":{
"timestamp":"2022-07-28T14:41:11.293Z",
"clientType":"web"
},
"id":"62e2a007f962e33358d04cbd",
"sentAt":"2022-07-28T14:41:11.293Z",
"createdAt":"2022-07-28T14:41:11.984Z",
"directionType":"initial-in",
"channel":"chat",
"meta":{
"trackingId":"62e297e3b9bcd433403cd8e5",
"payload":"Other Question"
}
},
"firstMessageOut":{
"firstDelivered":{
},
"createdByTeams":[
"5d81171844ccc500131a4282",
"61ad0c66e17cc1b3855ec440",
"61ad0c8cc7b8962acc937d8b",
"624367f37a86e4e5c13afc1a",
"62d1e0b34ee55772794f60a2"
],
"id":"62e2a176957e340b179d095b",
"sentAt":"2022-07-28T14:47:24.039Z",
"createdAt":"2022-07-28T14:47:24.132Z",
"channel":"chat",
"directionType":"response-out",
"createdBy":"612fe4ad5e6d6700191d4177"
},
"lastMessageIn":{
"id":"62e2a44b0c16c085549112dd",
"sentAt":"2022-07-28T14:59:23.427Z",
"createdAt":"2022-07-28T14:59:23.840Z",
"meta":{
"trackingId":"62e297e3b9bcd433403cd8e5",
"to":null
},
"channel":"chat"
},
"lastMessageOut":{
"id":"62e2a43b91a8c076a409ff74",
"sentAt":"2022-07-28T14:59:33.487Z",
"createdAt":"2022-07-28T14:59:33.745Z",
"createdBy":"612fe4ad5e6d6700191d4177"
},
"lastMessageAt":"2022-07-28T14:59:33.487Z",
"lastMessageUnrespondedTo":{
},
"lastMessageUnrespondedToSinceLastDone":{
},
"assignedUsers":[
"612fe4ad5e6d6700191d4177"
],
"assignedTeams":[
"5d81171844ccc500131a4282"
],
"firstResponse":{
"createdByTeams":[
"5d81171844ccc500131a4282",
"61ad0c66e17cc1b3855ec440",
"61ad0c8cc7b8962acc937d8b",
"624367f37a86e4e5c13afc1a",
"62d1e0b34ee55772794f60a2"
],
"assignedTeams":[
"5d81171844ccc500131a4282"
],
"assignedUsers":[
"612fe4ad5e6d6700191d4177"
],
"id":"62e2a176957e340b179d095b",
"time":42520,
"businessTime":42520,
"createdAt":"2022-07-28T14:47:24.132Z",
"createdBy":"612fe4ad5e6d6700191d4177",
"sentAt":"2022-07-28T14:47:24.039Z",
"responseTime":42520
},
"firstResponseSinceLastDone":{
"createdByTeams":[
"5d81171844ccc500131a4282",
"61ad0c66e17cc1b3855ec440",
"61ad0c8cc7b8962acc937d8b",
"624367f37a86e4e5c13afc1a",
"62d1e0b34ee55772794f60a2"
],
"assignedTeams":[
"5d81171844ccc500131a4282"
],
"assignedUsers":[
"612fe4ad5e6d6700191d4177"
],
"id":"62e2a176957e340b179d095b",
"time":42520,
"businessTime":42520,
"createdAt":"2022-07-28T14:47:24.132Z",
"createdBy":"612fe4ad5e6d6700191d4177",
"sentAt":"2022-07-28T14:47:24.039Z",
"responseTime":42520
},
"lastResponse":{
"createdByTeams":[
"5d81171844ccc500131a4282",
"61ad0c66e17cc1b3855ec440",
"61ad0c8cc7b8962acc937d8b",
"624367f37a86e4e5c13afc1a",
"62d1e0b34ee55772794f60a2"
],
"assignedTeams":[
"5d81171844ccc500131a4282"
],
"assignedUsers":[
"612fe4ad5e6d6700191d4177"
],
"id":"62e2a43b91a8c076a409ff74",
"time":10060,
"businessTime":10060,
"createdAt":"2022-07-28T14:59:33.745Z",
"createdBy":"612fe4ad5e6d6700191d4177"
},
"firstDone":{
"createdByTeams":[
"5d81171844ccc500131a4282",
"61ad0c66e17cc1b3855ec440",
"61ad0c8cc7b8962acc937d8b",
"624367f37a86e4e5c13afc1a",
"62d1e0b34ee55772794f60a2"
],
"assignedTeams":[
"5d81171844ccc500131a4282"
],
"assignedUsers":[
"612fe4ad5e6d6700191d4177"
],
"time":1111626,
"businessTime":1111626,
"createdAt":"2022-07-28T14:59:42.976Z",
"createdBy":"612fe4ad5e6d6700191d4177",
"noteCount":0,
"messageCount":32,
"messageCountByChannel":{
"chat":32
},
"outboundMessageCount":20,
"outboundMessageCountByChannel":{
"chat":20
},
"lastMessageDirection":"out",
"lastMessageDirectionType":"response-out"
},
"lastDone":{
"createdByTeams":[
"5d81171844ccc500131a4282",
"61ad0c66e17cc1b3855ec440",
"61ad0c8cc7b8962acc937d8b",
"624367f37a86e4e5c13afc1a",
"62d1e0b34ee55772794f60a2"
],
"assignedTeams":[
"5d81171844ccc500131a4282"
],
"assignedUsers":[
"612fe4ad5e6d6700191d4177"
],
"time":1111626,
"businessTime":1111626,
"createdAt":"2022-07-28T14:59:42.976Z",
"createdBy":"612fe4ad5e6d6700191d4177",
"noteCount":0,
"messageCount":32,
"messageCountByChannel":{
"chat":32
},
"outboundMessageCount":20,
"outboundMessageCountByChannel":{
"chat":20
},
"lastMessageDirection":"out",
"lastMessageDirectionType":"response-out"
},
"doneCount":1,
"direction":"in",
"custom":{
"chatSourceStr":"https://guest.kasa.com/help",
"reservationConfirmationCodeStr":"EXP-HAEjaL60",
"chatTopicSelectionStr":"Other Question",
"originTree":"none",
"rulesRanBool":true,
"issueCategory1Tree":"kbc.kbc_manual_follow_up"
},
-
Official comment
Hi Muna,
Thanks for writing in. My apologies for accidentally converting this to a support ticket. It looks like Conversations Answers are part of a questionnaire functionality. Is that right? We'd like to support this eventually, but currently have no plans to add this. We'll continue to monitor for demand and will update when we have more to share!
Please sign in to leave a comment.
Comments
1 comment