SSIS Components for Act! CRM

Build 24.0.9060

ContactHistories

Get all the history related to a contact.

Table Specific Information

Select

  • ContactId supports the '=' operator.
The component uses the Act! CRM API to process search criteria that refer to the supported fields. The component processes other filters client-side within the component. For example, the following queries are processed server side:
SELECT * FROM ContactHistories 

SELECT * FROM ContactHistories WHERE ContactId = '12345'

Columns

Name Type Description
Id [KEY] String Id of the history item created
ContactId String Id of the contact
AttachmentDisplayName String Name of the attachment related to a history
AttachmentFileExtension String FileExtension of the attachment related to a history
AttachmentFileName String FileName of the attachment related to a history
AttachmentFileSize Integer File Size of the attachment related to a history
AttachmentFileSizeDisplay String File Size Display of the attachment related to a history
AttachmentFileType String FileType of the attachment related to a history
AttachmentLastModified Datetime File Last Modified date of the attachment related to a history
AttachmentPersonal Boolean Attachment Personal
CompaniesAggregate String Companies associated with a history
ContactsAggregate String Contacts associated with a history
Created Datetime The datetime when history was created
CreateUserID String User Id of the user who craeted the history
Details String Details of history
Duration String Duration
Edited Datetime Datetime when history was last edited
EndTime Datetime End Time of history
GroupsAggregate String Groups associated with history
HistoryTypeDescription String Description of the type of history
HistoryTypeId Integer History Type ID
HistoryTypeName String Name of history type
TypeID Integer Id of history type
IsPrivate Boolean Indicates whether history is private or not
ManageUserID String User Id of manager
OpportunitiesAggregate String Opportunities associated with history
OutlookID String Outlook Id
RecordManager String Record Manager
RecordManagerID String Id of Record Msnager
Regarding String Tells what history is about
StartTime Datetime Start Time

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060