charaf_ed | 2019-12-06 19:40:56 UTC | #1
Hello,
Statistics are managed by the Tableau server solution in our case.
I would like to know if it is possible to automatically generate reports through purecloud APIs and deposit these reports in a database (SQL server) --> Tableau server will use these input reports to draw graphs
Any suggestions ?
CHARAF
anon28066628 | 2019-12-09 14:33:00 UTC | #2
Hi Charaf, there is no built-in / automatic integration to pull PureCloud analytics into an SQL db. You must use the REST API to get your required aggregate and detail analytics as needed and transform them to a flat table or relational form.
There are partner solutions such as MyPureInsights that can sync PureCloud data to a hosted or on-prem db.
charaf_ed | 2019-12-09 14:46:45 UTC | #3
Hi and Thank you @anon28066628
Should I use https://developer.mypurecloud.de/developer-tools/#/analytics-query-builder To extract data using the API ? How to transform them to a table ?
Thank you
anon28066628 | 2019-12-09 15:24:32 UTC | #4
The Analytics Query Builder will help you test queries and analyze the data. You'd need to build an App to extract the data (in JSON) and transform it to the format you need.
charaf_ed | 2019-12-11 09:26:25 UTC | #5
Would it be possible to extract some metrics, such as : Avg wait, ASA, Total Queue ... ?
Thank you
anon28066628 | 2019-12-11 14:02:22 UTC | #6
Yes, those are supported. I'd suggest starting with this article, and the other overview articles:
https://developer.mypurecloud.com/api/rest/v2/analytics/overview.html
https://developer.mypurecloud.com/api/rest/v2/analytics/conversation_aggregate.html
https://developer.mypurecloud.com/api/rest/v2/analytics/metrics.html
system | 2020-01-10 14:02:05 UTC | #7
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 6662