Chatter Connector

Back Next

Synchronization Task Example

Synchronization
Task Example

Consider a task to read data from Chatter and write data to a flat file.

You need to create a connection before you create a

synchronization

task.

To set up a

synchronization

task in

Data Integration

, perform the following tasks:

Go to

New

Tasks

Select

Synchronization Task

, and click

Create

The New Synchronization Task page appears.

Specify the task name, provide a description, and select the task operation

Insert

Click

The Source tab appears.

Select the source connection, source type, and source object for the task, and click

You can read feed from multiple objects in Chatter.

Select the target connection, target type, and target object for the task, and click

To assign filters to a

synchronization

task, see Data Filters. To select all rows, click

Data Filters

Use the following filter fields to read feeds from feedItem object:

Column Name	Description
Body	The content of the FeedItem.
CommentCount	The number of FeedComments associated with the feed item.
ConnectionId	When a PartnerNetworkConnection makes a change to a record that is tracked, the CreatedBy field contains the ID of the system administrator while the Connection Id contains the ID of the PartnerNetworkConnection that performed the changes. Available if Salesforce to Salesforce is enabled for your organization.
AttachmentPath	Specifies the location where you want to copy the attachment.
ContentDescription	The description of the file to be attached to the feed.
ContentFileName	The name of the file uploaded to the feed.
ContentSize	The size of the file (in bytes) uploaded to the feed.
ContentType	The MIME type of the file uploaded to the feed.
Id	Unique Id to indicate a feed.
InsertedById	ID of the user that added the object to the feed.
IsDeleted	Indicates whether the record has been moved to the Recycle Bin (true) or not (false).
LikeCount	The number of FeedLikes associated with the feed item.
LinkUrl	To post URL on a feed.
ParentId	The ID of the object type to which the FeedItem is related. For example, set this field to a UserId to post to someone’s profile feed, or an AccountId to post to a specific account.
RelatedRecordId	The ID of the ContentVersion object associated with a ContentPost. This field is null for all posts except ContentPost.
Title	The title of the FeedItem.
Type	The type of FeedItem: TrackedChange: A change or group of changes to a tracked field. UserStatus: Automatically generated status when a user adds a post. TextPost: To post a text on a feed. LinkPost: To post an URL on a feed. ContentPost: An uploaded file on a feed. PollPost: Post a poll in the feed to gather opinions. DashboardComponentSnapshot: To Post a dashboard snapshot on a feed. ApprovalPost: Automatically generated by a feed query on an approval item. CollaborationGroupCreated: Automatically generated post on your feed when you creates a public group.
Parent name	Name of the object type to which the FeedItem is related.

Use the following filter fields to get the feed comments from a FeedComment object in Chatter:

Column Name	Description
CommentBody	The text in the comment
CommentType	You can use the following type of comment: ContentComment : the comment that contains an attachment. The Chatter Connector does not support ContentType comment. TextComment – A comment that contains only text.
CommentFeedItemId	The ID of the feed that contains the comment.
CommentInsertedById	The ID of the user who added the object to the feed.
CommentParentId	The ID of the record associated with the feed.
CommentRelatedRecordId	The ID of the ContentVersion object associated with a ContentComment.
CommentCreatedDate	The date and time when the comment was posted.
CommentId	The unique Id of the comment.
CommentAttachmentPath	Location of the file attached to the FeedComment. When you download the attachment and you face an out of memory exception, you must increase the memory.
CommentContentSize	The size of the file attached to the FeedComment.
CommentContentDescription	The description about the attachment.