Martin_Browne | 2018-11-16 15:17:48 UTC | #1
When the customer runs the command below - obviously supplying the correct SQL Server DB, Login Information etc. the utility runs correctly and creates the DB/Tables etc.
https://bitbucket.org/GenesysCSP/purecloud-stats-dispatcher/overview
However the Conversation Table only contains Three Fields
ConversationID ConversationStart ConversationEnd
If we access the conversation information via the PureCloud API
GET /api/v2/conversations/calls/
We are able to see all information related to the conversation including all included in JSON below:
QUESTION: WHY IS THE PURECLOUD STATS DISPATCHER ONLY PULLING BACK THREE FIELDS TO SQL TABLE CONVERSATIONS
{ "id": "c8a12044-ed94-4f8b-b2fb-739ffe0fdfab", "participants": { "id": "f1547023-7ff3-4e57-86b0-3747790316d6", "name": "Irish Number", "address": "tel:868112801", "startTime": "2018-10-18T10:54:26.923Z", "connectedTime": "2018-10-18T10:54:26.957Z", "endTime": "2018-10-18T10:55:59.424Z", "purpose": "customer", "state": "terminated", "direction": "inbound", "disconnectType": "endpoint", "held": false, "wrapupRequired": false, "queue": { "id": "29fa7d15-fa5c-4509-856d-0f20c1e17595", "selfUri": "/api/v2/routing/queues/29fa7d15-fa5c-4509-856d-0f20c1e17595" }, "attributes": { "ActavoSPHCMenuOneSelection": "", "ScreenPopId": "cc2a40e0-9c40-11e6-ba6a-5d09f5b80b6d", "paymentResult": "Not Selected", "EirScriptPageHeader": "Eir - Sales, Service & eir Mobile", "ActavoSPHCMenuTwoSelection": "", "EirScript_URL": "[https://www.eir.ie/", "ScreenPopName": "Eir - Sample" }, "script": { "id": "cc2a40e0-9c40-11e6-ba6a-5d09f5b80b6d", "selfUri": "/api/v2/scripts/cc2a40e0-9c40-11e6-ba6a-5d09f5b80b6d" }, "provider": "Edge", "muted": false, "confined": false, "recording": false, "recordingState": "none", "ani": "tel:868112801", "dnis": "tel:+35361485746" }, { "id": "453237d9-db91-4c74-8eb5-5f486d611fee", "name": "Limerick, Ireland", "address": "sip:9407b24b-1024-449a-8609-a4a7099da05c@127.0.0.1;language=en-GB;user=ivr", "startTime": "2018-10-18T10:54:26.936Z", "connectedTime": "2018-10-18T10:54:26.944Z", "endTime": "2018-10-18T10:54:36.941Z", "purpose": "ivr", "state": "terminated", "direction": "inbound", "disconnectType": "transfer", "held": false, "wrapupRequired": false, "attributes": {}, "provider": "Edge", "peer": "5e26071d-b74f-4f21-9f75-35663213eae3", "muted": false, "confined": false, "recording": false, "recordingState": "none", "ani": "tel:868112801", "dnis": "sip:9407b24b-1024-449a-8609-a4a7099da05c@127.0.0.1;language=en-GB;user=ivr" }, { "id": "a7eb69d9-7efa-4ff3-a343-54f79bcdadb1", "name": "EIR - Sales, Service & eir Mobile", "address": "sip:29fa7d15-fa5c-4509-856d-0f20c1e17595@127.0.0.1;language=en-US;src=https://edge-proxy.eu-west-1.mypurecloud.ie/connector/v1/organizations/f5285863-142e-47b4-89da-b040fc4fcb24/defaults/ivr/27af8887-1968-41f0-b5e3-799f21eb3786/defaultentrypoint.vxml;user=acd", "startTime": "2018-10-18T10:54:36.903Z", "connectedTime": "2018-10-18T10:54:36.911Z", "endTime": "2018-10-18T10:54:39.336Z", "purpose": "acd", "state": "terminated", "direction": "inbound", "disconnectType": "transfer", "held": false, "wrapupRequired": false, "queue": { "id": "29fa7d15-fa5c-4509-856d-0f20c1e17595", "selfUri": "/api/v2/routing/queues/29fa7d15-fa5c-4509-856d-0f20c1e17595" }, "attributes": { "ivr.LanguageSkill": "bc7b4d28-2f70-4091-a107-5bbb13c6ebac", "ivr.Priority": "6", "ivr.Skills": "8022e435-beef-4c58-ba28-8de55a374dad" }, "provider": "Edge", "peer": "5e26071d-b74f-4f21-9f75-35663213eae3", "muted": false, "confined": false, "recording": false, "recordingState": "none", "ani": "tel:868112801", "dnis": "sip:29fa7d15-fa5c-4509-856d-0f20c1e17595@127.0.0.1;language=en-US;src=https://edge-proxy.eu-west-1.mypurecloud.ie/connector/v1/organizations/f5285863-142e-47b4-89da-b040fc4fcb24/defaults/ivr/27af8887-1968-41f0-b5e3-799f21eb3786/defaultentrypoint.vxml;user=acd" }, { "id": "1ef4d9ee-5687-405d-a777-8bfdd43b854d", "address": "sip:55f93085c8408d12593a5a17+wrendatalimited.orgspan.com;tgrp=15be328e-87bf-424d-9266-22fe50ababfd;trunk-context=wrendatalimited@localhost", "startTime": "2018-10-18T10:54:37.153Z", "connectedTime": "2018-10-18T10:54:39.334Z", "endTime": "2018-10-18T10:55:59.428Z", "purpose": "agent", "state": "terminated", "direction": "inbound", "disconnectType": "peer", "held": false, "wrapupRequired": true, "wrapupPrompt": "optional", "user": { "id": "8bc8596f-43a2-46f3-a9e3-83a857c56925", "selfUri": "/api/v2/users/8bc8596f-43a2-46f3-a9e3-83a857c56925" }, "queue": { "id": "29fa7d15-fa5c-4509-856d-0f20c1e17595", "selfUri": "/api/v2/routing/queues/29fa7d15-fa5c-4509-856d-0f20c1e17595" }, "attributes": {}, "alertingTimeoutMs": 8000, "provider": "Edge", "peer": "5e26071d-b74f-4f21-9f75-35663213eae3", "muted": false, "confined": false, "recording": false, "recordingState": "none", "ani": "sip:868112801@192.168.100.134;user=phone", "dnis": "sip:55f93085c8408d12593a5a17+wrendatalimited.orgspan.com;tgrp=15be328e-87bf-424d-9266-22fe50ababfd;trunk-context=wrendatalimited@localhost" } ], "otherMediaUris": [], "recordingState": "none", "selfUri": "/api/v2/conversations/calls/c8a12044-ed94-4f8b-b2fb-739ffe0fdfab"
system | 2018-12-17 15:17:01 UTC | #2
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 3994