NMCSingleSends

Create, update, delete, and query the available New Marketing Campaign Single Sends in SendGrid.

テーブル固有の情報

NMC は、New Marketing Campaign の略です。

このテーブルはId によるフィルタのみをサポートしています。唯一可能なSELECT クエリは次のとおりです。

SELECT * FROM NMCSingleSends
SELECT * FROM NMCSingleSends WHERE Id = '148825'

挿入には、次のカラムが必須です：Name。

INSERT INTO NMCSingleSends (Name) VALUES ('SingleSend Name')

Id を指定してNMCSingleSends を更新することができます。

UPDATE NMCSingleSends SET Name = 'SingleSend Updated' WHERE Id = 1310789

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

DELETE FROM NMCSingleSends WHERE Id = 1310789


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id of the single send.
Name	String	False		The name of the single send.
Status	String	False		The status of the single send.
CreatedAt	String	True		The created timestamp of the single send.
UpdatedAt	String	True		The updated timestamp of the single send.
IsABTest	Boolean	False		Indicator showing if the single send is an AB Test.
SenderId	Integer	False		The ID of the verified sender identity.
CustomUnsubscribeUrl	String	False		The URL allowing contacts to unsubscribe.
SuppressionGroupId	Integer	False		The ID of the suppression group to allow customers to unsubscribe.
SendAt	Datetime	False		The ISO 8601 time at which to send the single send.
TemplateId	String	False		Id of the template used.
IpPool	String	False		The name of the IP pool from which the single send emails appear to be sent.