SSIS Components for Salesforce

Build 26.0.9770

ContractFeed

Captures Chatter activity, including posts and updates, related to Contract records.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the contract feed item.

ParentId String True

Contract.Id

ID of the contract record associated with this feed item.

Type String True

Type of feed item, such as TextPost, ContentPost, or LinkPost.

CreatedById String True

User.Id

ID of the user who created the feed item.

IsDeleted Bool True

Indicates whether the feed item has been deleted (true) or not (false).

CommentCount Int True

Total number of comments on the feed item.

LikeCount Int True

Total number of likes on the feed item.

Title String True

Title of the feed item, typically used for content or link posts.

Body String True

Main content or message of the feed item.

LinkUrl String True

URL associated with a link-type feed item.

IsRichText Bool True

Indicates whether the content contains rich text formatting.

RelatedRecordId String True

ContentVersion.Id

ID of a record related to this feed item, such as a referenced document or task.

InsertedById String True

User.Id

ID of the user who originally inserted the feed item, which may differ from the creator in some cases.

NetworkScope String True

ID of the Experience Cloud site that this feed item is scoped to, if any.

Visibility String True

Indicates who can see this feed item, such as AllUsers or InternalUsers.

BestCommentId String True

FeedComment.Id

ID of the comment marked as the best comment.

SystemModstamp Datetime True

System-generated timestamp for tracking the last modification.

LastModifiedDate Datetime True

Date and time when the feed item was last modified.

CreatedDate Datetime True

Date and time when the feed item 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

InsertedByIdType String

Specifies the type of the 'InsertedById' polymorphic field to use in the statement.

InsertedByIdExternalFieldName String

Specifies the external field name of the 'InsertedById' 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