CData Python Connector for SuiteCRM

Build 22.0.8462

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 provider 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 ('example@email.com')

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462