Legacy Dev Forum Posts

 View Only

Sign Up

API query to extract exactly the same data as the reports template in PureCloud

  • 1.  API query to extract exactly the same data as the reports template in PureCloud

    Posted 06-05-2025 18:12

    Erison_Mogari | 2017-07-26 19:54:44 UTC | #1

    Hello,

    It would be possible to provide the exact API query code to generate the same data as the

    1. Interaction Details report
    2. Outbound Campaign: Detailed Attempt History

    We want to storage this information in our servers to make faster to retrieve for analysis. But all attempts we had extract this number, does not match with the reports generated throught the PureCloud GUI.


    tim.smith | 2017-07-26 19:59:43 UTC | #2

    The report columns are documented for each report here: https://help.mypurecloud.com/articles/about-reports/. Click on a column in the report to see its description. If you find the documentation is unclear for any particular column, let me know.


    Erison_Mogari | 2017-07-26 20:32:22 UTC | #3

    Hi Tim,

    Thanks for the quickly reply. I know the definition of each metric, however the attempts when we tried to extract these number via API, the total of interactions are never the same as the available in the reports.

    One of the last attempt to recreate the interaction details, we retrived all the conversation details, and process the result to reach the same report, but is not concise

    It would be possible to share how the extraction is done for these reports?

    { "interval": "2017-07-07T11:00:00.000Z/2017-07-07T13:00:00.000Z", "order": "asc", "orderBy": "conversationStart", "paging": { "pageSize": "100", "pageNumber": 1 }, "segmentFilters": [ { "type": "and", "predicates": [ { "type": "dimension", "dimension": "outboundCampaignId", "operator": "matches", "value": "eb4fef28-41eb-4591-8de4-eb0440ec46b9" }, { "type": "dimension", "dimension": "queueId", "operator": "exists", "value": null } ] } ] }


    tim.smith | 2017-07-28 15:50:07 UTC | #4

    Erison_Mogari, post:3, topic:1602
    It would be possible to share how the extraction is done for these reports?

    The report documentation exists to describe the analytics queries used to collect the data for the report. This process isn't public, so sharing information about it wouldn't be useful in the context of the Platform API.

    To reconcile your data, try using an interval as short as possible with as few data points as possible so you can review the raw conversation data and compare it to the summaries in the reports and in your queries. That should show you the delta between the raw data and your summaries to help you identify how you need to alter your query.

    If you need hands-on assistance building your queries, Genesys Professional Services can be hired to assist. Your sales rep, account manager, or CSM can initiate that engagement.


    system | 2017-08-28 15:50:57 UTC | #5

    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: 1602