CData Excel Add-In for SendGrid 2019J - Online Help


CData Excel Add-In for SendGrid 2019J - Build 19.0.7354

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



UnsubscribeGroups はId によってのみフィルタできます。

SELECT * FROM UnsubscribeGroups WHERE Id = '1'


UnsubscribeGroups に挿入するには、名前と説明を指定します。

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


Id を指定することでUnsubscribeGroups を更新できます。

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


Id を指定することでUnsubscribeGroups から削除できます。

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 19.0.7354.0