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