andygunther | 2016-09-22 22:32:25 UTC | #1
Has anyone investigated creating a Web Data Connector for Tableau to access historical queue data through the Analytics API?
RogierBosch | 2016-11-28 11:56:52 UTC | #2
In the nearby future we are gonna test / start with web data connector for Tableau. What is your current status?
andygunther | 2016-11-28 14:55:02 UTC | #3
I didn't get very far. I had a hard time getting the Tableau examples to work properly. And, the throttling requirements of the Analytics API took me in a direction where I think we're going to use a Windows service to pull data on intervals into a local SQL server instead of directly connecting Tableau to the API.
That said, if you do get it working, we may be interested in purchasing it from you in the future.
Thanks!
dsouther | 2016-11-28 14:57:15 UTC | #4
That's exactly what I'm doing. We are also looking at pulling conversation details reports into an into an intermediary no-sql database
RogierBosch | 2016-12-04 15:36:30 UTC | #5
In januari we have some time to look in to this. I will keep you'll posted.
TGL_BA | 2017-04-09 23:25:22 UTC | #6
Hi All
Has there been any further developments in being able to extract Interactions data so that Tableau can be used for reporting?
tim.smith | 2017-04-10 15:26:15 UTC | #7
There's not an existing configuration, but you can create one for https://github.com/MyPureCloud/open-data-exporter.
TGL_BA | 2017-05-01 21:18:48 UTC | #8
As i'm none technical but can navigate around some JSON using the Postman tool-set. Are there any examples to show how i can retrieve basic QUEUE metrics or Agent activity reports?
for example Retrieve all Wrapup codes added by Agent XX between 8:00am - 5:00pm on dd/mm/yy cheers
tim.smith | 2017-05-01 21:26:55 UTC | #9
The Call Detail Report example would be a good start. You would need to use a new transform to pick the agent segment with the wrap up code and flatten the data structure and then edit the template accordingly.
If you wanted to go for minimal effort, you could just add a column to the template for wrap up code and update the transform to find the wrap up code and copy it to the participant so it's the correct place for the template.
tim.smith | 2017-05-01 21:28:21 UTC | #10
Before going the custom route, I'd suggest reviewing the OOTB reports to see if any fit your needs: https://help.mypurecloud.com/articles/about-reports/
system | 2017-08-28 19:27:28 UTC | #11
This post was migrated from the old Developer Forum.
ref: 425