WxCC Analyzer reports API Integration

[c.georgiou1]

We currently send via a schedule in Analyzer a weekly data dump of calls data that a SUP has to copy-paste into a SharePoint file which is then imported to a number of reports.

 We’re looking for a more automated way to handle this process. I wanted to reach out to see if we could connect our BigQuery environment to the WebEx report data using an API or some other kind of automated data exchange. Any ideas? 

[sandiban]

Hi @c.georgiou1,
Thanks for your patience so far!
As of now, the only way to send the scheduled Analyzer report request is through the schedule in analyzer, basically the way you're following.
But we don't have any other automated process or, integration to send such requests to Analyzer as of now. Thanks!

Regards,
Sandip

[c.georgiou1]

Thank you for your reply and appreciate your support.  So this is not even possible with some API integration?  This is what i found below, is this valid?  I believe it more to do with Webex Analyzer sending an automated request to BigQuery

You can definitely automate this process by integrating Webex report data with your BigQuery environment using APIs. Here are the steps to achieve this:

1. Use Webex Reports API: Webex provides a Reports API that allows you to generate and download reports programmatically. You'll need an administrator token with the analytics:read_all scope
   1
   . You can find more details on how to use this API in the Webex for Developers documentation
   1
   .
2. Set Up BigQuery Integration: You can use tools like n8n to integrate Webex with Google BigQuery. n8n allows you to design workflows that extract, transform, and load data between Webex and BigQuery. You can use the HTTP Request node to make custom API calls to Webex and then route the data to BigQuery
   
   
3. Automate Data Flow: Create a workflow in n8n that triggers on a schedule or an event. Use the Webex Reports API to fetch the report data and then use the BigQuery node to insert this data into your BigQuery tables
   3
   2
   .
4. Use ETL Tools: Alternatively, you can use ETL tools like Portable to integrate Webex data with BigQuery. Portable simplifies the process by managing the ETL scripts for you

Reports

To access these endpoints, you must use an administrator token with the analytics:read_all scope. The authenticated user must be a read-only or full administrator of the organization to which the report belongs.

To use this endpoint the org needs to be licensed for the Pro Pack.

Reports available via Webex Control Hub may be generated and downloaded via the Reports API. To access this API, the authenticated user must be a read-only or full administrator of the organization to which the report belongs.

For more information about Reports, see the Admin API guide.

Method

Description

GEThttps://webexapis.com/v1/reports

List Reports

POSThttps://webexapis.com/v1/reports

Create a Report

GEThttps://webexapis.com/v1/reports/{reportId}

Get Report Details

DELETEhttps://webexapis.com/v1/reports/{reportId}

Delete a Report

[Jeff Marshall]

The reports that can be generated with the Reports API are Webex Suite focused and not Webex Contact Center. You can see a list of all reports that can be generated with this API on https://help.webex.com/en-us/article/nmug598/Reports-for-Your-Cloud-Collaboration-Portfolio#reference-template_c455d679-f17f-48c0-bc79-7b621c30bbe2. 

For getting data from Contact Center you can use the Search API(https://developer.webex-cx.com/documentation/search). It allows you to pull data about agents and tasks using GraphQL queries. More info can be found on https://developer.webex-cx.com/documentation/guides/getting-started-with-search-api. You should be able to get the same data you can get from Analyzer and then pull that data into your own system.