SendClassification
Represents send classifications in Salesforce Marketing Cloud. A send classification defines the delivery parameters for a message, including CAN-SPAM classification (commercial and transactional or relationship messages), sender profile, and delivery profile. This table helps enforce consistent email compliance and brand policies.
Table-Specific Information
Select
The connector 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 connector processes other filters client-side within the connector.
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 |
Specifies the system-controlled identifier (Id) that is assigned to the send classification object. This value is used to reference the object in system workflows and API operations. |
| SendClassificationType | String | False |
Specifies the type that is associated with the send classification. Valid values include 'Operational', which bypasses subscription checks, and 'Marketing', which adheres to subscriber preferences. |
| Name | String | False |
Specifies the name that is assigned to the send classification. This value provides a human-readable label for administrative and API use. |
| Description | String | False |
Provides descriptive information that explains the purpose or configuration of the send classification. This information supports administrative oversight and auditing. |
| CustomerKey | String | False |
Specifies the user-supplied unique Id that is associated with the send classification within its object type. This value is required for external references and API operations. |
| SenderProfile_CustomerKey | String | False |
Specifies the customer key that is associated with the sender profile that is used for 'From Name', 'From Address', and related delivery metadata. |
| SenderProfile_ObjectID | String | False |
Specifies the system-controlled object Id that is assigned to the sender profile that is linked to this send classification. |
| DeliveryProfile_CustomerKey | String | False |
Specifies the customer key that is associated with the delivery profile that defines IP configuration, domain details, and delivery routing rules. |
| DeliveryProfile_ObjectID | String | False |
Specifies the system-controlled object Id that is assigned to the delivery profile that is linked to this send classification. |
| ArchiveEmail | Bool | False |
Returns a value of 'true' when the send classification is configured to archive email messages for compliance or auditing. It returns a value of 'false' when archiving is not applied. |
| Client_ID | Long | False |
Specifies the Id of the client that owns or administers the send classification. |
| Client_PartnerClientKey | String | False |
Specifies the partner-defined client key that is associated with the account and accessible through API integrations. |
| PartnerKey | String | False |
Specifies the unique partner-supplied key that is associated with the send classification and available only through API operations. |
| CreatedDate | Datetime | False |
Specifies the date and time when the send classification object was created. This value is system-generated and read-only. |
| ModifiedDate | Datetime | False |
Indicates the date and time when the send classification object was last modified. This value reflects administrative or automated system updates. |