JDBC Driver for Salesforce Marketing Cloud

Build 22.0.8462

Subscriptions

Create, update, delete and query event notification subscriptions.

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 =

The Id of the event notification subscription.

SubscriptionName String False

The name of the event notification subscription.

CallbackId String False

Callbacks.CallbackId

=

The Id of the event notification callback.

CallbackName String False

The name of the event notification callback.

EventCategoryTypes String False

Event category types.

Filters String False

Filters.

Url String False

The url of the event notification callback.

MaxBatchSize Integer False

Maximum batch size of the event notification callback.

Status String False

The status of the event notification callback.

StatusReason String False

The status reason of the event notification callback.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462