SSIS Components for Workday

Build 23.0.8839

RequestsQuestionnaireResponsesQuestionnaireAnswers

Reads questionnaireResponses.questionnaireAnswers entries from the Requests table

Workday Resource Information

Retrieves the specified request, including the completed questionnaire associated to it. Returned results are secured based on the processing person's View access to the request.

Secured by: Core Navigation

Scope: Adaptive Planning for Financial Plans, Adaptive Planning for the Workforce, Tenant Non-Configurable

Aggregate Fields

The 本製品 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.

QuestionnaireAttachments_Aggregate


[{
  fileName: Text /* File name of the attachment */
  contentType: { /* Content type of the attachment */
     *id: Text /* wid / id / reference id */
      descriptor: Text /* A description of the instance */
      href: Text /* A link to the instance */
  }
  fileLength: Numeric /* File length of the attachment */
  descriptor: Text /* A preview of the instance */
  id: Text /* Id of the instance */
}]

Columns

Name Type Description
Id [KEY] String Id of the instance
Requests_Id [KEY] String The Wordkay ID of the Requests that contains this
AnswerDate Datetime Supported for: SELECT. The answer in a date format.
AnswerMultipleChoiceOrder String Supported for: SELECT. The Question Multiple Choice Answer Order for Questionnaire Answer (REST API)
AnswerMutlipleChoice_Descriptor String Supported for: SELECT. A description of the instance
AnswerMutlipleChoice_Href String Supported for: SELECT. A link to the instance
AnswerMutlipleChoice_Id String Supported for: SELECT. wid / id / reference id
AnswerNumeric Decimal Supported for: SELECT. The answer in a numeric format.
AnswerText String Supported for: SELECT. The text answer for a questionnaire.
Branching Bool Supported for: SELECT. Is Answer for a Branching Question
Descriptor String Supported for: SELECT. A preview of the instance
QuestionBody String Supported for: SELECT. The question body for a questionnaire answer in rich text. Used in REST services only.
QuestionItem_Descriptor String Supported for: SELECT. A description of the instance
QuestionItem_Href String Supported for: SELECT. A link to the instance
QuestionItem_Id String Supported for: SELECT. wid / id / reference id
QuestionOrder String Supported for: SELECT. The Question Item Order for Questionnaire Answer (REST API)
QuestionnaireAttachments_Aggregate String Supported for: SELECT. A JSON aggregate. Questionnaire Attachments for Questionnaire Response.
CompletedOnOrAfter_Prompt Date No description available
CompletedOnOrBefore_Prompt Date No description available
InitiatedOnOrAfter_Prompt Date No description available
InitiatedOnOrBefore_Prompt Date No description available
Initiator_Prompt String Accepts multiple inputs. The WID for the person who initiated the request. You can GET /workers in the /common service to retrieve a worker's WID.
OnBehalfOf_Prompt String The Workday ID of the person this request is being initiated on behalf of.
RequestId_Prompt String The ID of the request based on the ID generator format.
RequestSubtype_Prompt String Accepts multiple inputs. The Workday ID of the request subtype. You can specify more than 1 requestSubtype query parameter.
RequestType_Prompt String Accepts multiple inputs. The Workday ID of the request type. You can specify more than 1 requestType query parameter.
ResolutionDetails_Prompt String Accepts multiple inputs. The Workday ID of the resolution details. You can specify more than 1 resolutionDetails query parameter.
Resolution_Prompt String Accepts multiple inputs. The Workday ID of the resolution of the request. You can specify more than 1 resolution query parameter.
WorkdayObjectValue_Prompt String Accepts multiple inputs. The Workday ID of the business object associated with the request.

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