ODBC Driver for Workday

Build 24.0.9060

Cases

Retrieves a list of cases that the user is secured to view.

Workday Resource Information

Retrieves a case with the specified ID. Case details include: title, detailed message, case ID, status, creation date, case link, assignee, confidential, about, by, for, type, and serviceTeam.

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

Scope: Help

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


[{
  contentType: { /* Content type of the attachment */
     *id: Text /* wid / id / reference id */
  }
  descriptor: Text /* A preview of the instance */
  fileLength: Numeric /* File length of the attachment */
  fileName: Text /* File name of the attachment */
  id: Text /* \~Case\~ Attachment ID. */
}]

QuestionnaireResponses_QuestionnaireAnswers_Aggregate


[{
  answerDate: Date /* The answer in a date format. */
  answerMultipleChoices: [{
      descriptor: Text /* A preview 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 /* A preview of the instance */
  id: Text /* Id of the instance */
  questionItem: { /* Question Item for Questionnaire Answer. Question item represents the question in a questionnaire. */
     *id: Text /* wid / id / reference id */
  }
  questionnaireAttachments: [{
      contentType: { /* Content type of the attachment */
         *id: Text /* wid / id / reference id */
      }
      descriptor: Text /* A preview 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

Id of the instance

AboutWorker_Id String False

Supported for: INSERT. wid / id / reference id

About_Descriptor String False

Supported for: SELECT. A preview of the instance

About_Id String False

Supported for: SELECT. Id of the instance

About_Person_Descriptor String False

Supported for: SELECT. A description of the instance

About_Person_Href String False

Supported for: SELECT. A link to the instance

About_Person_Id String False

Supported for: SELECT. wid / id / reference id

Assignee_Descriptor String False

Supported for: SELECT. A preview of the instance

Assignee_Id String False

Supported for: SELECT. Id of the instance

Assignee_Person_Descriptor String False

Supported for: SELECT. A description of the instance

Assignee_Person_Href String False

Supported for: SELECT. A link to the instance

Assignee_Person_Id String False

Supported for: SELECT. wid / id / reference id

Attachments_Aggregate String False

Supported for: INSERT. A JSON aggregate. Case Creation Attachments.

By_Descriptor String False

Supported for: SELECT. A preview of the instance

By_ExternalCreator_Email String False

Supported for: SELECT. External Case Creator Email.

By_ExternalCreator_Id String False

Supported for: SELECT. Id of the instance

By_ExternalCreator_Name String False

Supported for: SELECT. External Case Creator Name and External in Parenthesis or Purged External Case Creator text.

By_Id String False

Supported for: SELECT. Id of the instance

By_Worker_Descriptor String False

Supported for: SELECT. A preview of the instance

By_Worker_Id String False

Supported for: SELECT. Id of the instance

By_Worker_Person_Descriptor String False

Supported for: SELECT. A description of the instance

By_Worker_Person_Href String False

Supported for: SELECT. A link to the instance

By_Worker_Person_Id String False

Supported for: SELECT. wid / id / reference id

CaseID String False

Supported for: SELECT, INSERT. Case ID.

CaseLink String False

Supported for: SELECT, INSERT. The link to view the Case.

CaseType_Id String False

Supported for: INSERT. wid / id / reference id

Confidential Bool False

Supported for: SELECT. If true, the case is confidential.

CreationDate Datetime False

Supported for: SELECT. The date that the case was created on.

DetailedMessage String False

Supported for: SELECT, INSERT. The description of the case.

ForExternalCreator_Id String False

Supported for: INSERT. wid / id / reference id

ForWorker_Id String False

Supported for: INSERT. wid / id / reference id

For_Descriptor String False

Supported for: SELECT. A preview of the instance

For_ExternalCreator_Email String False

Supported for: SELECT. External Case Creator Email.

For_ExternalCreator_Id String False

Supported for: SELECT. Id of the instance

For_ExternalCreator_Name String False

Supported for: SELECT. External Case Creator Name and External in Parenthesis or Purged External Case Creator text.

For_Id String False

Supported for: SELECT. Id of the instance

For_Worker_Descriptor String False

Supported for: SELECT. A preview of the instance

For_Worker_Id String False

Supported for: SELECT. Id of the instance

For_Worker_Person_Descriptor String False

Supported for: SELECT. A description of the instance

For_Worker_Person_Href String False

Supported for: SELECT. A link to the instance

For_Worker_Person_Id String False

Supported for: SELECT. wid / id / reference id

FormattedCreationDate String False

Supported for: SELECT. The creation date of the case formatted to include the year, month, day, hour and minute. The date format depends on the processing user's locale and uses the user's timezone.

QuestionnaireHolder_Id String False

Supported for: INSERT. wid / id / reference id

QuestionnaireResponses_Descriptor String False

Supported for: INSERT. A preview of the instance

QuestionnaireResponses_Id String False

Supported for: INSERT. Id of the instance

QuestionnaireResponses_QuestionnaireAnswers_Aggregate String False

Supported for: INSERT. A JSON aggregate. The set of answers for a questionnaire.

QuestionnaireResponses_QuestionnaireTargetContext_Id String False

Supported for: INSERT. wid / id / reference id

QuestionnaireResponses_QuestionnaireTarget_Id String False

Supported for: INSERT. wid / id / reference id

ServiceTeam_Descriptor String False

Supported for: SELECT. A description of the instance

ServiceTeam_Href String False

Supported for: SELECT. A link to the instance

ServiceTeam_Id String False

Supported for: SELECT. wid / id / reference id

Source_Id String False

Supported for: INSERT. wid / id / reference id

Status_Descriptor String False

Supported for: SELECT, INSERT. A preview of the instance

Status_Id String False

Supported for: SELECT, INSERT. Id of the instance

Title String False

Supported for: SELECT, INSERT. The title of the case.

Type_Confidential Bool False

Supported for: SELECT. Case type confidential flag for REST service.

Type_Description String False

Supported for: SELECT. Case Type Description.

Type_Id String False

Supported for: SELECT. Id of the instance

Type_Inactive Bool False

Supported for: SELECT. True if the case type is inactive.

Type_Name String False

Supported for: SELECT. Returns the display id of the instance.

Type_ServiceCategory_Description String False

Supported for: SELECT. The description of the service category.

Type_ServiceCategory_Id String False

Supported for: SELECT. Id of the instance

Type_ServiceCategory_Name String False

Supported for: SELECT. The name of the service category.

Desc_Prompt Bool False

If true, sorts results in descending order.

MyCases_Prompt Bool False

Retrieves cases owned by the processing user.

OpenCases_Prompt Bool False

Retrieves open cases and cases that were resolved or canceled less than 7 days ago.

Sort_Prompt String False

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