EmailAddress
Create, update, delete, and query email addresses saved in SuiteCRM
Table Specific Information
Select
You can query the Email Address table using any criteria in the WHERE clause. The add-in will use the SuiteCRM API to filter the results.
SELECT * FROM [Email Address] WHERE [Invalid Email] = True
Insert
Create an Email Address by specifying any writable column.
INSERT INTO [Email Address] ([Email address]) VALUES ('[email protected]')
Update
You can update any Email Address column that is writable, by specifying the Id.
UPDATE [Email Address] SET [Opted out] = True WHERE Id = 'Test123'
Delete
Delete an Email Address by specifying the Id.
DELETE FROM [Email Address] WHERE Id = '10003'
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The unique identifier of the email address. |
| DateCreate | Datetime | True |
The date the email address was created. |
| DateModified | Datetime | True |
The date the email address was last modified. |
| Delete | Bool | False |
Whether the email address is deleted. |
| EmailAddress | String | False |
The email address. |
| EmailAddresscaps | String | False |
The email address in uppercase. |
| InvalidEmail | Bool | False |
Whether the email address is marked as invalid. |
| OptedOut | Bool | False |
Whether the email address is marked as opt out. |
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. |