Excel Add-In for Salesforce

Build 26.0.9770

CustomReportType

Defines a custom report type used as the basis for creating reports on selected objects and fields.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the record.

MasterLabel String False

Master display label of the record, used as the default label before translation.

DeveloperName String False

Unique name of the record used by the API and managed packages, containing only underscores and alphanumeric characters.

Description String False

Description of the record.

OptionsFlagIsDeployed Bool False

Indicates whether the “Flag Is Deployed” option is enabled.

OptionsFlagIsAutoGenerated Bool False

Indicates whether the “Flag Is Auto Generated” option is enabled.

OptionsFlagIsHidden Bool False

Indicates whether the “Flag Is Hidden” option is enabled.

Category String False

Category under which the custom report type is grouped.

NamespacePrefix String True

Namespace prefix of the managed package that contains this record, if any.

CreatedDate Datetime True

Date and time when the record was created.

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.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin (true) or not (false).

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.

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