SSIS Components for SendGrid

Build 20.0.7656


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

Table-Specific Information


UnsubscribeGroups can only be filtered by Id.

SELECT * FROM UnsubscribeGroups WHERE Id = '1'


Provide a Name and a Description to insert into UnsubscribeGroups:

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


You can only update UnsubscribeGroups by specifying an Id.

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


You can only delete from UnsubscribeGroups by specifying an Id.

DELETE FROM UnsubscribeGroups WHERE Id = '1'


Name Type ReadOnly 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656