Excel Add-In for Salesforce

Build 26.0.9770

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.

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.

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.

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.

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

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

RelatedIdExternalFieldName String

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

OwnerIdType String

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

OwnerIdExternalFieldName String

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