ODBC Driver for Workday

Build 24.0.9060

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 driver 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


[{
  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
CasesTimeline_Id [KEY] String The Workday ID of the CasesTimeline that contains this.
Cases_Id [KEY] 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 Bool Only used when a Cases_Id filter is not provided. If true, sorts results in descending order.
MyCases_Prompt Bool Only used when a Cases_Id filter is not provided. Retrieves cases owned by the processing user.
OpenCases_Prompt Bool 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 24.0.9060