AccountsEmails

The email address and its associated information.

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

Columns


Name	Type	Description
AccountsId	Long	Id of Accounts.
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.

SSIS Components for Oracle Service Cloud

AccountsEmails

Table-Specific Information

SELECT

Columns