SSIS Components for Salesforce

Build 25.0.9434

SiteHistory

Tracks changes made to Site records, logging modifications over time.

Columns

Name Type References Description
Id [KEY] String Unique identifier for the site history record.
IsDeleted Bool Indicates whether the site history record has been deleted from the system.
SiteId String

Site.Id

Identifier of the site associated with this history entry.
CreatedById String

User.Id

Identifier of the user who made the change recorded in this history entry.
CreatedByIdType String Specifies the type of the 'CreatedById' polymorphic field to use in the statement.
CreatedByIdExternalFieldName String Specifies the external field name of the 'CreatedById' polymorphic field to use in an INSERT/UPDATE/UPSERT statement
Field String Name of the field on the site record that was changed.
DataType String Type classification for Data.
OldValue String Previous value of the field before the change occurred.
NewValue String Updated value of the field after the change was made.
SOQL String Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.
ExternalIdColumn String Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.
FilterScope String Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.
CreatedDate Datetime Date and time when the change was logged in the history.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434