Overview
Configuration is provided for establishing connections with the GoToWebinar service. The configuration is used in the REST Connection Manager.
Setup
Press 
icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Demonstration
Configuration
Base URL address: https://api.getgo.com/G2W/rest/v2.
- OAuth
-
The authentication uses an authorized token. The token will be refreshed with the following expression:
{{=Date.now() + (response.expires_in - 300) * 1000}}.The authentication has the following user-defined parameters:
- client_id: Required. Identifier of application that is associated with the authentication token.
- client_secret: Required. Specify application client secret.
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
For further information, please check here.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- Key
Data type: DT_UI8
- WebinarT
Field components:
-
Uses template:
Key. - Contains the following components: webinarKey, webinarID, subject, description, times, timeZone, organizerKey, registrationUrl, impromptu, isPasswordProtected, type, impromptu, isPasswordProtected.
-
Uses template:
- AttendeeT
Field components:
-
Uses template:
Key. - Contains the following components: registrantKey, firstName, lastName, email, attendanceTimeInSeconds, sessionKey, attendance.
-
Uses template:
- SessionT
Field components:
-
Uses template:
Key. - Contains the following components: sessionKey, startTime, registrantsAttended, webinarKey, webinarID, endTime.
-
Uses template:
- CoorganizerT
Field components:
-
Uses template:
Key. - Contains the following components: memberKey, joinLink, email, external, surname, givenName.
-
Uses template:
- PanelistT
Field components:
-
Uses template:
ShortText. - Contains the following components: panelistId, joinLink, lastName, email, name, firstName.
-
Uses template:
- RegistrantT
Field components:
-
Uses template:
Key. - Contains the following components: registrantKey, lastName, email, firstName, registrationDate, status, joinUrl, timeZone.
-
Uses template:
- QuestionT
Field components:
-
Uses template:
ShortText. - Contains the following components: answers, question, askedBy.
-
Uses template:
- SurveyT
Field components:
-
Uses template:
ShortText. - Contains the following components: responses, question, numberOfResponses.
-
Uses template:
- PrivateInfoT
Field components:
-
Uses template:
ShortText. - Contains the following components: attendee, organizer, panelist.
-
Uses template:
- AttendanceStatistics
Field components:
- Contains the following components: registrantCount, percentageAttendance, averageInterestRating, averageAttentiveness, averageAttendanceTimeSeconds.
- PollsAndSurveysStatistics
Field components:
- Contains the following components: pollCount, surveyCount, questionsAsked, percentagePollsCompleted, percentageSurveysCompleted.
- [Read] action
-
The result is paginated.The following request parameters will be automatically processed:
-
page:
{{=parameters.iterator}} -
size :
{{=parameters.batchSize}} -
_includeUserParameters:
{{=parameters}}
-
page:
- [Create] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=item}}
-
_includeUserParameters:
- [Update] action
-
The action uses PUT method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=item}}
-
_includeUserParameters:
- [Delete] action
-
The action uses DELETE method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
_includeUserParameters:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/webinars.The action has the following user-defined parameters:
- fromTime: Required. Specify start of the datetime range.
- toTime: Required. Specify end of the datetime range.
For further information check here.
- [Read insession] action
-
Endpoint URL address:
/insessionWebinars.The action has the following user-defined parameters:
- toTime: Required. Specify end of the datetime range.
For further information check here.
- [Create] action
-
Endpoint URL address:
/webinars.For further information check here.
- [Update] action
-
Endpoint URL address:
/webinars/{{=item.webinarKey}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/webinars/{{=item.webinarKey}}.For further information check here.
The resource includes the fields from the WebinarT template.
- numberOfRegistrants
Data type: DT_I4
- inSession
Data type: DT_BOOL
- attendees
A read-only field. The value is gathered from
/organizers/{{=item.organizerKey}}/webinars/{{=item.webinarKey}}/attendeesaddress. The gathered value is processed with{{=response._embedded.attendeeParticipationResponses}}expression. Field components:- An array.
-
Uses template:
AttendeeT.
- audio
The value is gathered from
/organizers/{{=item.organizerKey}}/webinars/{{=item.webinarKey}}/audioaddress. The value is sent to/organizers/{{=item.organizerKey}}/webinars/{{=item.webinarKey}}/audioaddress. Field components:-
Uses template:
ShortText. - Contains the following components: type, confCallNumbers, privateInfo.
-
Uses template:
- performance
A read-only field. The value is gathered from
/organizers/{{=item.organizerKey}}/webinars/{{=item.webinarKey}}/performanceaddress. The gathered value is processed with{{=_.map(response, function(v, k) { return _.extend({ property: k }, v); })}}expression. Field components:- An array.
- Contains the following components: property, attendance, pollsAndSurveys.
- sessions
A read-only field. The gathered value is processed with
{{=connection.resourceManager['Session'].getData({ endpoint: 'webinar', parameters: ['webinarKey=' + item.webinarKey] })}}expression. Field components:- An array.
-
Uses template:
SessionT.
- coorganizers
A read-only field. The value is gathered from
/organizers/{{=item.organizerKey}}/webinars/{{=item.webinarKey}}/coorganizersaddress. Field components:- An array.
-
Uses template:
CoorganizerT.
- panelists
A read-only field. The value is gathered from
/organizers/{{=item.organizerKey}}/webinars/{{=item.webinarKey}}/panelistsaddress. Field components:- An array.
-
Uses template:
PanelistT.
- registrants
A read-only field. The value is gathered from
/organizers/{{=item.organizerKey}}/webinars/{{=item.webinarKey}}/registrantsaddress. Field components:- An array.
-
Uses template:
RegistrantT.
- meetingtimes
The value is gathered from
/organizers/{{=item.organizerKey}}/webinars/{{=item.webinarKey}}/meetingtimesaddress. Field components:- An array.
- Contains the following components: startTime, endTime.
- [Read] action
-
Endpoint URL address:
/accounts/{{=connection.token.accountKey}}/webinars.
The result is extracted from:{{=response._embedded.webinars}}.
The result is paginated.The action has the following user-defined parameters:
- fromTime: Required. Specify start time.
- toTime: Required. Specify end time.
The following request parameters will be automatically processed:
-
page:
{{=parameters.iterator}} -
size :
{{=parameters.batchSize}} -
_includeUserParameters:
{{=parameters}}
For further information check here.
The resource includes the fields from the WebinarT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/sessions.The action has the following user-defined parameters:
- fromTime: Required. Specify start time.
- toTime: Required. Specify end time.
For further information check here.
- [Read webinar] action
-
Endpoint URL address:
/webinars/{{=parameters.webinarKey}}/sessions.The action has the following user-defined parameters:
- webinarKey: Required. Specify webinar key.
For further information check here.
The resource includes the fields from the SessionT template.
- performance
The value is gathered from
/webinars/{{=item.webinarKey}}/sessions/{{=item.sessionKey}}/performanceaddress. Field components:-
Uses template:
AttendanceStatistics. - Contains the following components: attendance, pollsAndSurveys.
-
Uses template:
- polls
The value is gathered from
/webinars/{{=item.webinarKey}}/sessions/{{=item.sessionKey}}/pollsaddress. Field components:- An array.
-
Uses template:
SurveyT.
- questions
The value is gathered from
/webinars/{{=item.webinarKey}}/sessions/{{=item.sessionKey}}/questionsaddress. Field components:- An array.
-
Uses template:
QuestionT.
- surveys
The value is gathered from
/webinars/{{=item.webinarKey}}/sessions/{{=item.sessionKey}}/surveysaddress. Field components:- An array.
-
Uses template:
SurveyT.
- attendees
The value is gathered from
/webinars/{{=item.webinarKey}}/sessions/{{=item.sessionKey}}/attendeesaddress. Field components:- An array.
-
Uses template:
AttendeeT.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/webinars/{{=parameters.webinarKey}}/coorganizers.The action has the following user-defined parameters:
- webinarKey: Required. Specify webinar identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/webinars/{{=item.webinarKey}}/coorganizers.For further information check here.
- [Delete] action
-
Endpoint URL address:
/webinars/{{=item.webinarKey}}/coorganizers/{{=item.memberKey}}.For further information check here.
The resource includes the fields from the CoorganizerT template.
- webinarKey
Template: Key.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/webinars/{{=parameters.webinarKey}}/panelists.The action has the following user-defined parameters:
- webinarKey: Required. Specify webinar identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/webinars/{{=item.webinarKey}}/panelists.For further information check here.
- [Delete] action
-
Endpoint URL address:
/webinars/{{=item.webinarKey}}/panelists/{{=item.panelistId}}.For further information check here.
The resource includes the fields from the PanelistT template.
- webinarKey
Template: Key.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/webinars/{{=parameters.webinarKey}}/registrants.The action has the following user-defined parameters:
- webinarKey: Required. Specify webinar identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/webinars/{{=item.webinarKey}}/registrants.For further information check here.
- [Delete] action
-
Endpoint URL address:
/webinars/{{=item.webinarKey}}/registrants/{{=item.registrantKey}}.For further information check here.
The resource includes the fields from the RegistrantT template.
- webinarKey
Template: Key.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/webinars/{{=parameters.webinarKey}}/sessions/{{=parameters.sessionKey}}/attendees.The action has the following user-defined parameters:
- webinarKey: Required. Specify webinar identifier.
- sessionKey: Required. Specify session identifier.
For further information check here.
The resource includes the fields from the AttendeeT template.
- polls
The value is gathered from
/webinars/{{=parameters.webinarKey}}/sessions/{{=parameters.sessionKey}}/attendees/{{=item.registrantKey}}/pollsaddress. Field components:- An array.
- Contains the following components: answer, question.
- questions
The value is gathered from
/webinars/{{=parameters.webinarKey}}/sessions/{{=parameters.sessionKey}}/attendees/{{=item.registrantKey}}/questionsaddress. Field components:- An array.
-
Uses template:
QuestionT.
- surveys
The value is gathered from
/webinars/{{=parameters.webinarKey}}/sessions/{{=parameters.sessionKey}}/attendees/{{=item.registrantKey}}/surveysaddress. Field components:- An array.
- Contains the following components: answer, question.
- [Read] action
-
Endpoint URL address:
/recordingassets/search.
The result is extracted from:{{=response._embedded.recordingAssets}}.
The action uses POST method.
The result is paginated.The action has the following user-defined parameters:
- accountKey: Required. Specify account key.
The following request parameters will be automatically processed:
-
page:
{{=parameters.iterator}} -
size :
{{=parameters.batchSize}} -
application/json:
{{=parameters}}
For further information check here.
- name
Template: ShortText.
- recordingAssetKey
Template: ShortText.
- productName
Template: ShortText.
- createTime
Template: DateTime.
- creatorKey
Template: ShortText.
- accountKey
Template: ShortText.
- totalReferenceCount
Data type: DT_I4
- [Read] action
-
Endpoint URL address:
/webhooks.
The result is extracted from:{{=response._embedded.webhooks}}.The following request parameters will be automatically processed:
-
product:
g2w
For further information check here.
-
product:
- [Create] action
-
Endpoint URL address:
/webhooks.For further information check here.
- [Update] action
-
Endpoint URL address:
/webhooks.The following request parameters will be automatically processed:
-
application/json:
{{=_.extend({ webhookKey: item.webhookKey }, item)}}
For further information check here.
-
application/json:
- [Delete] action
-
Endpoint URL address:
/webhooks.The following request parameters will be automatically processed:
-
application/json:
{{=_.pluck(batch, 'webhookKey')}}
For further information check here.
-
application/json:
- webhookKey
A key field. Template: ShortText.
- callbackUrl
Template: ShortText.
- eventName
Template: ShortText.
- eventVersion
Template: ShortText.
- product
Template: ShortText.
- state
Template: ShortText. A read-only field.
- createTime
Template: DateTime. A read-only field.
- [Read] action
-
Endpoint URL address:
/userSubscriptions.
The result is extracted from:{{=response._embedded.userSubscriptions}}.For further information check here.
- [Create] action
-
Endpoint URL address:
/userSubscriptions.For further information check here.
- [Update] action
-
Endpoint URL address:
/userSubscriptions.The following request parameters will be automatically processed:
-
application/json:
{{=_.extend({ userSubscriptionKey: item.userSubscriptionKey }, item)}}
For further information check here.
-
application/json:
- [Delete] action
-
Endpoint URL address:
/userSubscriptions.The following request parameters will be automatically processed:
-
application/json:
{{=_.pluck(batch, 'userSubscriptionKey')}}
For further information check here.
-
application/json:
- userSubscriptionKey
A key field. Template: ShortText.
- callbackUrl
Template: ShortText.
- eventName
Template: ShortText. A read-only field.
- eventVersion
Template: ShortText. A read-only field.
- product
Template: ShortText. A read-only field.
- webhookKey
Template: ShortText.
- userSubscriptionState
Template: ShortText.
- activationState
Template: ShortText. A read-only field.
- createTime
Template: DateTime. A read-only field.
What's New
- New: Introduced parameters for specifying client id/secret during the authentication token generation.
- New: Support for RFC 6749 compliant OAuth2 authentication.
- New: Updated to GoToWebinar 2.0 REST API.
- Fixed: Endless pagination.
- Fixed: Failed to process key fields (Thank you, Brian).
- New: Introduced connection.
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.