ContactHistories
Get all the history related to a contact.
Table Specific Information
Select
- ContactId supports the '=' operator.
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 |