CData Python Connector for SuiteCRM

Build 22.0.8462

Targets

Query targets saved in SuiteCRM

Table Specific Information

Select

You can query the Targets table using any criteria in the WHERE clause. The provider will use the SuiteCRM API to filter the results.

SELECT * FROM Targets WHERE Title = 'Eng'

Insert

Create a Target by specifying any writable column.

INSERT INTO Targets ([First Name],[Last Name],[Any Email],[Campaign ID]) VALUES ('Test','Prospect','example@test.com','IdCamp1')

Update

You can update any Target column that is writable, by specifying the Id.

UPDATE Targets SET Department = 'Finance' WHERE Id = 'Test123' 

Delete

Remove a Target by specifying the Id.

DELETE FROM Targets WHERE Id = 10003

Columns

Name Type ReadOnly Description
ID [KEY] String False

The unique identifier of the record.

AccountName String False

The name of the associated acocunt.

Address String True

Address from Google Maps of the target.

AlternateAddressCity String False

The city for the alternate address.

AlternateAddressCountry String False

The country for the alternate address.

AlternateAddressPostalCode String False

The postal code for the alternate address.

AlternateAddressState String False

The state for the alternate address.

AlternateAddressStreet String False

The street address for the alternate address.

AlternateAddressStreet2 String True

The second line of the alternate address.

AlternateAddressStreet3 String True

The third line of the alternate address.

AnyEmail String True

The email for the target.

AssignedUserId String False

The Id of the user assigned to the record.

AssignedUserName String True

The user name of the user assigned to the record.

Assistant String False

The name of the assistant of the target.

AssistantPhone String False

The phone number of the assistant of the target.

Birthdate Date False

The birthdate of the target.

CampaignID String False

Campaign that generated the lead.

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.

Department String False

The department of the target.

Description String False

Full text of the note.

DoNotCall Bool False

An indicator of whether the target can be called.

EmailAddress String False

The alternate email for the target.

EmailOptOut Bool True

Whether the target has opted out of radio.

Fax String False

The target fax number.

FirstName String False

The first name of the target.

FullName String True

The full name of the target.

GeocodeStatus String True

Geocode from Google Maps of the target.

Home String False

Home phone number of the target.

InvalidEmail Bool True

Whether the target email has been marked as invalid.

LastName String False

The last name of the target.

Latitude Double True

Latitude from Google Maps of the target.

LBL_CONT_ACCEPT_STATUS String True

The event accept status fields.

LBL_CONT_INVITE_STATUS String True

The event invite status fields.

LBL_LIST_ACCEPT_STATUS String True

Id of the target's event status.

LBL_LIST_ACCEPT_STATUS_EVENT String True

Status of the target's event accept.

LBL_LIST_INVITE_STATUS String True

Id of the target's event invite.

LBL_LIST_INVITE_STATUS_EVENT String True

Name of the target's event status.

LeadId String False

The Id of the associated lead.

Longitude Double True

Longitude from Google Maps of the target.

Mobile String False

Mobile phone number of the target.

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 True

The name of the target.

NonPrimaryE-mails String True

The nonprimary email addresses for the target.

OfficePhone String False

Work phone number of the target.

OtherEmail String True

The alternate email for the target.

OtherPhone String False

Other phone number for the target.

Photo String False

The picture for the target.

PrimaryAddressCity String False

The city for the primary address.

PrimaryAddressCountry String False

The country for the primary address.

PrimaryAddressPostalCode String False

The postal code for the primary address.

PrimaryAddressState String False

The state for the primary address.

PrimaryAddressStreet String False

The street address used for the primary address.

PrimaryAddressStreet2 String True

The second line of the primary address.

PrimaryAddressStreet3 String True

The third line of the primary addrss.

Salutation String False

The target salutation (e.g., Mr. or Ms.).

Title String False

The title of the target.

TrackerKey Int False

The key for the associated tracker.

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