Power BI Connector for Workday

Build 25.0.9454

CasesCommentQuestionnaireResponseQuestionAnswerPair

Reads /questionnaireResponse/questionAnswerPair entries from the CasesComment table.

Workday Resource Information

Retrieves a comment timeline item for a case with the specified comment timeline ID. Comment timeline items include comments and associated attachments.

Secured by: Help Case Data, Self Service: Help Case Management

Scope: Help

Contains attachment(s)

Aggregate Fields

The connector represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is. Fields marked with a hyphen are read-only and must not be included when calling stored procedures or when performing an INSERT or UPDATE.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

Attachments_Aggregate


[{
  comment: Text /* Questionnaire attachment comment */
  fileName: Text /* File name of the attachment */
  href: Text /* A link to the instance */
  id: Text /* Id of the instance */
}]

Columns

Name Type Description
CasesComment_Id String The Workday ID of the CasesComment that contains this.
Cases_Id String The Workday ID of the Cases that owns this.
Answer String Answer text.
Attachments_Aggregate String Questionnaire Attachments.
Question String Question body.
Desc_Prompt Bool If true, sorts results in descending order.
Flag_Prompt String Retrieves cases with the assigned flag(s).
Label_Prompt String Retrieves cases with the assigned label(s).
MyCases_Prompt Bool Retrieves cases owned by the processing user.
OpenCases_Prompt Bool Retrieves open cases and cases that were resolved or canceled less than 7 days ago.
Sort_Prompt String The field to sort results by. The default is creationDate. Note: Currently supports creationDate only.
Status_Prompt String Retrieves cases with the specified status(es).
Substatus_Prompt String Retrieves cases with the specified substatus(es).
Team_Prompt String Retrieves cases with the specified service team(s).

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