Hi everyone!! I'm a newbie and I've been working my best experimenting and researching this site and the web trying to find my answers but this question has me stuck and before I call Cisco I thought I'd pose it with this group....
I'm going to be using Informatica with a Java transformation to retrieve training history to store into a data warehouse. I've been able to find part of the data I need for the users with the LsttrainingsessionHistory, LsttrainingattendeeHistory and LstsummaryTrainingSession. Unfortunately I've got a number of other data elements I can't retrieve and I suspect they are either from a call I don't have authority to do or aren't things I can pull via an API
First off: the user account I'm using is an adminRO account
I've tried to do the GetTrainingSession API call after I've retrieved a sessionID for a training session I'm trying to pull back BUT I get the following error when I try to do this call. From what I've read in the XML API guide it looks like an admin account can't do a getTrainingSession (?) though I find that odd since I'd think an admin should be able to do basically anything (at least that is my experience as admin on other systems). Is there some other level of access I need added to my account to allow me to get training (and meeting, event, support) history for all sessions at my organization?
<?xml version="1.0" encoding="ISO-8859-1"?>
<serv:message xmlns:serv="http://www.webex.com/schemas/2002/06/service" xmlns:com="http://www.webex.com/schemas/2002/06/common" xmlns:sess="http://www.webex.com/schemas/2002/06/service/session" xmlns:train="http://www.webex.com/schemas/2002/06/service/trainingsession" xmlns:qti="http://www.webex.com/schemas/2002/06/service/trainingsessionqti" xmlns:qtiasi="http://www.webex.com/schemas/2002/06/service/trainingsessionqtiasi">
<serv:reason>Access denied, additional privileges are required</serv:reason>
These are the data elements I'm trying to retrieve but haven't been able to find up to this point:
*Attention to Duration Ratio
*Attention to Attendance ratio
Confirm Email Address
I believe these are either custom fields OR from either surveys or registration forms that participants fill out. I've no real idea yet on where to go for these data elements.
What type of library do you work in
What are your job responsibilities
How did you find out about the training
Would you like to receive training announcement emails
Why did you sign up for the training? (Check all that apply)
Any help will be greatly appreciated!! I look forward to working on this new challenge of pulling this data
GetTrainingSession can be called by self only, no site admin level will be able to retrieve data unless they are the session owner. For all Get/Lst commands, read-only site admin will have the same permissions as full site admin. API history data does not include attention percentage or duration. The XML API reference guide contains schema diagrams for all requests and responses that will detail all available attributes returned. Address details are returned by LsttrainingattendeeHistory when entered by the attendee, but custom fields are not available via API report.
Are there any alternatives to the XML API to get the data like attention percentage & duration, custom fields and registration form q&a? I'm fine with writing some Java code for my Informatica mapping to be able to get the information.
Besides API, the only other report retrieval tools are in Site Admin and in My WebEx. Your WebEx account manager can explain available details for site and personal reports. The values you are looking for are not currently available by API.
please share any example for this report with xml api
The XML API reference guide contains example request and response for every available command, including GetTrainingSession: https://developer.cisco.com/media/webex-xml-api/613GetTrainingSession.html. Usage reports are available using LsttrainingsessionHistory and LsttrainingattendeeHistory, both part of the history service.