Power BI Connector for Workday

Build 25.0.9454

Requests

Retrieves details for a specific request using its unique ID.

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

QuestionnaireResponses_QuestionnaireAnswers_Aggregate


[{
  answerDate: Date /* The answer in a date format. */
  answerMultipleChoices: [{
      descriptor: Text /* The display name of the instance */
      id: Text /* Id of the instance */
  }]
  answerNumeric: Numeric /* The answer in a numeric format. */
  answerText: Text /* The text answer for a questionnaire. */
  descriptor: Text /* The display name of the instance */
  id: Text /* Id of the instance */
  questionItem: { /* Question Item for Questionnaire Answer. Question item represents the question in a questionnaire. */
     -descriptor: Text /* The display name of the instance */
     -href: Text /* A link to the instance */
     *id: Text /* wid / id / reference id */
  }
  questionnaireAttachments: [{
      contentType: { /* Content type of the attachment */
         -descriptor: Text /* The display name of the instance */
         -href: Text /* A link to the instance */
         *id: Text /* wid / id / reference id */
      }
      descriptor: Text /* The display name of the instance */
      fileLength: Numeric /* File length of the attachment */
      fileName: Text /* File name of the attachment */
      id: Text /* Id of the instance */
  }]
}]

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier for the instance, typically a Workday ID or reference ID used to track the record.

Comment String False

The most recent comment related to the request event, providing additional context or information.

CompletionDate Datetime False

The date when the request was fully completed or resolved.

Description String False

A detailed description of the request, offering a clear overview of its purpose and content.

Descriptor String False

The display name of the instance

Href String False

A URL link to the specific instance, allowing direct access to the record in the system.

Initiator_Descriptor String False

The display name of the instance

Initiator_Href String False

A URL link to the profile or record of the initiator of the request.

Initiator_Id String False

The unique identifier for the individual who initiated the request, typically their Workday ID or reference ID.

OnBehalfOf_Descriptor String False

The display name of the instance

OnBehalfOf_Href String False

A URL link to the profile or record of the person or entity the request is on behalf of.

OnBehalfOf_Id String False

The unique identifier for the person or entity the request is being made on behalf of.

QuestionnaireResponses_BusinessProcessType_Descriptor String False

The display name of the instance

QuestionnaireResponses_BusinessProcessType_Href String False

A link to the business process type instance for the questionnaire responses.

QuestionnaireResponses_BusinessProcessType_Id String False

The unique identifier for the business process type tied to the questionnaire responses.

QuestionnaireResponses_CreationDate Datetime False

The date when the questionnaire response was created or submitted.

QuestionnaireResponses_Descriptor String False

The display name of the instance

QuestionnaireResponses_Id String False

The unique identifier for the questionnaire response instance.

QuestionnaireResponses_QuestionnaireAnswers_Aggregate String False

An aggregate set of answers provided for the questionnaire, summarizing the responses.

QuestionnaireResponses_QuestionnaireResponseStatus_Descriptor String False

The display name of the instance

QuestionnaireResponses_QuestionnaireResponseStatus_Href String False

A link to the status record of the questionnaire response.

QuestionnaireResponses_QuestionnaireResponseStatus_Id String False

The unique identifier for the status of the questionnaire response.

QuestionnaireResponses_QuestionnaireTargetContext_Descriptor String False

The display name of the instance

QuestionnaireResponses_QuestionnaireTargetContext_Href String False

A link to the context or target record related to the questionnaire response.

QuestionnaireResponses_QuestionnaireTargetContext_Id String False

The unique identifier for the context or target associated with the questionnaire response.

QuestionnaireResponses_QuestionnaireTarget_Descriptor String False

The display name of the instance

QuestionnaireResponses_QuestionnaireTarget_Href String False

A link to the target or item record related to the questionnaire response.

QuestionnaireResponses_QuestionnaireTarget_Id String False

The unique identifier for the target or item associated with the questionnaire response.

QuestionnaireResponses_TotalScore Decimal False

The total score of the questionnaire response, calculated as the sum of individual answers' scores.

RequestDate Datetime False

The date when the request business process was initially started.

RequestEvent_Descriptor String False

The display name of the instance

RequestEvent_Href String False

A URL link to the specific event record related to the request.

RequestEvent_Id String False

The unique identifier for the request event instance.

RequestID String False

A unique identifier for the request, used to track and reference the request within the system.

RequestId_2 String False

A secondary identifier for the request, typically based on an ID generator format.

RequestType_Descriptor String False

The display name of the instance

RequestType_Href String False

A URL link to the specific request type record.

RequestType_Id String False

The unique identifier for the request type instance.

ResolutionDetails_Descriptor String False

The display name of the instance

ResolutionDetails_Href String False

A link to the resolution details record for the request.

ResolutionDetails_Id String False

The unique identifier for the resolution details associated with the request.

Resolution_Descriptor String False

The display name of the instance

Resolution_Href String False

A link to the record that describes the resolution for the request.

Resolution_Id String False

The unique identifier for the resolution instance associated with the request.

Status_Descriptor String False

The display name of the instance

Status_Href String False

A URL link to the status record of the request.

Status_Id String False

The unique identifier for the status instance of the request.

Subtype_Descriptor String False

The display name of the instance

Subtype_Href String False

A link to the subtype record associated with the request.

Subtype_Id String False

The unique identifier for the subtype of the request.

WorkdayObjectValue_Descriptor String False

The display name of the instance

WorkdayObjectValue_Href String False

A link to the Workday object record tied to the request.

WorkdayObjectValue_Id String False

The unique identifier for the Workday object associated with the request.

CompletedOnOrAfter_Prompt Date False

A prompt to filter requests completed on or after the specified date.

CompletedOnOrBefore_Prompt Date False

A prompt to filter requests completed on or before the specified date.

InitiatedOnOrAfter_Prompt Date False

A prompt to filter requests initiated on or after the specified date.

InitiatedOnOrBefore_Prompt Date False

A prompt to filter requests initiated on or before the specified date.

Initiator_Prompt String False

The Workday ID of the person who initiated the request. This can be used to query for the worker's WID through the /common service.

OnBehalfOf_Prompt String False

The Workday ID of the individual the request is being made on behalf of.

RequestId_Prompt String False

The unique ID of the request, typically based on an ID generator format.

RequestSubtype_Prompt String False

The Workday ID of the request subtype. Multiple requestSubtype parameters can be specified for filtering.

RequestType_Prompt String False

The Workday ID of the request type. Multiple requestType parameters can be specified for filtering.

ResolutionDetails_Prompt String False

The Workday ID of the resolution details associated with the request. Multiple resolutionDetails parameters can be specified for filtering.

Resolution_Prompt String False

The Workday ID of the resolution of the request. Multiple resolution parameters can be specified for filtering.

WorkdayObjectValue_Prompt String False

The Workday ID of the business object related to the request, providing context about the object involved in the request.

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