CData Excel Add-In for SendGrid 2019J - Online Help

SenderIdentities

CData Excel Add-In for SendGrid 2019J - Build 19.0.7354

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

テーブル固有の情報

Select

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

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

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

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

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

Delete

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

Delete FROM SenderIdentities WHERE Id=1310789

Columns

Name Type ReadOnly 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) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0