Products | Versions |
---|---|
TIBCO Cloud Integration - Connect ( Scribe ) | 1.0.1.5056 |
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
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:
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.
If using a different Lookup Table name, substitute your Lookup Table name in the formula for “Cvent_Timezones”.