SenderIdentities
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 | 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. | |
| Locked | Boolean | True |
A boolean flag that is true when the Sender is associated with a campaign in Draft, Scheduled, or In Progress status. You cannot update or delete a locked Sender. | |
| VerifiedReason | String | True |
The reason for verifying the sender | |
| VerifiedStatus | Boolean | True |
A boolean flag indicating whether the Sender is verified or not. Only verified Senders can be used to send email. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AccountId | String |
The ID of the account. |
| SubuserUsername | String |
The username of the subuser. |