SSIS Components for Salesforce

Build 25.0.9434

Group

Manages public and private groups used for collaboration and sharing within Salesforce.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the group.

Name String False

Display name of the group.

DeveloperName String False

API name of the group used for development or integration purposes.

RelatedId String True

ID of the related object, such as a queue or role associated with the group.

RelatedIdType String False

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

RelatedIdExternalFieldName String False

Specifies the external field name of the 'RelatedId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

Type String False

Type of the group, such as 'Regular', 'Role', or 'Queue'.

Email String False

Email address associated with the group.

OwnerId String True

ID of the user who owns or manages the group.

OwnerIdType String False

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

OwnerIdExternalFieldName String False

Specifies the external field name of the 'OwnerId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

DoesSendEmailToMembers Bool False

Indicates whether emails are sent to group members (true) or not (false).

DoesIncludeBosses Bool False

Indicates whether managers of group members are automatically included (true) or not (false).

CreatedDate Datetime True

Date and time when the group was created.

CreatedById String True

User.Id

ID of the user who created the group.

LastModifiedById String True

User.Id

ID of the user who last modified the group.

Description String False

Text description of the record.

SOQL String False

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 False

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 False

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.

SystemModstamp Datetime True

Timestamp used by the system to track the last modification.

LastModifiedDate Datetime True

Date and time when the group was last modified.

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