JDBC Driver for SendGrid

Build 22.0.8462

SenderIdentities

Create, update, delete, and query Sender Identities in SendGrid.

Table-Specific Information

Select

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

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

Insert

The following columns are required in an insert: Nickname, FromEmail, FromName,ReplytoEmail, Address, City, Country.

INSERT INTO SenderIdentities (Nickname, FromEmail, FromName,ReplytoEmail, Address, City, Country) VALUES ('Nickname','FromEmail','FromName','ReplytoEmail','Address','City','Country')

Update

You can update SenderIdentities by specifying an Id.

Update SenderIdentities SET Nickname='Nickname', FromEmail='FromEmail', FromName='FromName', ReplytoEmail='ReplytoEmail', Address='Address', City='City', Country='Country'  WHERE Id=1310789

Delete

You can only delete from Alerts by specifying an Id.

Delete FROM SenderIdentities WHERE Id=1310789

Columns

Name Type ReadOnly References Description
Id [KEY] Integer False

The unique identifier of the sender identity.

Nickname String False

A nickname for the sender identity. Not used for sending..

FromEmail String False

This is where the email will appear to originate from for your recipient.

FromName String False

This is the name appended to the from email field. IE - Your name or company name.

ReplytoEmail String False

This is the email that your recipient will reply to.

ReplytoName String False

This is the name appended to the reply to email field. IE - Your name or company name.

Address String False

The physical address of the sender identity.

Address2 String False

Additional sender identity address information.

City String False

The city of the sender identity.

State String False

The state of the sender identity.

Zip String False

The zipcode of the sender identity.

Country String False

The country of the sender identity.

CreatedAt Datetime True

The end of the time range when the bounce was created.

UpdatedAt Datetime True

The end of the time range when the bounce was created.

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