JDBC Driver for Workday

Build 23.0.8839

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 本製品 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


[{
  description: Text /* Description for Query Parameter for External Promptable */
  type: Text /* Returns "Text", "Date", "Numeric", "Currency", "Boolean", "Single Instance" or "Multi Instance". */
  alias: Text /* This field exposes WQL alias for Adhoc Query Enabled instances in WQL Rest APIs. This is for internal use only. */
  workData: {
     *id: Text /* wid / id / reference id */
      descriptor: Text /* A description of the instance */
      href: Text /* A link to the instance */
  }
}]

RelatedFields_Aggregate


[{
  alias: Text /* This field exposes WQL alias for Adhoc Query Enabled instances in WQL Rest APIs. This is for internal use only. */
  type: Text /* The type of the field */
  id: Text /* Id of the instance */
  href: Text /* A link to the instance */
  descriptor: Text /* A preview of the instance */
}]

RequiredParameters_Aggregate


[{
  description: Text /* Description for Query Parameter for External Promptable */
  type: Text /* Returns "Text", "Date", "Numeric", "Currency", "Boolean", "Single Instance" or "Multi Instance". */
  alias: Text /* This field exposes WQL alias for Adhoc Query Enabled instances in WQL Rest APIs. This is for internal use only. */
  workData: {
     *id: Text /* wid / id / reference id */
      descriptor: Text /* A description of the instance */
      href: Text /* A link to the instance */
  }
}]

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839