JDBC Driver for Oracle Service Cloud

Build 22.0.8462

ContactsEmails

The email address and its associated information.

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 ContactsEmails WHERE contactsId = 12
SELECT * FROM ContactsEmails WHERE contactsId > 15
SELECT * FROM ContactsEmails WHERE certificate LIKE '%test'
SELECT * FROM ContactsEmails WHERE contactsId IN (12,23,123)
SELECT * FROM ContactsEmails WHERE certificate IS NOT NULL

Columns

Name Type Description
ContactsId Long The unique identifier of the contact.
Address String The string value of the email address.
AddressTypeId Long Id of addressType. The type of address, such as Primary or Alt1. This is the key for the list entry.
AddressTypelookUpName String LookUpName of addressType. The type of address, such as Primary or Alt1. This is the key for the list entry.
Certificate String The associated public email certificate used to encrypt outgoing emails.
Invalid Bool Indicates whether the email address is disabled.

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