topic Re: WebEx XML API - Help needed with GetTrainingSession in Cloud Collaboration

WebEx XML API - Help needed with GetTrainingSession

millerca1 — Mon, 10 Mar 2014 14:43:25 GMT

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

Re: WebEx XML API - Help needed with GetTrainingSession

nmorrow — Tue, 11 Mar 2014 18:09:04 GMT

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.

Re: WebEx XML API - Help needed with GetTrainingSession

millerca1 — Tue, 11 Mar 2014 18:25:52 GMT

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

Re: WebEx XML API - Help needed with GetTrainingSession

nmorrow — Wed, 12 Mar 2014 21:13:22 GMT

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.

Re: WebEx XML API - Help needed with GetTrainingSession

erhandelibas — Wed, 24 Sep 2014 11:36:23 GMT

please share any example for this report with xml api

Re: WebEx XML API - Help needed with GetTrainingSession

nmorrow — Wed, 24 Sep 2014 17:18:17 GMT

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.