NMCSingleSends

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

Table-Specific Information

NMC stands for New Marketing Campaign.

This table only supports filtering by Id. The following are the only possible SELECT queries:

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

The following columns are required in an insert: Name.

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

You can update NMCSingleSends by specifying an Id.

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

You can only delete from NMCSingleSends by specifying an Id.

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.