BizTalk Adapter for SendGrid

Build 20.0.7587

UnsubscribeGroups

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

テーブル固有の情報

Select

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

SELECT * FROM UnsubscribeGroups WHERE Id = '1'

Insert

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

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

Update

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

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

Delete

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

DELETE FROM UnsubscribeGroups WHERE Id = '1'

Columns

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.7587