Cvent Connector: Invalid Timezone Error

Cvent Connector: Invalid Timezone Error

book

Article ID: KB0078820

calendar_today

Updated On:

Products Versions
TIBCO Cloud Integration - Connect ( Scribe ) 1.0.1.5056

Description

When updating the EventStartDate and EventEndDate fields in the Event entity, the associated Timezone field must also be mapped.  Using the Event Lookup result to map the Timezone field returns the following error: 

Record Error:  Operation failed.  Label:  Update Event, Name : EventUpdate, Message: : Invalid time zone
 

Issue/Introduction

This article provides instructions for mapping the Cvent Event entity Timezone field.

Resolution

The Cvent API returns the Timezone "name" value.  To successfully update the Event, the Cvent API expects the Timezone "abbreviation" value. 
For example, the corresponding values for the Central Time zone are:

    Timezone_name    Timezone_abbreviation
     Central Time           CT

To find the timezone value for the Event update block, create a Lookup Table in TIBCO Scribe® Online and use the LOOKUPTABLEVALUE2 formula for the field mapping.

Note:  Mapping the Timezone field is only required when mapping the EventStartDate and EventEndDate fields.  If these 2 date fields are not needed for your Update block, you can remove the mapping for the 2 date fields and Update will process without error.

Steps:

  1. Create a Lookup Table in your TIBCO Scribe® Online Organization using the attached import file: Lookup Table_Cvent_Timezones.csv.

              See the TIBCO Scribe® Online Lookup Tables reference for instructions on how to create a Lookup Table.

                The Lookup Table is named “Cvent_Timezones” for this example.

  1. Use the following formula for the Timezone field:  LOOKUPTABLEVALUE2("Cvent_Timezones", Event.Timezone)

              If using a different Lookup Table name, substitute your Lookup Table name in the formula for “Cvent_Timezones”.

Attachments

Cvent Connector: Invalid Timezone Error get_app