DataSourcesFields
Retrieves the field with a specified {ID} for the specific data source.
Workday Resource Information
Retrieves the field with a specified {ID} for the specific data source. You can only view fields and data sources that you have security access to.Secured by: Development, WQL for Workday Extend, Workday Query Language+TG
Scope: System
Aggregate Fields
The cmdlet 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.
OptionalParameters_Aggregate
[{ alias: Text /* This field exposes WQL alias for Adhoc Query Enabled instances in WQL Rest APIs. This is for internal use only. */ description: Text /* Description for Query Parameter for External Promptable */ type: Text /* Returns "Text", "Date", "Numeric", "Currency", "Boolean", "Single Instance" or "Multi Instance". */ workData: { descriptor: Text /* A description of the instance */ href: Text /* A link to the instance */ *id: Text /* wid / id / reference id */ } }]
RelatedFields_Aggregate
[{ alias: Text /* This field exposes WQL alias for Adhoc Query Enabled instances in WQL Rest APIs. This is for internal use only. */ descriptor: Text /* A preview of the instance */ href: Text /* A link to the instance */ id: Text /* Id of the instance */ type: Text /* The type of the field */ }]
RequiredParameters_Aggregate
[{ alias: Text /* This field exposes WQL alias for Adhoc Query Enabled instances in WQL Rest APIs. This is for internal use only. */ description: Text /* Description for Query Parameter for External Promptable */ type: Text /* Returns "Text", "Date", "Numeric", "Currency", "Boolean", "Single Instance" or "Multi Instance". */ workData: { descriptor: Text /* A description of the instance */ href: Text /* A link to the instance */ *id: Text /* wid / id / reference id */ } }]
Columns
Name | Type | Description |
Id [KEY] | String | Id of the instance |
DataSources_Id [KEY] | String | The Workday ID of the DataSources that owns this. |
Alias | String | Supported for: SELECT. WQL Alias Internal |
Descriptor | String | Supported for: SELECT. A preview of the instance |
Href | String | Supported for: SELECT. A link to the instance |
OptionalParameters_Aggregate | String | Supported for: SELECT. A JSON aggregate. Optional Parameters for WQL |
RelatedFields_Aggregate | String | Supported for: SELECT. A JSON aggregate. Related Business Object Fields |
RequiredParameters_Aggregate | String | Supported for: SELECT. A JSON aggregate. Required Parameters for WQL |
Type | String | Supported for: SELECT. Field Type |
Alias_Prompt | String | The alias of the data source field. |
SearchString_Prompt | String | The string to be searched in case insensitive manner within the descriptors of the data source fields. |
Alias_Prompt_For_DataSources | String | Only used when a DataSources_Id filter is not provided. The alias of the data source. |
SearchString_Prompt_For_DataSources | String | Only used when a DataSources_Id filter is not provided. The string to be searched in case insensitive manner within the descriptors of the data sources. |