OutboundEmailAccounts
Create, update, delete, and query the outbound email accounts table
Table Specific Information
Select
You can query the Outbound Email Accounts table using any criteria in the WHERE clause. The component will use the SuiteCRM API to filter the results.
SELECT * FROM [Outbound Email Accounts] WHERE Type = 'system'
Insert
Create an Outbound Email Account by specifying any writable column.
INSERT INTO [Outbound Email Accounts] (Name,[SMTP Username],[Mail Send Smtp Type]) VALUES ('Test email','suitecrm@gmail.com','Gmail')
Update
You can update any Outbound Email Account column that is writable, by specifying the Id.
UPDATE [Outbound Email Accounts] SET [Use SMTP Authentication?] = true WHERE Id = 'Test123'
Delete
Delete an Outbound Email Account by specifying the Id.
DELETE FROM [Outbound Email Accounts] WHERE Id = '10003'
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The unique identifier of the outbound account. |
| Assignedto | String | True |
The user name of the user assigned to the record. |
| AssignedUserId | String | False |
The Id of the user assigned to the record. |
| ChooseyourEmailprovider | String | True |
identifier for the email provider |
| 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. |
| Deleted | Bool | False |
The record deletion indicator. |
| MailSendSmptType | String | False |
SMTP Type of the connected account The allowed values are IMAP, POP3. |
| LBL_MAIL_SENDTYPE | String | False |
Type of mail intended to be sent |
| LBL_MAIL_SMTPSSL | String | False |
Secure layer protocol of the connected email account |
| 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. |
| Name | String | False |
Name assigned to the outbound account |
| Password | String | True |
Password set for the account |
| SendTestEmail | String | True |
'Send Test Email' button content |
| SMTPPassword | String | False |
Password to use in the SMTP authentication |
| SMTPPort | Int | False |
Port to use in the SMTP authentication |
| SMTPServer | String | False |
Server address to use in the SMTP authentication |
| SMTPUsername | String | False |
Username to use in the SMTP authentication |
| Type | String | False |
Outbound account type |
| UseSMTPAuthentication? | Bool | False |
Whether the account to be connected will use SMTP authentication |
| UserId | String | False |
Id of the user linked with the account |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |