JDBC Driver for SuiteCRM

Build 22.0.8462

CampaignLog

Create, update, delete, and query logs related to SuiteCRM campaigns

Table Specific Information

Select

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

SELECT * FROM [Campaign Log] WHERE Campaign_Id = 'campaign1' 

Insert

Create a Campaign Log by specifying any writable column.

INSERT INTO [Campaign Log] (Name,Campaign_Id) VALUES ('Test Log','Campaign2')

Update

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

UPDATE [Campaign Log] SET Archived = true WHERE Id = 'Test123' 

Delete

Delete a Campaign Log by specifying the Id.

DELETE FROM [Campaign Log] WHERE Id = '10003'

Columns

Name Type ReadOnly Description
ID [KEY] String False

The unique identifier of the record.

ActivityDate Datetime False

The date the activity occurred.

ActivityType String False

The activity that occurred (e.g., Viewed Message, Bounced, or Opted out).

Archived Bool False

Indicates if the item has been archived.

campaign_content String True

The campaign content.

campaign_id String False

The identifier of the campaign associated with the campaign log.

campaign_name String True

The name of the campaign associated with the campaign log.

campaign_objective String True

The campaign objective.

DateModified Datetime False

The date the campaign log was last modified.

Deleted Bool False

Record deletion indicator.

Hits Int False

Number of times the item has been invoked (e.g., multiple click throughs).

LBL_MARKETING_ID String False

The Id of the marketing email this entry is associated with.

marketing_name String False

The marketing name.

MoreInformation String False

More information about the campaign log.

Name String True

The name of the campaign associated with the campaign log.

ProspectListID String False

The prospect list from which the item originated.

recipient_email String True

The email of the recipient.

recipient_name String True

The name of the recipient.

RelatedId String False

The Id of the related record.

RelatedType String False

The type of the related record.

TargetID String False

The identifier of the target record.

TargetTrackerKey String False

The identifier of the tracker URL.

TargetType String False

The target record type (e.g., Contact or Lead).

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