Subscriptions

Manages event notification subscriptions within Salesforce Marketing Cloud. A subscription defines which events are monitored and where notifications are sent. This table allows you to create, update, delete, and query event subscriptions to support custom automation and data integration processes.

Table Specific Information

Select

Select all subscriptions:

SELECT * FROM Subscriptions

Retrieve a specific subscription:

SELECT * FROM Subscriptions WHERE SubscriptionId = 94766

Insert

To create a subscription, you will need to specify at least the SubscriptionName, CallbackId and EventCategoryTypes column.

INSERT INTO [Subscriptions] (SubscriptionName, CallbackId, EventCategoryTypes) VALUES ('sajli subscription', '6fb0758b-155d-4968-869d-7a4f5a3ad2fe', '[\"TransactionalSendEvents.EmailNotSent\", \"TransactionalSendEvents.EmailSent\"]')

Update

Subscriptions may be modified by providing the SubscriptionId and the EventCategoryTypes column of the subscription and issuing an UPDATE statement.

UPDATE [Subscriptions] SET Status = 'paused', EventCategoryTypes = '[\"TransactionalSendEvents.EmailNotSent\", \"TransactionalSendEvents.EmailSent\"]' WHERE SubscriptionId = 'db1e2af0-807d-463b-96e8-fe3aaa019fdb'

Delete

Subscriptions may be deleted by providing the SubscriptionId of the subscription and issuing a DELETE statement.

DELETE FROM [Subscriptions] WHERE SubscriptionId = '43841979-7154-4fc4-9789-909dbba3a54f'

Columns


Name	Type	ReadOnly	References	Filters	Description
SubscriptionId [KEY]	String	False		=	Specifies the unique identifier (Id) of the event notification subscription. This Id links the subscription to the callback configuration that processes event notifications.
SubscriptionName	String	False			Specifies the name of the event notification subscription. This value helps identify the subscription within Salesforce Marketing Cloud and through API queries.
CallbackId	String	False	Callbacks.CallbackId	=	Specifies the Id of the event notification callback that the subscription uses to deliver event data. The callback determines where and how event notifications are sent.
CallbackName	String	False			Specifies the name of the event notification callback associated with the subscription. This value helps distinguish among multiple callbacks that can exist in the account.
EventCategoryTypes	String	False			Specifies the event category types that the subscription monitors. These types determine which Salesforce Marketing Cloud events (for example, sends, opens, clicks, or bounces) are forwarded to the callback.
Filters	String	False			Specifies the filters that limit which events are included in the subscription. Filters can restrict events by category, source, or other attributes to control which notifications are sent.
Url	String	False			Specifies the URL endpoint that receives the event notifications from the callback. The system posts event data to this address according to the subscription's configuration.
MaxBatchSize	Integer	False			Specifies the maximum number of event records that the system includes in a single callback request. This value controls batching behavior for event delivery.
Status	String	False			Specifies the operational status of the event notification callbac (for example, active, inactive, or error). This status determines whether event notifications are currently being sent.
StatusReason	String	False			Specifies the reason associated with the callback's current status. This value can include diagnostic information or system notes explaining why the callback is active, inactive, or in an error state.