SSIS Components for Salesforce

Build 26.0.9770

RecommendationResponse

Records a user's response, such as accept or dismiss, to a recommendation.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

OnBehalfOf String False

Field containing OnBehalfOf information.

OnBehalfOfType String True

Type classification for OnBehalfOf.

OnBehalfOfName String True

Field containing OnBehalfOfName information.

NetworkId String False

Network.Id

ID of the Experience Cloud site associated with this record.

RecommendationKey String False

Field containing RecommendationKey information.

RecommendationType String True

Type classification for Recommendation.

RecommendationName String False

Field containing RecommendationName information.

ActionReference String False

Field containing ActionReference information.

Response String False

Field containing Response information.

StrategyReference String False

Field containing StrategyReference information.

StrategyVersion String True

Field containing StrategyVersion information.

ContextRecord String False

Field containing ContextRecord information.

ContextRecordType String True

Type classification for ContextRecord.

ContextRecordName String True

Field containing ContextRecordName information.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record was last modified.

CreatedDate Datetime True

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
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