Targets

Query targets saved in SuiteCRM

Table Specific Information

Select

You can query the Targets table using any criteria in the WHERE clause. The connector 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', '[email protected]', '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.

Power BI Connector for SuiteCRM