WebEx XML API - Help needed with GetTrainingSession

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:header>

  <serv:response>

  <serv:result>FAILURE</serv:result>

  <serv:reason>Access denied, additional privileges are required</serv:reason>

  <serv:gsbStatus>PRIMARY</serv:gsbStatus>

  <serv:exceptionID>000001</serv:exceptionID>

  </serv:response>

  </serv:header>

  <serv:body>

  <serv:bodyContent/>

  </serv:body>

</serv:message>

These are the data elements I'm trying to retrieve but haven't been able to find up to this point:

Product

First Name

Last Name

Registration date

*Attention to Duration Ratio

*Attention to Attendance ratio

Tele- conference

Company

Title

Phone Number

Address 1

Address 2

City

State /Province

Country/Region

Zip/Postal Code

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.

Institution Name

Country /Region

State/Province

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

Thanks,

Cat

Hello,

     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.

Nathan,

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.

Thanks,

Cat

Hello,

     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

Hello,

     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.