TDV Adapter for SendGrid

Build 22.0.8462

UnsubscribeGroups

Create, update, delete, and query Unsubscribe Groups in SendGrid.

Table-Specific Information

Select

UnsubscribeGroups can only be filtered by Id.

SELECT * FROM UnsubscribeGroups WHERE Id = '1'

Insert

Provide a Name and a Description to insert into UnsubscribeGroups:

INSERT INTO UnsubscribeGroups(Name, Description, IsDefault) VALUES ('Unsubscribe1', 'General Unsubscribe', true)

Update

You can only update UnsubscribeGroups by specifying an Id.

Update UnsubscribeGroups SET Name = 'New Name', Description = 'New Description' WHERE Id = '1'

Delete

You can only delete from UnsubscribeGroups by specifying an Id.

DELETE FROM UnsubscribeGroups WHERE Id = '1'

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

Id of the unsubscribe group.

Name String False

The name of the unsubscribe group.

Description String False

The description of the unsubscribe group.

LastEmailSentAt Datetime True

The last time an email was sent to the unsubscribe group.

IsDefault Boolean False

If the unsubscribe group is the default group or not.

Unsubscribes Integer True

The number of unsubscribes from this group.

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