cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1012
Views
3
Helpful
10
Replies

Webex to power bi

simraj
Level 1
Level 1

Hello everyone,

Can someone please guide me through this?  I need to get my companies webex contact center data into power bi, how and what do I need to do to get that?  Thanks for your help!

10 Replies 10

The GraphQL API will be your source of data which PowerBI should support. What we did for another customer is bring the data down to a SQL database and then had PowerBI query that as working with GQL is pretty rough.

david

Actually I would prefer that, how can I get the data to sql database? 
Is there specific department or people who can help you get this from webex?

You'd probably want your developers to take a look at the documentation David is talking about, like here.
https://developer.webex-cx.com/documentation/guides/getting-started-with-search-api

Yep, this is the main API our middleware hits. You will need something that fetches that information and then puts it in your DB.

david

Can you give me some examples of what can I use to fetch that information to put it in our DB?

When you say your developers do you mean the webex developers assigned to us?

There is no ready made solution for this. You as the customer needs to use and consume the available APIs to create your own solution to get the data and work with it as fits your needs.



Response Signature


You would either need your internal staff to do this, or go to a Cisco partner who can do it for you.

Does anyone have any idea on which API endpoint was being called for this



curl --request \
POST \
    --url 'https://api.wxcc-us1.cisco.com/search?orgId=YOUR_ORGID' \
    --header 'Accept: application/json' \
    --header 'Authorization: Bearer YOUR_TOKEN' \
    --header 'Content-Type: application/json' \
    --data \



{

  # Query to fetch requested Agent Session attributes between the given epoch time in from and to.

  # from and to are mandatory paramaters.

  # Note - response is paginated

  agentSession(from: 1644859375000, to: 1671038575000) {

    agentSessions {

      # Fields can be of different types - Boolean, String, Long, Int, List or Objects, refer schema to check available fields and corresponding data types.

      agentSessionId # String

      agentId

      teamId

      siteId

      startTime # Long

      endTime

      isActive # Boolean

      channelInfo {

        # List of Objects

        channelId

        channelType

channelType # Scalar field

totalDuration

connectedDuration

        ringingCount

        ringingDuration

        idleCount

        idleDuration

      }

    }

    pageInfo {

      # Indicates if the nextPage exists or not

      hasNextPage

      # String value which can be passed to fetch the next page.

      endCursor

    }

  }}

MHirschmann
Level 1
Level 1

We at 2Ring, a Cisco Select Developer Partner, has been active in the field of services for contact centers and IP telephony since 2001 we can provide a complete solution to make this integration as smooth as possible. 

In a nutshell.

We offer the following:

  • Data Loader mechanism and its following updates, to keep up with API changes on the CCaaS side (WebexCC in your case).
  • A set of initial PowerBI reports (report definitions)
  • New PowerBI report definitions as they become available
  • Solution support, consultations with the setup of the Fabric/Azure resources.

Reach out to me of you need me to provide you more context as there is more then just this ;-). 

Regards,

Marco