JDBC Driver for Oracle Service Cloud

Build 22.0.8462

ServiceMailboxes

The email box dedicated to collect email inquiries sent by customers.

Table-Specific Information

SELECT

The driver 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 driver.

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

Columns

Name Type Description
CreatedTime Datetime The date and time when the service mailbox was created. This attribute is read-only.
Id [KEY] Long The unique identifier of the service mailbox.
InterfaceId Long Id of interface. The interface that the mailbox is associated with.
InterfacelookUpName String LookUpName of interface. The interface that the mailbox is associated with.
IsDefault Bool Indicates whether the mailbox is the default mailbox for the interface. This attribute does not have a default value.
LookupName String The name used to look up the service mailbox.
Name String The name of the service mailbox in the language of the current interface.
TypeId Long Id of type. The module the mailbox is associated with.
TypelookUpName String LookUpName of type. The module the mailbox is associated with.
UpdatedTime Datetime The date and time when the service mailbox was last updated. This attribute is read-only.
IncomingEmailSettingsforceReplyBetweenLines Bool Indicates whether the Force Reply Between the Lines feature is enabled for outgoing emails from the mailbox. This attribute does not have a default value.
IncomingEmailSettingsforwardRejectMessageAddress String The address to which rejected messages are sent.
IncomingEmailSettingsisEnabled Bool Indicates whether incoming email option is enabled. This attribute does not have a default value.
OutgoingEmailSettingsdisplayName String The display name used in the outgoing emails from the mailbox.
OutgoingEmailSettingsfriendlyFromAddress String The from address used to brand outgoing emails as friendly.
OutgoingEmailSettingsfromAddress String The from address on the outgoing email.
OutgoingEmailSettingsisEnabled Bool Indicates whether outgoing email is enabled. This attribute does not have a default value.
OutgoingEmailSettingsreplyToAddress String The reply-to-address on the outgoing email.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462