SSIS Components for Oracle Service Cloud

Build 24.0.9060

MessageBases

The editable text string that allows international language support and customization of headings, labels, buttons, and other text in the administration interface and customer portal. It also applies to email messages and notifications.

Table-Specific Information

SELECT

The component will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the component.

SELECT * FROM MessageBases WHERE id = 12
SELECT * FROM MessageBases WHERE id > 15
SELECT * FROM MessageBases WHERE lookUpName LIKE '%test'
SELECT * FROM MessageBases WHERE id IN (12, 23, 123)
SELECT * FROM MessageBases WHERE lookUpName IS NOT NULL

Columns

Name Type Description
CreatedTime Datetime The date and time when the message base was created. This attribute is read-only.
Id [KEY] Long The unique identifier of the message base.
LookupName String The name used to look up the message base.
Name String The name of the message base.
UpdatedTime Datetime The date and time when the message base was last updated. This attribute is read-only.
UsageId Long Id of usage. The type of data the message base represents.
UsagelookUpName String LookUpName of usage. The type of data the message base represents.
Value String The string value of the message base.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060