Tableau Connector for Workday

Build 23.0.8839

CasesTimelineQuestionnaireResponseQuestionAnswerPair

Reads questionnaireResponse.questionAnswerPair entries from the CasesTimeline table

Workday Resource Information

Retrieves a timeline item for a case with the specified timeline ID. Comment timeline items include comments and associated attachments. Action timeline items include an action with an action text. Creation timeline items include a description, associated attachments and a questionnaire answer if applicable.

Secured by: REST API Public

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.

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


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

Columns

Name Type Description
CasesTimeline_Id String The Wordkay ID of the CasesTimeline that contains this
Cases_Id String The Workday ID of the Cases that owns this
Answer String Supported for: SELECT. Answer text.
Attachments_Aggregate String Supported for: SELECT. A JSON aggregate. Questionnaire Attachments.
Question String Supported for: SELECT. Question body.
Desc_Prompt Boolean Only used when a Cases_Id filter is not provided. If true, sorts results in descending order.
MyCases_Prompt Boolean Only used when a Cases_Id filter is not provided. Retrieves cases owned by the processing user.
OpenCases_Prompt Boolean Only used when a Cases_Id filter is not provided. Retrieves open cases and cases that were resolved or canceled less than 7 days ago.
Sort_Prompt String Only used when a Cases_Id filter is not provided. The field to sort results by. The default is creationDate. Note: Currently supports creationDate only.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839