| |
| Date | Build
Number | Change
Type | Description |
| 09/10/2024 | 9019 | Workday | Changed
- Updated the default SOAP API version in the WSDLVersion connection property to v42.2.
- Updated the REST API schema to reflect version 20240907 of the API.
Added
- Added several tables and views to the REST schema.
|
| 08/29/2024 | 9007 | Workday | Removed
- Removed support for the AuthScheme=Auto setting. The default AuthScheme is now set to OAuth. If using SOAP, set AuthScheme=Basic to maintain the previous behavior. No changes are required for other services.
|
| 08/05/2024 | 8983 | Workday | Added
- Added a new stored procedure, CreateWQLSchema, which enables users to create tables in the driver that execute specific WQL in Workday. The new stored procedure can be used with the Workday Convert Report to WQL task to get the same data as the report, but with better performance than the Reports service.
|
| 07/23/2024 | 8970 | Workday | Added
- Added support for setting effective dates in the SOAP API using the new As_Of_Effective_Date_RespFilter prompt column.
|
| 06/28/2024 | 8945 | Workday | Added
- Added the connection property IncludeRESTTenantFields, which enables the driver to fetch and merge tenant-specific schemas with the shared schema. This exposes additional fields unique to your Workday tenants. Note that due to API limintations, tenant-specific schema merges with the shared schema is only supported for top-level tables and their children. It is not supported for tables requiring an owner ID to access schemas.
|
| 06/14/2024 | 8931 | Workday | Added
- Added support for complex multi-value prompt values in the SOAP API. See "Aggregate Prompts" in the Data Model page for an example of a new prompt and how to use it.
|
| 05/20/2024 | 8906 | Workday | Changed
- Workday previously reported time values as text when using the WQL service. Now the driver parses them internally and reports them as actual time values.
Added
- Added support in the WQL service for time functions like HOUR().
|
| 05/15/2024 | 8901 | Workday | Changed
- The driver now defaults to using Workday API v42.1 for the SOAP service. To use a previous version of the API, set the WSDLVersion property to the desired version. For Workday's list of API updates or deprecations, see https://community.workday.com/current/wsrelnotes.
|
| 05/09/2024 | 8895 | General | Changed
- The ROUND function previously did not accept negative precision values. That feature has now been restored.
|
| 05/02/2024 | 8888 | Workday | Added
- Updated REST API schemas to the 20240427 version of the API.
|
| 03/27/2024 | 8852 | Workday | Deprecated
- The APIURL connection property for SOAP.
Replacements
- If the APIURL points to the base of the SOAP API (https://impl.workday.com/ccx/service/mytenant), set the Tenant and BaseURL to access all SOAP services.
- Otherwise, if the APIURL points to a specific SOAP service (https://impl.workday.com/ccx/service/mytenant/Human_Resources), set the Tenant, BaseURL, and Service to restrict what services are available on the connection.
|
| 03/15/2024 | 8840 | General | Added
- Created a new SQL function called STRING_COMPARE that provides java's String.compare() ability to SQL queries. Returns a number representative of the compared value of two strings
|
| 02/27/2024 | 8823 | Workday | Added
- Added support for the SingleEntryTables property. This property can be used to change how the driver handles collection tables in the SOAP API. Please refer to the documentation of the property for more information and examples.
|
| 02/16/2024 | 8812 | Workday | Added
- Added support for general REST stored procedures. Before the only stored procedures were BeginXXXChange and SubmitXXXChange for managing bulk changes. Now every REST endpoint that accepts POST and is not associated with an existing table is available as its own stored procedure.
|
| 01/03/2024 | 8768 | Workday | Added
- Added support for SupportNativeDataType. Java-based editions can enable this property with ConnectionType=WQL to see native WQL type names in column metadata.
|
| 11/29/2023 | 8733 | General | Changed
- The ROUND function doesn't accept the negative precision values anymore.
Changed
- The returning types of the FDMonth, FDQuarter, FDWeek, LDMonth, LDQuarter, LDWeek functions are changed from Timestamp to Date.
- The return type of the ABS function will be consistent with the parameter value type.
|
| 11/28/2023 | 8732 | General | Added
- Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
|
| 11/28/2023 | 8732 | Workday | Added
- Updated REST API schemas to the 20231111 version of the API, with the following updates for specific components.
- Person API: Move from v3 to v4
- Staffing API: Move from v5 to v6
|
| 10/04/2023 | 8677 | Workday | Added
- Added support for REST change processes: Organization Assignment Changes, Job Changes, Work Contact Information Changes, and Home Contact Information Changes. Each of these change processes has Begin/Submit stored procedures as well as associated tables for changing the process's inputs.
- Added support for navigating hierarchical categories within REST values tables. These tables now expose a collection token which can be used to read the subcategories of the current category.
|
| 09/13/2023 | 8656 | Workday | Added
- Added the WQLDataSourceFilters property. This allows overriding the driver's choice of data source filter for WQL views.
|
| 08/22/2023 | 8634 | Workday | Changed
- Updated REST API schemas to the 20230819 version of the API, with the following updates for specific components.
- Person API: Move from v2 to v3
- Staffing API: Move from v4 to v5
- Updated the DataSourcesFields API to support multiple optional and required parameters. Earlier definitions of this table reported flattened optional and require parameters fields, while in current versions they are aggregates.
|
| 07/27/2023 | 8608 | Workday | Added
- Added the SplitSingleValuePrompts property for all connection types. This allows the driver to split queries that provide multiple values for single value prompts. Each combination of split prompt values is executed separately and combined within the driver.
|
| 07/10/2023 | 8591 | Workday | Added
- Added the IncludeIDInDescriptor property for WQL. When enabled, the driver will report descriptor columns as containing the description and the ID, instead of just the ID.
Changed
- WQL descriptors are reported as combined ID and description values, as per the IncludeIDInDescriptor property.
|
| 07/07/2023 | 8588 | Workday | Added
- Added support for reporting more child tables when the parent table is an inner collection, like StudentGradingSchemes_Student_Grade_Data.
- Added the IncludeChildTableAggregates property to control whether child tables appear only as child tables, or as child tables and aggregates on their parent table. By default aggregates are exposed in addition to child tables.
|
| 07/05/2023 | 8586 | Workday | Added
- Added the BaseURL property. This has the same function as the Host property.
Deprecated
- The Host property. Existing connections using it will still work, but new connections should use the BaseURL property instead.
|
| 06/29/2023 | 8580 | PowerShell Cmdlets | Removed
- Removed support for .NET 2.0
|
| 06/29/2023 | 8580 | Workday | Added
- Added support for the REST API.
Removed
- The UseWQL connection property.
Replacements
- The ConnectionType connection property replaces the UseWQL property. Each service (WQL, Reports, REST, SOAP) has its own ConnectionType and only one can be used per connection. This means that WQL and RaaS can no longer be used together as separate schemas on the same connection.
|
| 06/20/2023 | 8571 | General | Added
- Added the new sys_lastresultinfo system table.
|
| 05/12/2023 | 8532 | Workday | Added
- Added support for simple SOAP filter criteria. These are given using _Prompt columns as in WQL and RaaS.
|
| 05/09/2023 | 8529 | Workday | Added
- Added support for AzureAD authentication.
|
| 04/25/2023 | 8515 | General | Removed
- Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
|
| 02/07/2023 | 8438 | Workday | Added
- Added support for OAuth JWT authentication, and enhanced the documentation around the process of creating ISUs and configuring their authentication. The driver supports both OAuthJWT for ISUs using a normal API Client as well as OAuth with an API Client for Integrations.
- Added support for OAuth authentication (both authorization code and JWT) to SOAP. SOAP now supports every authentication method that WQL/RaaS do as well as Basic authentication. Basic authentication remains the default for SOAP.
|
| 12/14/2022 | 8383 | General | Changed
- Added the Default column to the sys_procedureparameters table.
|
| 12/05/2022 | 8374 | Workday | Added
- Added support for ExpandMultiValues. When enabled, multi-instance ID values are expanded into multiple rows so that individual IDs can be read without parsing JSON or XML aggregates. This also applies to single-instance ID values when using Reports as a Service without ExpandIDTypes.
|
| 09/30/2022 | 8308 | General | Changed
- Added the IsPath column to the sys_procedureparameters table.
|
| 08/31/2022 | 8278 | Workday | Added
- Added support for ExpandIDTypes. When enabled, ID values in reports are reported as multiple columns (one per ID type) instead of one XML aggregate column.
|
| 08/03/2022 | 8250 | Workday | Added
- Improved performance around WQL metadata fetching. The driver can fetch table and field listings in parallel which is significantly faster for larger data sources like workers.
- Added support for WQL prompts and data source filters. Prompt support works the same way as reports. Data source filters currently have limited support, they are only used when required and the driver will automatically pick one to use.
|
| 05/17/2022 | 8172 | Workday | Added
- Added support for accessing Reports as a Service (RaaS). RaaS reports can be queried by setting the UseWQL connection property to true (default), and providing the driver with a report that lists out all RaaS-accessible reports via the CustomReportURL connection property. The driver has support for setting prompt values as well as flattening complex report values.
|
| 05/03/2022 | 8158 | Workday | Added
- Added support for the WQL API. The WQL API is newer than the SOAP API from Workday, and has far better support for metadata, limiting service results, filtering, and server side operations such as aggregation and grouping.
Changed
- Changed the default API from SOAP to WQL. This can be configured via the UseWQL connection property.
|
| 09/21/2021 | 7934 | Workday | Changed
- Changed the default primary key column for the Learning.LearningLessons table. Removed the Learning_Lesson_Reference_WID column as it does not appear to actually come back.
|
| 09/10/2021 | 7923 | Workday | Changed
- Changed the default primary key column for the Learning.LearningPrograms and LearningPrograms child tables. Removed the Learning_Program_Reference_WID column as it does not appear to actually come back.
|
| 09/02/2021 | 7915 | General | Added
- Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
|
| 08/27/2021 | 7909 | Workday | Changed
- Changed the default primary key column for the Learning.LearningDigitalCourses and LearningDigitalCourses child tables. Removed the Learning_Digital_Course_Reference_WID column as it does not appear to actually come back.
|
| 08/07/2021 | 7889 | General | Changed
- Added the KeySeq column to the sys_foreignkeys table.
|
| 08/06/2021 | 7888 | General | Changed
- Added the new sys_primarykeys system table.
|
| 07/23/2021 | 7874 | General | Changed
- Updated the Literal Function Names for relative date/datetime functions. Previously, relative date/datetime functions resolved to a different value when used in the projection as opposed to the predicate. For example: SELECT LAST_MONTH() AS lm, Col FROM Table WHERE Col > LAST_MONTH(). Formerly, the two LAST_MONTH() methods would resolve to different datetimes. Now, they will match.
- As a replacement for the previous behavior, the relative date/datetime functions in the criteria may have an 'L' appended to them. For example: WHERE col > L_LAST_MONTH(). This will continue to resolve to the same values that were previously calculated in the criteria. Note that the "L_" prefix will only work in the predicate - it not available for the projection.
|
| 05/26/2021 | 7816 | Workday | Changed
- The default WSDLVersion has been updated to v36.1.
|
| 04/23/2021 | 7783 | General | Changed
- Updated how display sizes are determined for varchar primary key and foreign key columns so they will match the reported length of the column.
|
| 04/16/2021 | 7776 | General | Changed
- Reduced the length to 255 for varchar primary key and foreign key columns.
Changed
- Updated index naming convention to avoid duplicates.
|
| 04/16/2021 | 7776 | General | Changed
- Updated implicit and metadata caching to improve performance and support for multiple connections. Old metadata caches are not compatible - you need to generate new metadata caches if you are currently using CacheMetadata.
|
| 04/16/2021 | 7776 | PowerShell Cmdlets | Added
- Added support for PowerShell 7.
|
| 03/02/2021 | 7731 | Workday | Changed
- Made a significant performance improvement. Retrieval for multiple pages of data is now ~4-5x faster.
|