JDBC Driver for SendGrid

Build 22.0.8462

NMCSingleSends

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

Table-Specific Information

NMC stands for New Marketing Campaign.

Select

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

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

Insert

The following columns are required in an insert: Name.

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

Update

You can update NMCSingleSends by specifying an Id.

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

Delete

You can only delete from NMCSingleSends by specifying an Id.

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.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462