SSIS Components for Salesforce

Build 26.0.9770

DataUsePurposeHistory

Tracks the history of field value changes made to DataUsePurpose records.

Columns

Name Type References Description
Id [KEY] String Unique identifier for the record.
IsDeleted Bool Indicates whether the record has been moved to the Recycle Bin.
DataUsePurposeId String

DataUsePurpose.Id

ID of the DataUsePurpose associated with this record.
CreatedById String

User.Id

ID of the user who created the record.
Field String Field containing Field information.
DataType String Type classification for Data.
OldValue String Field containing OldValue information.
NewValue String Field containing NewValue information.
CreatedDate Datetime Date and time when the record was created.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
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
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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770