Read data in Visualization with Webex API

[Googly]

We have defined several Visualizations in Analyzer and they are exported to CSV files on daily basis. Our goal is to use Webex API to read the data directly and import the data into SQL database without using CSV. I know Search function can probably do it but I couldn't find any sample code for it.

[Thomas G. Johannesen]

Maybee im confused, but what are you trying to do in the visualization.

The search API is used for extracting data to an external source (im using it for getting data out to my own MSSQL database, so i can make reports i PowerBi.)

[Googly]

Yes, that's pretty much what I am trying to do.

We have defined several Visualizations in Analyzer. Each one of them defines several profile variables like the one I attached previously. Each of the Visualization has a job to export the Visualizations to a CSV file and email us the file. We would like to automate this process by creating a .NET program that calls the search function to retrieve the data as defined by the profile variables in each Visualization. I also understand that Data Dictionaries define fields that are accessible thru search function using GraphQL. My question is that: for each of the profile variable in a Visualization, how do I know which field it maps to in the Data Dictionaries?

Thanks!

[Thomas G. Johannesen]

I dont know if this is possible to do that mapping.

The way we are doing it, is to export the raw data into a MSSQL db and then to our calculations etc there... I have made a windows service that export data every 15 min to my db.

This is for agentSessions, tasks and taskDetails. Then you have all data to do the calculations there

[Googly]

Hi Thomas,

I think that's pretty close to what I am trying to achieve. How do you define the data you want to export and how do you set it up to export every 15 minutes?

Thanks

[Thomas G. Johannesen]

Hey

You can se some sample codes herE :

https://developer.webex-cx.com/documentation/guides/getting-started-with-search-api

And

https://github.com/WebexSamples/webex-contact-center-api-samples/tree/main/reporting-samples/graphql-sample

[Googly]

Thanks for the info. But I am still not quite sure how to use the search function on the Visualization. For example, I have attached a template for one of the Visualizations we created. How do I map the fields used in the Visualization to the fields in the Data Dictionaries?