SendClassification
Represents a send classification in a Marketing Cloud account.
Table-Specific Information
Select
The 本製品 uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The 本製品 processes other filters client-side within the 本製品.
For example, the following (but not only) queries are processed server side:
SELECT * FROM SendClassification WHERE ObjectID = 'nzxcaslkjd-123' SELECT * FROM SendClassification WHERE ObjectID IN ('nzxcaslkjd-123', 456) SELECT * FROM SendClassification WHERE CreatedDate > '2017/01/25'
Insert
You must specify the following fields when inserting to this table: Name, DeliveryProfile_ObjectID, and SenderProfile_ObjectID.
INSERT INTO SendClassification (Name, DeliveryProfile_ObjectID, SenderProfile_ObjectID) VALUES ('TestName', 'aa1231231', 'vvb1231231')
Delete
You must specify the ObjectID in the WHERE clause when executing a delete against this table.
DELETE FROM SendClassification WHERE ObjectID = 'nzxcaslkjd-123'
Columns
Name | Type | ReadOnly | Description |
ObjectID [KEY] | String | False |
System-controlled, text string identifier for object. |
SendClassificationType | String | False |
Defines the type for the applicable send classification. Valid values include Operational and Marketing. |
Name | String | False |
Name of the object or property. |
Description | String | False |
Describes and provides information regarding the object. |
CustomerKey | String | False |
User-supplied unique identifier for an object within an object type. |
SenderProfile_CustomerKey | String | False |
The customer key of the sender profile. |
SenderProfile_ObjectID | String | False |
System-controlled, text string identifier for object. |
DeliveryProfile_CustomerKey | String | False |
The customer key of the delivery profile. |
DeliveryProfile_ObjectID | String | False |
System-controlled, text string identifier for object. |
ArchiveEmail | Bool | False |
Property definition. |
Client_ID | Long | False |
The Id of the client. |
Client_PartnerClientKey | String | False |
User-defined partner key for an account. |
PartnerKey | String | False |
Unique identifier provided by partner for an object, accessible only via API. |
CreatedDate | Datetime | False |
Indicats the date and time of the object's creation. |
ModifiedDate | Datetime | False |
Indicates the last time object information was modified. |