08-21-2024 08:35 AM - last edited on 08-21-2024 10:29 AM by shazubai
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!
08-21-2024 10:41 AM
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
08-21-2024 12:40 PM
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?
08-21-2024 05:04 PM
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
08-22-2024 08:00 AM
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
08-22-2024 08:04 AM
Can you give me some examples of what can I use to fetch that information to put it in our DB?
08-22-2024 08:03 AM
When you say your developers do you mean the webex developers assigned to us?
08-22-2024 08:13 AM
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.
08-22-2024 06:23 PM
You would either need your internal staff to do this, or go to a Cisco partner who can do it for you.
09-04-2024 09:28 AM
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
}
}}
09-05-2024 12:47 AM
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:
Reach out to me of you need me to provide you more context as there is more then just this ;-).
Regards,
Marco
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide