InboundEmail
Create, update, delete, and query SuiteCRM inbound emails
テーブル固有の情報
Select
WHERE 句で任意の条件を使用して、Inbound Email テーブルをクエリできます。本製品 はSuiteCRM API を使用して結果をフィルタリングします。
SELECT * FROM [Inbound Email] WHERE [Monitored Folders] LIKE '%MANAGEMENT%'
Insert
書き込み可能なカラムを指定して、Inbound Email を作成します。
INSERT INTO [Inbound Email] (Name, [Group Folder Id]) VALUES ('Fast replies', 'groupId123')
Update
Id を指定して、書き込み可能なInbound Email カラムを更新できます。
UPDATE [Inbound Email] SET [Auto-Reply Template] = 'emailTemplateId2' WHERE Id = 'Test123'
Delete
Id を指定して、Inbound Email を削除します。
DELETE FROM [Inbound Email] WHERE Id = '10003'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
The unique identifier of the inbound email. |
| Auto-ReplyTemplate | String | False |
The inbound email's auto-reply template |
| CreatedById | String | True |
The Id of the user who created the record. |
| CreatedByName | String | True |
The name of the user who created the record. |
| DateCreated | Datetime | True |
The date the record was created. |
| DateModified | Datetime | True |
The date the record was last modified. |
| DeleteReadEmailsAfterImport | Bool | False |
Whether the emails are deleted after an import |
| Deleted | Bool | False |
The record deletion indicator. |
| GroupFolderId | String | False |
Id of the group's folder linked to the email |
| LBL_GROUP_ID | String | False |
Group Id linked to the email |
| LBL_SERVICE | String | False |
Service type of the inbound email |
| LBL_STORED_OPTIONS | String | False |
Stored options of the inbound email |
| MailServerAddress | String | False |
URL of the mail server to retrieve inbound emails from |
| MailServerProtocol | Int | False |
Mail protocol of the mail server |
| ModifiedById | String | True |
The Id of the user who last modified the record. |
| ModifiedByName | String | True |
The name of the user who last modified the record. |
| MonitoredFolders | String | False |
Folders monitored from the mail server |
| Name | String | False |
name of the inbound email |
| Password | String | False |
Authentication password required to access the mail server |
| Personal | Bool | False |
Whether the inbound email is personal |
| PossibleActions | String | False |
The mail server's mailbox type |
| Status | String | False |
Status of the inbound email |
| UserName | String | False |
SMTP Username to connect to the mail server |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |