SendDefinitions

Stores send definitions in Salesforce Marketing Cloud. A send definition specifies the parameters for email, Short Message Service (SMS), or push sends, including target audiences, content, and delivery options. This table allows you to create, update, delete, and query send definitions to manage outbound communication workflows.

Table Specific Information

Select

Retrieve all send definitions:

SELECT * FROM SendDefinitions

Retrieve a specific send definition:

SELECT * FROM SendDefinitions WHERE DefinitionKey = '9955614b-02e7-4147-91a2-3f5f5fe9d679'

Retrieve all send definitions with Status as 'Active':

SELECT * FROM SendDefinitions WHERE Status = 'Active'

Insert

To create a send definition, you will need to specify at least the DefinitionKey, Name, SubscriptionsList and ContentCustomerKey column.

INSERT INTO SendDefinitions (DefinitionKey, Name, ContentCustomerKey, SubscriptionsList, OptionsCc, OptionsCreateJourney) VALUES ('TEST_Definition_Key', 'Test Definition Key', '76ad3572-abbc-4baa-b3fe-04c4364bf34a', 'All Subscribers', '[email protected]', true)

Update

To update a send definition, you will need to specify the DefinitionKey of the SendDefinition.

UPDATE SendDefinitions SET OptionsCc = '[email protected],[email protected]', OptionsBcc = '[email protected],[email protected]' WHERE DefinitionKey = 'TEST_Definition_Key'

Delete

Send definitions may be deleted by providing the Definition Key of the send definition and issuing a DELETE statement.

DELETE FROM SendDefinitions WHERE DefinitionKey = 'TEST_Definition_Key'

Columns


Name	Type	ReadOnly	References	Filters	Description
DefinitionKey [KEY]	String	False		=	Specifies the unique, user-generated key that identifies the send definition. This key is used to reference the definition programmatically and remains stable across edits.
DefinitionId	String	True			Specifies the unique identifier (Id) that Salesforce Marketing Cloud assigns to the send definition. This Id is used internally to manage, retrieve, and execute the definition.
Classification	String	False			Specifies the external key of the sending classification that is defined in Email Studio Administration. Only transactional classifications are permitted for this object. The default value is the system's transactional classification.
ContentCustomerKey	String	False			Specifies the unique key of the content asset that is associated with the send definition. This key identifies the email asset that is used when the definition executes.
CreatedDate	Datetime	True			Specifies the date and time when the send definition was created in Salesforce Marketing Cloud.
Description	String	False			Specifies the user-provided description that explains the purpose or intended use of the send definition.
Journey	Boolean	True			Specifies whether the send definition is available in Journey Builder as a transactional send journey. A value of 'true' enables the definition for journey-based triggering.
JourneyInteractionKey	String	True			Specifies the unique Id of the transactional send journey that is associated with the definition. This Id links the definition to the journey that triggers it.
ModifiedDate	Datetime	True			Specifies the date and time when the send definition was most recently modified.
Name	String	False			Specifies the name of the send definition as displayed in Email Studio and through API queries.
OptionsBcc	String	False			Specifies one or more email addresses to receive blind carbon copies (BCC) for every send. To dynamically populate BCC addresses at send time, create a profile attribute and reference it using the %%attribute%% syntax.
OptionsCc	String	False			Specifies one or more email addresses to receive carbon copies (CC) for every send. To dynamically populate CC addresses at send time, create a profile attribute and reference it using the %%attribute%% syntax.
OptionsTrackLinks	Boolean	False			Specifies whether Salesforce Marketing Cloud should wrap hyperlinks for click tracking and reporting. The default value is 'true'.
OptionsCreateJourney	Boolean	False			Specifies whether the system should create the underlying journey configuration when defining sendable schema fields such as subscriber key or email address. This setting is required only when schema information must be defined or validated.
RequestId	String	True			Specifies the unique Id of the request that performed the most recent operation on the send definition.
Status	String	False		=,!=	Specifies the operational state of the send definition (for example, active, inactive, or deleted). Messages submitted to an active definition are processed and delivered. Messages submitted to an inactive definition are not processed and are instead queued for up to three days for possible reactivation.
SubscriptionsAutoAddSubscriber	Boolean	False			Specifies whether the system should automatically add the recipient's email address and contact key to the system-managed subscriber list that stores subscriber keys and profile attributes. The default value is 'true'.
SubscriptionsDataExtension	String	False			Specifies the external key of the triggered send data extension. Each triggered request inserts a new row into this data extension with relevant message and subscriber details.
SubscriptionsList	String	False			Specifies the external key of the list or All Subscribers context in which subscriber keys and profile attributes are stored. This list is used as a repository for subscription and profile data related to the send.
SubscriptionsUpdateSubscriber	Boolean	False			Specifies whether the system should update the recipient's subscriber key with the provided email address and profile attributes in subscriptions.list. This setting applies to email messages only. The default value is 'true'.