Power BI Connector for Salesforce

Build 26.0.9770

CaseSolution

Links solutions to cases, helping support agents provide quick resolutions to customer issues.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the case-solution association record.

CaseId String False

Case.Id

ID of the case linked to the solution.

SolutionId String False

Solution.Id

ID of the solution linked to the case.

CreatedById String True

User.Id

ID of the user who created the association between the case and the solution.

IsDeleted Bool True

Indicates whether the case-solution association record has been deleted (true) or not (false).

SystemModstamp Datetime True

Timestamp for the last system update to the association record.

CreatedDate Datetime True

Date and time when the case-solution association 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
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