Reads /status/availableStatuses entries from the Cases table.

Workday Resource Information

Retrieves a list of case details that the user is secured to view. 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, Self Service: Help Case Management

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

Substatuses_Aggregate

[{
  id: Text /* Id of the instance */
  name: Text /* The name of the \~case\~ substatus. */
}]

Columns

Name	Type	Description
Id [KEY]	String	Id of the instance
Cases_Id [KEY]	String	The Workday ID of the Cases that contains this.
Name	String	The name of the case status.
Substatuses_Aggregate	String	The substatuses of the case status.
Desc_Prompt	Bool	If true, sorts results in descending order.
Flag_Prompt	String	Retrieves cases with the assigned flag(s).
Label_Prompt	String	Retrieves cases with the assigned label(s).
MyCases_Prompt	Bool	Retrieves cases owned by the processing user.
OpenCases_Prompt	Bool	Retrieves open cases and cases that were resolved or canceled less than 7 days ago.
Sort_Prompt	String	The field to sort results by. The default is creationDate. Note: Currently supports creationDate only.
Status_Prompt	String	Retrieves cases with the specified status(es).
Substatus_Prompt	String	Retrieves cases with the specified substatus(es).
Team_Prompt	String	Retrieves cases with the specified service team(s).