ActiveCampaign Connector Objects
This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.
| Name | Description |
|---|---|
| AccountContacts | Usage information for the operation AccountContacts.rsd. |
| AccountCustomFieldData | Create, modify, delete and query the available deal custom field data in ActiveCampaign. |
| Accounts | View many or all contacts by including their ID’s or various filters. |
| Addresses | Usage information for the operation Addresses.rsd. |
| Automations | Usage information for the operation Automations.rsd. |
| Campaigns | Query the campaigns information in ActiveCampaign. |
| ContactAutomations | View many or all contacts by including their ID’s or various filters. |
| ContactCustomFieldData | Create, modify, delete and query the available contact custom field data in ActiveCampaign. |
| ContactLists | Retrieve ContactList for each contact Group or for the specific Contact group. |
| Contacts | View many or all contacts by including their ID’s or various filters. |
| ContactTags | Retrieve tags added for each contact or for the specific Contact Id |
| DealActivities | Retrieve Deal Activities for each Deal or for the specific Deal Id. |
| DealCustomFieldData | Create, modify, delete and query the available deal custom field data in ActiveCampaign. |
| DealGroups | Lists all existing accounts. |
| Deals | Usage information for the operation Deals.rsd. |
| DealStages | Usage information for the operation DealStages.rsd. |
| Lists | Usage information for the operation Lists.rsd. |
| Scores | View many or all contacts by including their ID’s or various filters. |
| Tags | View many or all tags by including their ID’s or various filters. |
| Tasks | Lists all existing accounts. |
| TrackingLogs | Retrieve trackingLogs for the specific contact or all contacts |
| Users | Usage information for the operation Users.rsd. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id of the account-contact association. | |
| AccountId | String | False | Accounts.Id | No | The account Id. |
| ContactId | String | False | Contacts.Id | No | The contact Id. |
| CreatedTimestamp | Datetime | True | No | Datetime value which indicates when the assosiaction was created. | |
| JobTitle | String | False | No | Job Title of the contact at the account. | |
| AccountLink | String | True | No | Account link. | |
| ContactLink | String | True | No | Contact link. | |
| UpdatedTimestamp | Datetime | True | No | Datetime value which indicates when the assosiaction was last updated. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id of the account custom field data. | |
| AccountCustomFieldMetumId | Integer | True | No | The custom field metum Id. | |
| AccountId | Integer | False | No | The ID of the account the field value relates to. | |
| CreatedTimestamp | Datetime | True | No | Datetime value that indicates when the custom field value was set. | |
| CustomFieldId | Integer | False | No | The ID of the custom field metum the field value relates to. | |
| CustomFieldName | String | True | No | The name of the custom field metum the field value relates to. | |
| FieldValue | String | False | No | Values for the field. (For currency field only, this needs to be in cents: eg, 10050 = 100.5). | |
| AccountLink | String | True | No | Account link. | |
| AccountCustomFieldMetumLink | String | True | No | AccountCustomFieldMetum link. | |
| UpdatedTimestamp | Datetime | True | No | Datetime value which indicates when the custom field data was last updated. | |
| FieldCurrency | String | False | No | Value of the custom field currency type for a specific contact. This field is required when inserting currency custom fields. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id column of the Accounts table. | |
| AccountUrl | String | False | No | Account’s website. | |
| ContactCount | Integer | True | No | The ContactCount column of the Accounts table. | |
| CreatedTimestamp | Datetime | True | No | The CreatedTimestamp column of the Accounts table. | |
| DealCount | Integer | True | No | The DealCount column of the Accounts table. | |
| AccountContactsLink | String | True | No | The AccountContactsLink column of the Accounts table. | |
| AccountCustomFieldDataLink | String | True | No | The AccountCustomFieldDataLink column of the Accounts table. | |
| ContactEmailsLink | String | True | No | The ContactEmailsLink column of the Accounts table. | |
| EmailActivitiesLink | String | True | No | The EmailActivitiesLink column of the Accounts table. | |
| NotesLink | String | True | No | The NotesLink column of the Accounts table. | |
| Name | String | False | No | Account’s name. | |
| UpdatedTimestamp | Datetime | True | No | The UpdatedTimestamp column of the Accounts table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id | String | True | No | The Id column of the Addresses table. | |
| Address1 | String | True | No | The Address1 column of the Addresses table. | |
| Address2 | String | True | No | The Address2 column of the Addresses table. | |
| Allgroup | String | True | No | The Allgroup column of the Addresses table. | |
| City | String | True | No | The City column of the Addresses table. | |
| CompanyName | String | True | No | The CompanyName column of the Addresses table. | |
| Country | String | True | No | The Country column of the Addresses table. | |
| District | String | True | No | The District column of the Addresses table. | |
| isDefault | String | True | No | The isDefault column of the Addresses table. | |
| AddressGroupLink | String | True | No | The AddressGroupLink column of the Addresses table. | |
| AddressListLink | String | True | No | The AddressListLink column of the Addresses table. | |
| FormsLink | String | True | No | The FormsLink column of the Addresses table. | |
| State | String | True | No | The State column of the Addresses table. | |
| Zip | String | True | No | The Zip column of the Addresses table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id | String | True | No | The Id column of the Automations table. | |
| Cdate | Datetime | True | No | The Cdate column of the Automations table. | |
| DefaultScreenshot | String | True | No | The DefaultScreenshot column of the Automations table. | |
| Entered | String | True | No | The Entered column of the Automations table. | |
| Exited | String | True | No | The Exited column of the Automations table. | |
| Hidden | String | True | No | The Hidden column of the Automations table. | |
| BlocksLink | String | True | No | The BlocksLink column of the Automations table. | |
| CampaignsLink | String | True | No | The CampaignsLink column of the Automations table. | |
| ContactAutomationsLink | String | True | No | The ContactAutomationsLink column of the Automations table. | |
| ContactGoalsLink | String | True | No | The ContactGoalsLink column of the Automations table. | |
| GoalsLink | String | True | No | The GoalsLink column of the Automations table. | |
| SiteMessagesLink | String | True | No | The SiteMessagesLink column of the Automations table. | |
| SmsLink | String | True | No | The SmsLink column of the Automations table. | |
| Mdate | Datetime | True | No | The Mdate column of the Automations table. | |
| Name | String | True | No | The Name column of the Automations table. | |
| Screenshot | String | True | No | The Screenshot column of the Automations table. | |
| Status | String | True | No | The Status column of the Automations table. | |
| UserId | String | True | No | The UserId column of the Automations table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id column of the Campaigns table. | |
| ActiveRssInterval | String | True | No | The ActiveRssInterval column of the Campaigns table. | |
| ActiveRssItems | String | True | No | The ActiveRssItems column of the Campaigns table. | |
| ActiveRssUrl | String | True | No | The ActiveRssUrl column of the Campaigns table. | |
| AddressId | String | True | No | The AddressId column of the Campaigns table. | |
| AnalyticsCampaignName | String | True | No | The AnalyticsCampaignName column of the Campaigns table. | |
| Automation | String | True | No | The Automation column of the Campaigns table. | |
| BaseMessageId | String | True | No | The BaseMessageId column of the Campaigns table. | |
| BaseTemplateId | String | True | No | The BaseTemplateId column of the Campaigns table. | |
| BounceId | String | True | No | The BounceId column of the Campaigns table. | |
| CanSkipApproval | String | True | No | The can_skip_approval column of the Campaigns table. | |
| Cdate | Datetime | True | No | The Cdate column of the Campaigns table. | |
| CreatedBy | String | True | No | The Created By column of the Campaigns table. | |
| CreatedTimestamp | Datetime | True | No | The Created Timestamp column of the Campaigns table. | |
| DeleteStamp | String | True | No | The DeleteStamp column of the Campaigns table. | |
| EmbedImages | String | True | No | The EmbedImages column of the Campaigns table. | |
| String | True | No | The Facebook column of the Campaigns table. | ||
| FormId | String | True | No | The FormId column of the Campaigns table. | |
| Forwards | String | True | No | The Forwards column of the Campaigns table. | |
| HardBounces | String | True | No | The HardBounces column of the Campaigns table. | |
| HasPredictiveContent | Bit | True | No | The HasPredictiveContent column of the Campaigns table. | |
| HtmlUnsub | String | True | No | The HtmlUnsub column of the Campaigns table. | |
| HtmlUnsubdata | String | True | No | The HtmlUnsubdata column of the Campaigns table. | |
| Ip | String | True | No | The Ip column of the Campaigns table. | |
| Ip4 | String | True | No | The Ip4 column of the Campaigns table. | |
| LastStep | String | True | No | The LastStep column of the Campaigns table. | |
| Ldate | String | True | No | The Ldate column of the Campaigns table. | |
| LinkClicks | String | True | No | The LinkClicks column of the Campaigns table. | |
| AutomationLink | String | True | No | The AutomationLink column of the Campaigns table. | |
| CampaignAggregateRevenuesLink | String | True | No | The AggregateRevenues column of the Campaigns table. | |
| CampaignListsLink | String | True | No | The CampaignListsLink column of the Campaigns table. | |
| CampaignMessageLink | String | True | No | The CampaignMessageLink column of the Campaigns table. | |
| CampaignMessagesLink | String | True | No | The CampaignMessagesLink column of the Campaigns table. | |
| LinksLink | String | True | No | The LinksLink column of the Campaigns table. | |
| LinksSegment | String | True | No | The Segment column of the Campaigns table. | |
| UserLink | String | True | No | The UserLink column of the Campaigns table. | |
| MailCleanup | String | True | No | The MailCleanup column of the Campaigns table. | |
| MailSend | String | True | No | The MailSend column of the Campaigns table. | |
| MailTransfer | String | True | No | The MailTransfer column of the Campaigns table. | |
| MailerLogFile | String | True | No | The MailerLogFile column of the Campaigns table. | |
| ManageText | String | True | No | The ManageText column of the Campaigns table. | |
| Mdate | Datetime | True | No | The Mdate column of the Campaigns table. | |
| Name | String | True | No | The Name column of the Campaigns table. | |
| Opens | String | True | No | The Opens column of the Campaigns table. | |
| Public | String | True | No | The Public column of the Campaigns table. | |
| RealCid | String | True | No | The RealCid column of the Campaigns table. | |
| Recurring | String | True | No | The Recurring column of the Campaigns table. | |
| ReminderField | String | True | No | The ReminderField column of the Campaigns table. | |
| ReminderFormat | String | True | No | The ReminderFormat column of the Campaigns table. | |
| ReminderLastCronRun | String | True | No | The ReminderLastCronRun column of the Campaigns table. | |
| ReminderOffset | String | True | No | The ReminderOffset column of the Campaigns table. | |
| ReminderOffsetSign | String | True | No | The ReminderOffsetSign column of the Campaigns table. | |
| ReminderOffsetType | String | True | No | The ReminderOffsetType column of the Campaigns table. | |
| ReminderType | String | True | No | The ReminderType column of the Campaigns table. | |
| Replies | String | True | No | The Replies column of the Campaigns table. | |
| ReplySys | String | True | No | The ReplySys column of the Campaigns table. | |
| ResponderExisting | String | True | No | The ResponderExisting column of the Campaigns table. | |
| ResponderOffset | String | True | No | The ResponderOffset column of the Campaigns table. | |
| ResponderType | String | True | No | The ResponderType column of the Campaigns table. | |
| Schedule | String | True | No | The Schedule column of the Campaigns table. | |
| ScheduledDate | String | True | No | The ScheduledDate column of the Campaigns table. | |
| Screenshot | String | True | No | The Screenshot column of the Campaigns table. | |
| Sdate | String | True | No | The Sdate column of the Campaigns table. | |
| SegmentId | String | True | No | The SegmentId column of the Campaigns table. | |
| SegmentName | String | True | No | The SegmentName column of the Campaigns table. | |
| SendAmt | String | True | No | The SendAmt column of the Campaigns table. | |
| SendId | String | True | No | The SendId column of the Campaigns table. | |
| SeriesId | String | True | No | The SeriesId column of the Campaigns table. | |
| Series Send Lock Time | String | True | No | The SeriesSendLockTime column of the Campaigns table. | |
| SocialShares | String | True | No | The SocialShares column of the Campaigns table. | |
| SoftBounces | String | True | No | The SoftBounces column of the Campaigns table. | |
| Source | String | True | No | The Source column of the Campaigns table. | |
| SplitContent | String | True | No | The SplitContent column of the Campaigns table. | |
| SplitOffset | String | True | No | The SplitOffset column of the Campaigns table. | |
| SplitOffsetType | String | True | No | The SplitOffsetType column of the Campaigns table. | |
| SplitType | String | True | No | The SplitType column of the Campaigns table. | |
| SplitWinnerAwaiting | String | True | No | The SplitWinnerAwaiting column of the Campaigns table. | |
| SplitWinnerMessageId | String | True | No | The SplitWinnerMessageId column of the Campaigns table. | |
| Status | String | True | No | The Status column of the Campaigns table. | |
| SubscriberClicks | String | True | No | The SubscriberClicks column of the Campaigns table. | |
| Survey | String | True | No | The Survey column of the Campaigns table. | |
| TextUnsub | String | True | No | The TextUnsub column of the Campaigns table. | |
| TextUnsubData | String | True | No | The TextUnsubData column of the Campaigns table. | |
| ThreadId | String | True | No | The ThreadId column of the Campaigns table. | |
| TotalAmt | String | True | No | The TotalAmt column of the Campaigns table. | |
| TrackLinks | String | True | No | The TrackLinks column of the Campaigns table. | |
| TrackLinksAnalytics | String | True | No | The TrackLinksAnalytics column of the Campaigns table. | |
| TrackReads | String | True | No | The TrackReads column of the Campaigns table. | |
| TrackReadsAnalytics | String | True | No | The TrackReadsAnalytics column of the Campaigns table. | |
| Tweet | String | True | No | The Tweet column of the Campaigns table. | |
| Type | String | True | No | The Type column of the Campaigns table. | |
| UniqueForwards | String | True | No | The UniqueForwards column of the Campaigns table. | |
| UniqueLinkClicks | String | True | No | The UniqueLinkClicks column of the Campaigns table. | |
| UniqueOpens | String | True | No | The UniqueOpens column of the Campaigns table. | |
| UniqueReplies | String | True | No | The UniqueReplies column of the Campaigns table. | |
| UnsubReasons | String | True | No | The UnsubReasons column of the Campaigns table. | |
| Unsubscribes | String | True | No | The Unsubscribes column of the Campaigns table. | |
| Updated By | String | True | No | The UpdatedBy column of the Campaigns table. | |
| Updated Timestamp | String | True | No | The UpdatedTimestamp column of the Campaigns table. | |
| Updates | String | True | No | The Updates column of the Campaigns table. | |
| User | String | True | No | The User column of the Campaigns table. | |
| UserId | String | True | No | The UserId column of the Campaigns table. | |
| WaitPreview | String | True | No | The WaitPreview column of the Campaigns table. | |
| WillRecur | String | True | No | The WillRecur column of the Campaigns table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id | String | True | No | The Id column of the ContactAutomations table. | |
| Adddate | Datetime | True | No | The Adddate column of the ContactAutomations table. | |
| Automation | String | True | No | The Automation column of the ContactAutomations table. | |
| Batchid | Unknown | True | No | The Batchid column of the ContactAutomations table. | |
| CompleteValue | Integer | True | No | The CompleteValue column of the ContactAutomations table. | |
| Completed | Integer | True | No | The Completed column of the ContactAutomations table. | |
| CompletedElements | String | True | No | The CompletedElements column of the ContactAutomations table. | |
| ContactId | String | True | Contacts.Id | No | The ContactId column of the ContactAutomations table. |
| Lastblock | String | True | No | The Lastblock column of the ContactAutomations table. | |
| Lastdate | Datetime | True | No | The Lastdate column of the ContactAutomations table. | |
| LastLogId | String | True | No | The LastLogId column of the ContactAutomations table. | |
| AutomationLink | String | True | No | The AutomationLink column of the ContactAutomations table. | |
| ContactLink | String | True | No | The ContactLink column of the ContactAutomations table. | |
| ContactGoalsLink | String | True | No | The ContactGoalsLink column of the ContactAutomations table. | |
| Remdate | Datetime | True | No | The Remdate column of the ContactAutomations table. | |
| SeriesId | String | True | No | The SeriesId column of the ContactAutomations table. | |
| StartId | String | True | No | The StartId column of the ContactAutomations table. | |
| Status | String | True | No | The Status column of the ContactAutomations table. | |
| TimeSpan | String | True | No | The TimeSpan column of the ContactAutomations table. | |
| TotalElements | String | True | No | The TotalElements column of the ContactAutomations table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The Id column of the ContactCustomFieldData table. | |
| CDate | Datetime | False | No | The CDate column of the ContactCustomFieldData table. | |
| ContactId | String | False | No | The ContactId column of the ContactCustomFieldData table. | |
| CustomFieldName | String | True | No | The name of the custom field metum the field value relates to. | |
| FieldId | String | False | No | ID of the field the value belongs to. | |
| FieldLink | String | False | No | The FieldLink column of the ContactCustomFieldData table. | |
| OwnerLink | String | False | No | The OwnerLink column of the ContactCustomFieldData table. | |
| Owner | String | False | No | The Owner column of the ContactCustomFieldData table. | |
| Udate | Datetime | False | No | The Udate column of the ContactCustomFieldData table. | |
| FieldValue | String | False | No | Value of the custom field for a specific contact. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id column of the ContactLists table. | |
| ContactId | String | True | Contacts.Id | No | The ContactId column of the ContactLists table. |
| AutomationId | String | True | Automations.Id | No | The AutomationId column of the ContactLists table. |
| AutosyncLog | String | True | No | The AutosyncLog column of the ContactLists table. | |
| Campaign | String | True | No | The Campaign column of the ContactLists table. | |
| CreatedBy | String | True | No | The CreatedBy column of the ContactLists table. | |
| CreatedTimestamp | Datetime | True | No | The CreatedTimestamp column of the ContactLists table. | |
| FirstName | String | True | No | The FirstName column of the ContactLists table. | |
| Form | String | True | No | The Form column of the ContactLists table. | |
| Ip4Sub | String | True | No | The Ip4Sub column of the ContactLists table. | |
| Ip4Unsub | String | True | No | The Ip4Unsub column of the ContactLists table. | |
| Ip4Last | String | True | No | The Ip4Last column of the ContactLists table. | |
| LastName | String | True | No | The LastName column of the ContactLists table. | |
| AutomationLink | String | True | No | The AutomationLink column of the ContactLists table. | |
| AutosyncLogLink | String | True | No | The AutosyncLogLink column of the ContactLists table. | |
| CampaignLink | String | True | No | The CampaignLink column of the ContactLists table. | |
| ContactLink | String | True | No | The ContactLink column of the ContactLists table. | |
| FormLink | String | True | No | The FormLink column of the ContactLists table. | |
| ListLink | String | True | No | The ListLink column of the ContactLists table. | |
| MessageLink | String | True | No | The MessageLink column of the ContactLists table. | |
| UnsubscribeAutomationLink | String | True | No | The UnsubscribeAutomationLink column of the ContactLists table. | |
| ListId | String | True | Lists.Id | No | The ListId column of the ContactLists table. |
| Message | String | True | No | The Message column of the ContactLists table. | |
| Responder | String | True | No | The Responder column of the ContactLists table. | |
| Sdate | Datetime | True | No | The Sdate column of the ContactLists table. | |
| SeriesId | String | True | No | The SeriesId column of the ContactLists table. | |
| Status | String | True | No | The Status column of the ContactLists table. | |
| SourceId | String | True | No | The SourceId column of the ContactLists table. | |
| Sync | String | True | No | The Sync column of the ContactLists table. | |
| Unsubreason | String | True | No | The Unsubreason column of the ContactLists table. | |
| UnsubscribeAutomation | String | True | No | The UnsubscribeAutomation column of the ContactLists table. | |
| UpdatedBy | String | True | No | The UpdatedBy column of the ContactLists table. | |
| UpdatedTimestamp | Datetime | True | No | The UpdatedTimestamp column of the ContactLists table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id column of the Contacts table. | |
| Adate | Datetime | True | No | The Adate column of the Contacts table. | |
| Anonymized | String | True | No | The Anonymized column of the Contacts table. | |
| BouncedDate | String | True | No | The BouncedDate column of the Contacts table. | |
| BouncedHard | String | True | No | The BouncedHard column of the Contacts table. | |
| BouncedSoft | String | True | No | The BouncedSoft column of the Contacts table. | |
| Cdate | Datetime | True | No | The Cdate column of the Contacts table. | |
| CreatedBy | String | True | No | The CreatedBy column of the Contacts table. | |
| CreatedTimestamp | Datetime | True | No | The CreatedTimestamp column of the Contacts table. | |
| CreatedUtcTimestamp | Datetime | True | No | The CreatedUtcTimestamp column of the Contacts table. | |
| Deleted | String | True | No | The Deleted column of the Contacts table. | |
| DeletedAt | String | True | No | The DeletedAt column of the Contacts table. | |
| Edate | Datetime | True | No | The Edate column of the Contacts table. | |
| String | False | No | The Email column of the Contacts table. | ||
| EmailDomain | String | True | No | The EmailDomain column of the Contacts table. | |
| EmailEmpty | Boolean | True | No | The EmailEmpty column of the Contacts table. | |
| EmailLocal | String | True | No | The EmailLocal column of the Contacts table. | |
| FirstName | String | False | No | The FirstName column of the Contacts table. | |
| Gravatar | String | True | No | The Gravatar column of the Contacts table. | |
| Hash | String | True | No | The Hash column of the Contacts table. | |
| Ip | String | True | No | The Ip column of the Contacts table. | |
| LastName | String | False | No | The LastName column of the Contacts table. | |
| AccountContactsLink | String | True | No | The AccountContactsLink column of the Contacts table. | |
| AutomationEntryCountsLink | String | True | No | The AutomationEntryCountsLink column of the Contacts table. | |
| BounceLogsLink | String | True | No | The BounceLogsLink column of the Contacts table. | |
| ContactAutomationsLink | String | True | No | The ContactAutomationsLink column of the Contacts table. | |
| ContactDataLink | String | True | No | The ContactDataLink column of the Contacts table. | |
| ContactDealsLink | String | True | No | The ContactDealsLink column of the Contacts table. | |
| ContactGoalsLink | String | True | No | The ContactGoalsLink column of the Contacts table. | |
| ContactListsLink | String | True | No | The ContactListsLink column of the Contacts table. | |
| ContactLogsLink | String | True | No | The ContactLogsLink column of the Contacts table. | |
| ContactTagsLink | String | True | No | The ContactTagsLink column of the Contacts table. | |
| DealsLink | String | True | No | The DealsLink column of the Contacts table. | |
| FieldValuesLink | String | True | No | The FieldValuesLink column of the Contacts table. | |
| GeoIpsLink | String | True | No | The GeoIpsLink column of the Contacts table. | |
| NotesLink | String | True | No | The NotesLink column of the Contacts table. | |
| OrganizationLink | String | True | No | The OrganizationLink column of the Contacts table. | |
| PlusAppendLink | String | True | No | The PlusAppendLink column of the Contacts table. | |
| ScoreValuesLink | String | True | No | The ScoreValuesLink column of the Contacts table. | |
| TrackingLogsLink | String | True | No | The TrackingLogsLink column of the Contacts table. | |
| Organization | String | True | No | The Organization column of the Contacts table. | |
| Orgname | String | True | No | The Orgname column of the Contacts table. | |
| Phone | String | False | No | The Phone column of the Contacts table. | |
| RatingTStamp | String | True | No | The RatingTStamp column of the Contacts table. | |
| SegmentioId | String | True | No | The SegmentioId column of the Contacts table. | |
| Sentcnt | String | True | No | The Sentcnt column of the Contacts table. | |
| SocialdataLastcheck | String | True | No | The SocialdataLastcheck column of the Contacts table. | |
| Ua | String | True | No | The Ua column of the Contacts table. | |
| Udate | Datetime | True | No | The Udate column of the Contacts table. | |
| UpdatedTimestamp | String | True | No | The UpdatedTimestamp column of the Contacts table. | |
| Updated_by | String | True | No | The Updated_by column of the Contacts table. | |
| SubscribeTo | String | False | No | Comma-separated list of list Ids to subscribe a contact to. | |
| UnsubscribeFrom | String | False | No | Comma-separated list of list Ids to unsubscribe a contact from. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id column of the ContactTags table. | |
| ContactId | String | True | Contacts.Id | No | The ContactId column of the ContactTags table. |
| Cdate | Datetime | True | No | The Cdate column of the ContactTags table. | |
| CreatedBy | String | True | No | The CreatedBy column of the ContactTags table. | |
| CreatedTimestamp | Datetime | True | No | The CreatedTimestamp column of the ContactTags table. | |
| ContactLink | String | True | No | The ContactLink column of the ContactTags table. | |
| TagLink | String | True | No | The TagLink column of the ContactTags table. | |
| Tag | String | True | No | The Tag column of the ContactTags table. | |
| UpdatedBy | String | True | No | The UpdatedBy column of the ContactTags table. | |
| UpdatedTimestamp | Datetime | True | No | The UpdatedTimestamp column of the ContactTags table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id of the activity. | |
| DealId | String | True | Deals.Id | No | The Id of the Deal to which the activity belongs to. |
| StageId | String | True | DealStages.Id | No | The Id of the Stage to which the parent Deal of the activity belongs to. |
| UserId | String | True | Users.Id | No | The Id of the User which triggered the activity. |
| DataId | String | True | No | The Id for the related object (e.g. a Task or Note or similar), if relevant. | |
| DataType | String | True | No | The type of the activity. Examples include ‘userid’ or ‘subscriberid’ or ‘task’ or ‘note’ or empty quotes (”) for the deal’s initial creation. | |
| DataAction | String | True | No | The action taken by this activity. Examples include ‘add’ or ‘complete’ or the new value (‘100’) if the value is changing. | |
| DataOldVal | String | True | No | The previous value, if the value has changed (see DataAction); otherwise, empty quotes (”) | |
| CreatedDate | Datetime | True | No | The creation date of the activity. | |
| SortDate | Datetime | True | No | ||
| IsAddTask | Boolean | True | No | Indicates whether the activity was adding a task to the deal. | |
| Deleted | Boolean | True | No | Indicates whethere the activity was deleted or not. | |
| SeriesId | String | True | No | ||
| DealLink | String | True | No | The API endpoint to the Deal related to this activity. | |
| StageLink | String | True | No | The API endpoint to the Stage related to this activity. | |
| UserLink | String | True | No | The API endpoint to the User related to this activity. | |
| AutomationLink | String | True | No | The API endpoint to the Automation related to this activity. | |
| ActivityLink | String | True | No | The API endpoint to the Activity. | |
| Deal | String | True | No | The related to this Activity. | |
| Stage | String | True | No | The Stage column of the DealActivities table. | |
| User | String | True | No | The User column of the DealActivities table. | |
| Automation | String | True | No | The Automation which triggered this activity. | |
| Exclude | String | False | Yes | Include this param to exclude ‘email’, ‘connection_email’, and ‘LinkData’ activity types. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The Id column of the DealCustomFieldData table. | |
| CreatedTimestamp | Datetime | False | No | The CreatedTimestamp column of the DealCustomFieldData table. | |
| CustomFieldName | String | True | No | The name of the custom field metum the field value relates to. | |
| CustomFieldId | Integer | False | No | The CustomFieldId column of the DealCustomFieldData table. | |
| DealCustomFieldMetumId | Integer | False | No | The DealCustomFieldMetumId column of the DealCustomFieldData table. | |
| DealId | Integer | False | No | The DealId column of the DealCustomFieldData table. | |
| FieldValue | String | False | No | The FieldValue column of the DealCustomFieldData table. | |
| DealLink | String | False | No | The DealLink column of the DealCustomFieldData table. | |
| DealCustomFieldMetumLink | String | False | No | The DealCustomFieldMetumLink column of the DealCustomFieldData table. | |
| UpdatedTimestamp | Datetime | False | No | The UpdatedTimestamp column of the DealCustomFieldData. | |
| FieldCurrency | String | False | No | Value of the custom field currency type for a specific deal. This field is required when inserting currency custom fields. | |
| FieldType | String | False | No | Value of the custom field currency type for a specific deal. This field is required when inserting currency custom fields. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The pipeline Id. | |
| AllGroups | String | False | No | The AllGroups column of the DealGroups table. Indicates whether all user groups have permission to manage this pipeline. Can be either 1 or 0. If 1, all user groups can manage this pipeline. If 0, only user groups in dealGroup.groups parameter can manage this pipeline. | |
| AllUsers | String | False | No | The AllUsers column of the DealGroups table. Indicates whether new deals get auto-assigned to all users. Can be either 1 or 0. If 1, new deals are auto-assigned to all users unless auto-assign is disabled. If 0, new deals are auto-assigned to only the users in dealGroup.users parameter. | |
| AutoAssign | String | False | No | The AutoAssign column of the DealGroups table. Deal auto-assign option. Can be one of 0, 1, and 2. If 0, auto-assign is disabled. If 1, Round Robin method is used to auto-assign new deals. If 2, deals are distributed based on deal values. | |
| Cdate | Datetime | True | No | The Cdate column of the DealGroups table. | |
| Currency | String | False | No | The Currency column of the DealGroups table. | |
| DealGroupGroupsLink | String | True | No | The DealGroupGroupsLink column of the DealGroups table. | |
| DealGroupUsersLink | String | True | No | The DealGroupUsersLink column of the DealGroups table. | |
| StagesLink | String | True | No | The StagesLink column of the DealGroups table. | |
| Stages | String | True | No | The Stages column of the DealGroups table. | |
| Title | String | False | No | Pipeline’s title. | |
| Udate | Datetime | True | No | The Udate column of the DealGroups table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id column of the Deals table. | |
| AccountId | String | False | No | The AccountId column of the Deals table. | |
| ActivityCount | String | True | No | The ActivityCount column of the Deals table. | |
| Cdate | Datetime | True | No | The Cdate column of the Deals table. | |
| ContactId | String | False | No | Deal’s primary contact’s Id. | |
| Currency | String | False | No | Deal’s currency in 3-digit ISO format, lowercased. | |
| CustomerAccount | String | True | No | The CustomerAccount column of the Deals table. | |
| Description | String | False | No | The Description column of the Deals table. | |
| Edate | String | True | No | The Edate column of the Deals table. | |
| Group | String | False | No | Deal’s pipeline Id. Required if deal.stage is not provided. If deal.group is not provided, the stage’s pipeline will be assigned to the deal automatically. | |
| Hash | String | True | No | The Hash column of the Deals table. | |
| IsDisabled | String | True | No | The IsDisabled column of the Deals table. | |
| AccountLink | String | True | No | The AccountLink column of the Deals table. | |
| ContactLink | String | True | No | The ContactLink column of the Deals table. | |
| ContactDealsLink | String | True | No | The ContactDealsLink column of the Deals table. | |
| CustomerAccountLink | String | True | No | The CustomerAccountLink column of the Deals table. | |
| DealActivitiesLink | String | True | No | The DealActivitiesLink column of the Deals table. | |
| DealCustomFieldDataLink | String | True | No | The DealCustomFieldDataLink column of the Deals table. | |
| GroupLink | String | True | No | The GroupLink column of the Deals table. | |
| NextTaskLink | String | True | No | The NextTaskLink column of the Deals table. | |
| NotesLink | String | True | No | The NotesLink column of the Deals table. | |
| OrganizationLink | String | True | No | The OrganizationLink column of the Deals table. | |
| OwnerLink | String | True | No | The OwnerLink column of the Deals table. | |
| ScoreValuesLink | String | True | No | The ScoreValuesLink column of the Deals table. | |
| StageLink | String | True | No | The StageLink column of the Deals table. | |
| TasksLink | String | True | No | The TasksLink column of the Deals table. | |
| Mdate | Datetime | True | No | The Mdate column of the Deals table. | |
| NextTask | String | True | No | The NextTask column of the Deals table. | |
| NextDate | Datetime | True | No | The NextDate column of the Deals table. | |
| NextDealId | String | True | No | The NextDealId column of the Deals table. | |
| NextTaskId | String | True | No | The NextTaskId column of the Deals table. | |
| Organization | String | True | No | The Organization column of the Deals table. | |
| Owner | String | False | No | Deal’s owner Id. Required if pipeline’s auto-assign option is disabled. | |
| Percent | String | False | No | The Percent column of the Deals table. | |
| Stage | String | False | No | Deal’s stage Id. Required if deal.group is not provided. If deal.stage is not provided, the deal will be assigned with the first stage in the pipeline provided in deal.group. | |
| Status | String | False | No | The Status column of the Deals table. | |
| Title | String | False | No | The Title column of the Deals table. | |
| Value | String | False | No | Deal’s value in cents. | |
| WinProbability | Integer | True | No | The WinProbability column of the Deals table. | |
| WinProbabilityMdate | Datetime | True | No | The WinProbabilityMdate column of the Deals table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id column of the DealStages table. | |
| CardRegion1 | String | False | No | The CardRegion1 column of the DealStages table. Indicates what to show in upper-left corner of Deal Cards. | |
| CardRegion2 | String | False | No | The CardRegion2 column of the DealStages table. Indicates what to show in upper-right corner of Deal Cards. | |
| CardRegion3 | String | False | No | The CardRegion3 column of the DealStages table. Indicates whether to show the avatar in Deal Cards. Can be one of show-avatar and hide-avatar. If set to show-avatar, deal cards will show the avatars. If set to hide-avatar, deal cards will hide the avatars. | |
| CardRegion4 | String | False | No | The CardRegion4 column of the DealStages table. Indicates what to show next to the avatar in Deal Cards. | |
| CardRegion5 | String | False | No | The CardRegion5 column of the DealStages table. Indicates what to show in lower-right corner of Deal Cards. | |
| Cdate | Datetime | True | No | The Cdate column of the DealStages table. | |
| Color | String | False | No | Deal Stage’s color. 6-character HEX color code without the hashtag. e.g. 434343 to assign the hex color value #434343. | |
| DealOrder | String | False | No | Option and direction to be used to sort deals in the deal stage. The option and direction should be delimited by a space. Direction can be either. | |
| GroupId | String | False | No | The GroupId column of the DealStages table. | |
| GroupLink | String | True | No | The GroupLink column of the DealStages table. | |
| OrderId | String | False | No | The OrderId column of the DealStages table. | |
| Title | String | False | No | The Title column of the DealStages table. | |
| Udate | Datetime | True | No | The Udate column of the DealStages table. | |
| Width | String | False | No | Deal stage’s width in pixels, without px unit. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id column of the Lists table. | |
| AnalyticsDomains | String | True | No | The AnalyticsDomains column of the Lists table. | |
| AnalyticsSource | String | True | No | The AnalyticsSource column of the Lists table. | |
| AnalyticsUa | String | True | No | The AnalyticsUa column of the Lists table. | |
| CarbonCopy | String | True | No | The CarbonCopy column of the Lists table. | |
| Cdate | Datetime | True | No | The Cdate column of the Lists table. | |
| Udate | Datetime | True | No | The Udate column of the Lists table. | |
| DeleteStamp | String | True | No | The DeleteStamp column of the Lists table. | |
| FacebookSession | String | True | No | The FacebookSession column of the Lists table. | |
| FullAddress | String | True | No | The FullAddress column of the Lists table. | |
| UnsubscribeReason | String | True | No | The UnsubscribeReason column of the Lists table. | |
| AddressListsLink | String | True | No | The AddressListsLink column of the Lists table. | |
| ContactGoalListsLink | String | True | No | The ContactGoalListsLink column of the Lists table. | |
| UserLink | String | True | No | The UserLink column of the Lists table. | |
| Name | String | True | No | The Name column of the Lists table. | |
| OptinMessageId | String | True | No | The OptinMessageId column of the Lists table. | |
| OptinOptout | String | True | No | The OptinOptout column of the Lists table. | |
| OptoutConf | String | True | No | The OptoutConf column of the Lists table. | |
| EmbedImage | String | True | No | The EmbedImage column of the Lists table. | |
| UseAnalyticsLink | String | True | No | The UseAnalyticsLink column of the Lists table. | |
| UseAnalyticsRead | String | True | No | The UseAnalyticsRead column of the Lists table. | |
| UseCaptcha | String | True | No | The UseCaptcha column of the Lists table. | |
| UseFacebook | String | True | No | The UseFacebook column of the Lists table. | |
| UseTracking | String | True | No | The UseTracking column of the Lists table. | |
| UseTwitter | String | True | No | The UseTwitter column of the Lists table. | |
| Private | String | True | No | The Private column of the Lists table. | |
| RequireName | String | True | No | The RequireName column of the Lists table. | |
| SendLastBroadcast | String | True | No | The SendLastBroadcast column of the Lists table. | |
| SenderAddr1 | String | True | No | The SenderAddr1 column of the Lists table. | |
| SenderAddr2 | String | True | No | The SenderAddr2 column of the Lists table. | |
| SenderCity | String | True | No | The SenderCity column of the Lists table. | |
| SenderCountry | String | True | No | The SenderCountry column of the Lists table. | |
| SenderName | String | True | No | The SenderName column of the Lists table. | |
| SenderPhone | String | True | No | The SenderPhone column of the Lists table. | |
| SenderReminder | String | True | No | The SenderReminder column of the Lists table. | |
| SenderState | String | True | No | The SenderState column of the Lists table. | |
| SenderUrl | String | True | No | The SenderUrl column of the Lists table. | |
| SenderZip | String | True | No | The SenderZip column of the Lists table. | |
| StringId | String | True | No | The StringId column of the Lists table. | |
| SubscriptionNotify | String | True | No | The SubscriptionNotify column of the Lists table. | |
| ToName | String | True | No | The ToName column of the Lists table. | |
| TwitterToken | String | True | No | The TwitterToken column of the Lists table. | |
| TwitterTokenSecret | String | True | No | The TwitterTokenSecret column of the Lists table. | |
| UnsubscriptionNotify | String | True | No | The UnsubscriptionNotify column of the Lists table. | |
| ListsUser | String | True | No | The ListsUser column of the Lists table. | |
| ListsUserid | String | True | No | The ListsUserid column of the Lists table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id | String | True | No | The Id column of the Scores table. | |
| Cdate | Datetime | True | No | The Cdate column of the Scores table. | |
| Descript | String | True | No | The Descript column of the Scores table. | |
| Mdate | Datetime | True | No | The Mdate column of the Scores table. | |
| Name | String | True | No | The Name column of the Scores table. | |
| RelType | String | True | No | The RelType column of the Scores table. | |
| Status | String | True | No | The Status column of the Scores table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id column of the Tags table. | |
| Tag | String | True | No | The Tag column of the Tags table. | |
| TagType | String | True | No | The TagType column of the Tags table. | |
| Description | String | True | No | The Description column of the Tags table. | |
| Cdate | Datetime | True | No | The Cdate column of the Tags table. | |
| ContactGoalTagsLink | String | True | No | The ContactGoalTagsLink column of the Tags table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id column of the Tasks table. | |
| Assignee | String | False | No | The Assignee column of the Tasks table. | |
| Automation | String | True | No | The Automation column of the Tasks table. | |
| Cdate | Datetime | True | No | The Cdate column of the Tasks table. | |
| DealTaskType | String | False | No | The type of the task based on the available Task Types in the account. | |
| DoneAutomation | String | False | No | The DoneAutomation column of the Tasks table. | |
| DueDate | Datetime | False | No | Due date of the task. | |
| Edate | Datetime | True | No | The Edate column of the Tasks table. | |
| ActivitiesLink | String | True | No | The ActivitiesLink column of the Tasks table. | |
| AssigneeLink | String | True | No | The AssigneeLink column of the Tasks table. | |
| AutomationLink | String | True | No | The AutomationLink column of the Tasks table. | |
| DealTasktypeLink | String | True | No | The DealTasktypeLink column of the Tasks table. | |
| DoneAutomationLink | String | True | No | The DoneAutomationLink column of the Tasks table. | |
| NotesLink | String | True | No | The NotesLink column of the Tasks table. | |
| OwnerLink | String | True | No | The OwnerLink column of the Tasks table. | |
| TaskNotificationsLink | String | True | No | The TaskNotificationsLink column of the Tasks table. | |
| UserLink | String | True | No | The UserLink column of the Tasks table. | |
| Note | String | False | No | The content describing the task. | |
| OutcomeId | Integer | False | No | The OutcomeId column of the Tasks table. | |
| OutcomeInfo | String | False | No | The OutcomeInfo column of the Tasks table. | |
| OwnerId | String | True | No | The OwnerId column of the Tasks table. | |
| OwnerType | String | False | No | The name of the relating object. Valid values are contact or deal. | |
| Relid | String | False | No | The Id of the relational object for this task. | |
| Reltype | String | True | No | The Reltype column of the Tasks table. | |
| Status | Integer | False | No | The Status column of the Tasks table. 1 is complete and 0 is incomplete.. | |
| Title | String | False | No | The Title column of the Tasks table. | |
| Udate | Datetime | True | No | The Udate column of the Tasks table. | |
| User | String | True | No | The User column of the Tasks table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | True | No | The Id column of the TrackingLogs table. | |
| ContactId | String | True | Contacts.Id | No | The ContactId column of the TrackingLogs table. |
| Hash | String | True | No | The Hash column of the TrackingLogs table. | |
| ContactLink | String | True | No | The ContactLink column of the TrackingLogs table. | |
| SubscriberidLink | String | True | No | The SubscriberidLink column of the TrackingLogs table. | |
| TstampLink | Datetime | True | No | The TstampLink column of the TrackingLogs table. | |
| TypeLink | String | True | No | The TypeLink column of the TrackingLogs table. | |
| ValueLink | String | True | No | The ValueLink column of the TrackingLogs table. | |
| UDateLink | Datetime | False | Yes |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id | String | True | No | The Id column of the Users table. | |
| String | True | No | The Email column of the Users table. | ||
| FirstName | String | True | No | The FirstName column of the Users table. | |
| LastName | String | True | No | The LastName column of the Users table. | |
| ConfigsLink | String | True | No | The ConfigsLinks column of the Users table. | |
| DealGroupTotalsLink | String | True | No | The DealGroupTotalsLink column of the Users table. | |
| DealGroupUsersLink | String | True | No | The DealGroupUsersLink column of the Users table. | |
| ListsLink | String | True | No | The ListsLink column of the Users table. | |
| UserGroupLink | String | True | No | The UserGroupLink column of the Users table. | |
| Phone | Unknown | True | No | The Phone column of the Users table. | |
| Signature | Unknown | True | No | The Signature column of the Users table. | |
| Username | String | True | No | The Username column of the Users table. |