JDBC Driver for Oracle Service Cloud

Build 22.0.8462

ContactMarketingRosters

The information about the contact lists used in audiences in Oracle Service Cloud Outreach Cloud Service.

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

INSERT

Insert can be executed by specifying the isProofList and name columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO ContactMarketingRosters (isProofList,name) VALUES ('true','Incident extract limit')

UPDATE

Update can be executed. The columns that are not read-only can be Updated. For example:

UPDATE ContactMarketingRosters SET Comment = 'Incident extract limit' WHERE Name = 'Analytics Lab Attendees'

DELETE

Following is an example of how to Delete a record in this table. For example:

DELETE FROM ContactMarketingRosters WHERE Name = 'Analytics Lab Attendees'

Columns

Name Type ReadOnly Description
Comment String False

The description associated with the contact marketing roster.

CreatedByAccountId Long True

Id of createdByAccount. The staff account who created the list.

CreatedByAccountlookUpName String True

LookUpName of createdByAccount. The staff account who created the list.

CreatedTime Datetime True

The date and time when the contact marketing roster was created. This attribute is read-only.

Id [KEY] Long True

The unique identifier of the contact marketing roster.

InterfaceId Long True

Id of interface. The interface the list is associated with.

InterfacelookUpName String True

LookUpName of interface. The interface the list is associated with.

IsProofList Bool False

Indicates whether the contact marketing roster is a proof list.

LookupName String True

The name used to look up the contact marketing roster.

Name String False

The name of the contact marketing roster.

PurgeData Bool False

Indicates whether the contact marketing roster should be cleared periodically. The default value is false.

UpdatedByAccountId Long True

Id of updatedByAccount. The staff account who last updated the list.

UpdatedByAccountlookUpName String True

LookUpName of updatedByAccount. The staff account who last updated the list.

UpdatedTime Datetime True

The date and time when the contact marketing roster was last updated. This attribute is read-only.

LastCountStatisticslastCount Int True

The number of contacts in the contact marketing roster when the count was last calculated.

LastCountStatisticslastCountedTime Datetime True

The date and time when the contact marketing roster was last counted.

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