John.Morgan | 2017-11-09 16:30:07 UTC | #1
We are working with a client to build an audit "counting" query between calls on the purecloud platform and calls extracted to an external application. The query requires us to filter on the "department" flag for an agent participant, on conversation length, and a date range.
Is there an option in the API to join both user details and conversation details, filtering both for the data, or would we need to pull down both and filter this locally to create the COUNT() based on what drops out?
tim.smith | 2017-11-09 17:13:53 UTC | #2
John.Morgan, post:1, topic:2079
Is there an option in the API to join both user details and conversation details
No. You'll need to perform the analytics queries for conversations, retrieve the necessary user data, aggregate the data sets, then perform additional filtering on the merged dataset yourself. There's an open source project that you may find useful for this task: https://github.com/MyPureCloud/open-data-exporter
system | 2017-12-10 17:13:34 UTC | #3
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: 2079