Represents a send classification in a Marketing Cloud account.

Table-Specific Information

Select

The provider 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 provider processes other filters client-side within the provider.

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