CampaignLog
Create, update, delete, and query logs related to SuiteCRM campaigns
テーブル固有の情報
Select
WHERE 句で任意の条件を使用して、Campaign Log テーブルをクエリできます。connector はSuiteCRM API を使用して結果をフィルタリングします。
SELECT * FROM [Campaign Log] WHERE Campaign_Id = 'campaign1'
Insert
書き込み可能なカラムを指定して、Campaign Log を作成します。
INSERT INTO [Campaign Log] (Name, Campaign_Id) VALUES ('Test Log', 'Campaign2')
Update
Id を指定して、書き込み可能なCampaign Log カラムを更新できます。
UPDATE [Campaign Log] SET Archived = true WHERE Id = 'Test123'
Delete
Id を指定して、Campaign Log を削除します。
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |