NMCSingleSends

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

テーブル固有の情報

NMC は、New Marketing Campaign の略です。

Select

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

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

Insert

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

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

Update

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

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

Delete

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

DELETE FROM NMCSingleSends WHERE Id = 1310789

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The Id of the single send.
Name	String	False		The name of the single send.
Categories	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.
SendAt	Datetime	False		The ISO 8601 time at which to send the single send.
EmailConfigCustomUnsubscribeUrl	String	False		The URL allowing recipients to unsubscribe.
EmailConfigEditor	String	False		The editor, design or code, used to modify the Single Send's design in the Marketing Campaigns application user interface. This is populated only when Id is specified.
EmailConfigGeneratePlainContent	Boolean	False		If this property is set to true, plain_content is always generated from html_content. If it's set to false, plain_content is not altered. This is populated only when Id is specified.
EmailConfigHtmlContent	String	False		The HTML content of the Single Send. This property is not used when a design_id value is set. This is populated only when Id is specified.
EmailConfigIpPool	String	False		The name of the IP Pool from which the Single Send emails are sent. This is populated only when Id is specified.
EmailConfigPlainContent	String	False		The plain text content of the Single Send. This is populated only when Id is specified.
EmailConfigSenderId	Integer	False		The ID of the verified sender from whom the Single Send will be sent. This is populated only when Id is specified.
EmailConfigSubject	String	False		The subject line of the Single Send. This is populated only when Id is specified.
EmailConfigSuppressionGroupId	Integer	False		The ID of the Suppression Group to allow recipients to unsubscribe. This is populated only when Id is specified.
SendToListIds	String	False		The IDs of each contact list to which the Single Send will be sent. This is populated only when Id is specified.
SendToSegmentIds	String	False		The IDs of each segment to which the Single Send will be sent. This is populated only when Id is specified.
SendToAll	Boolean	False		If this property is set to true, the Single Send will be sent to all of your contacts. This is populated only when Id is specified.