| Date | Build
Number | Change
Type | Description |
| 10/10/2024 | 9049 | SharePoint | Added
- Added a new connection property, GetColumnsMetadata, to control how column metadata is retrieved in the REST schema.
|
| 10/03/2024 | 9042 | SharePoint | Added
- Added a new connection property, IncludeLookupDisplayValueColumns, which is only applicable for the REST schema.
|
| 08/19/2024 | 8997 | SharePoint | Changed
- In the Roles table (SOAP schema), changed the datatype of the Permissions field from LONG to STRING.
|
| 08/12/2024 | 8990 | SharePoint | Added
- Added the following stored procedures to the REST schema: AddRoleAssignment, BreakRoleInheritance, and RemoveRoleAssingment.
|
| 07/16/2024 | 8963 | SharePoint | Changed
- The RoleDefinitionBindings view now has a composite key consisting of both Id and PrincipleID. Formerly it had a primary key.
|
| 06/14/2024 | 8931 | SharePoint | Changed
- Changed AzureAD to the default AuthScheme.
Deprecated
- Deprecated the OAuth AuthScheme. AzureAD, AzurePassword, or AzureServicePrincipalCert should be used instead.
|
| 06/13/2024 | 8930 | SharePoint | Added
- Added "PrincipalType" column to the RoleAssignmentMember view in the REST data model.
Changed
- In the Attachments view in the REST data model, changed the "Updated" column from varchar to datetime.
- In the Attachments view in the REST data model, changed the "ItemId" column from varchar to int.
- In the Files view in the REST data model, changed the "Size" column from varchar to long.
- In the Files view in the REST data model, changed the "TimeCreated" and "TimeLastModified" columns from varchar to datetime.
- In the RoleAssignments view in the REST data model, changed the "ItemId" column from varchar to int.
- In the RoleAssignmentMember view in the REST data model, changed various columns from varchar to int, datetime, or boolean.
- In the RoleDefinitionBindings view in the REST data model, changed various columns from varchar to int, long, or boolean.
|
| 06/12/2024 | 8929 | SharePoint | Deprecated
- Deprecated the OAuthJWT AuthScheme.
Added
- Added "AzureServicePrincipalCert" to the supported AuthSchemes.
|
| 06/11/2024 | 8928 | SharePoint | Removed
- Removed the KeepFieldUserResources field from the SubSites view in the REST schema.
|
| 06/08/2024 | 8925 | SharePoint | Changed
- Changed the data type of the Updated column in the RoleAssignments view from VARCHAR to TIMESTAMP in the REST schema.
Removed
- Removed the duplicate PrincipalId column with the VARCHAR data type from the RoleAssignments view in the REST schema.
|
| 05/24/2024 | 8910 | SharePoint | Changed
- Changed data type of Users.Id, Users.GroupId, and Groups.Id from VARCHAR to INTEGER.
|
| 05/09/2024 | 8895 | General | Changed
- The ROUND function previously did not accept negative precision values. That feature has now been restored.
|
| 04/09/2024 | 8865 | SharePoint | Added
- Added the AddList, AddListColumn, DeleteList, and DeleteListColumn stored procedures to the REST Schema.
|
| 03/27/2024 | 8852 | SharePoint | Added
- Added the MaxSelectLength hidden connection property to control the maximum number of characters allowed in the OData $select query option. If the limit is exceeded we will make multiple requests to the endpoint for the corresponding entity where each request contains a subset of the columns and we will perform a self join client-side as a final step to get the full data. This is useful in cases when the user is reading data from lists, libraries, or other entities exposed in our data model that have many columns and where the generated URL might hit an API limit (too long) or may not work correctly.
|
| 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
|
| 03/11/2024 | 8836 | SharePoint | Added
- Enabled the ShowPredefinedColumns connection property for the REST schema. The property behaves similarly to the SOAP schema. If set to false, all columns derived from a base type will be removed from the column listing.
|
| 02/23/2024 | 8819 | SharePoint | Changed
- Renamed the UploadDocument and CopyDocument outputs using standard names. _dlc_DocId and _dlc_DocIdUrl have been renamed to DocumentId and DocumentIdUrl respectively.
Removed
- Removed the ReturnID input for the UploadDocument and CopyDocument stored procedures. The document metadata will be returned by default.
- Removed the MetadataName# and MetadataValue# inputs. The operations initiated by these inputs can be called by using UPDATE and SELECT queries with the outputted Id of the document.
- Removed the vti_author and vti_etag outputs.
|
| 02/19/2024 | 8815 | SharePoint | Changed
- Changed endpoint for file retrieval. The ID column in Files view is updated to show the document GUID.
|
| 01/22/2024 | 8787 | SharePoint | Changed
- Changed the default behavior of including linked columns. Linked columns are used to facilitate deep inserts which is not valuable for SharePoint lists, so linked columns will not be included by default.
|
| 01/19/2024 | 8784 | SharePoint | Changed
- Reimplemented the UseDisplayNames feature for the REST schema due to the many differences between the OData metadata and the API that is used to retrieve the display names. Column data types may change to match the OData metadata since the OData standard is used for all list operations.
- Enabled the ShowHiddenColumns connection property for the REST schema. Hidden columns are not shown by default, to match the behavior of the SOAP schema. An extra call is needed to achieve this which may affect performance. Set ShowHiddenColumns to true to switch to the old behavior.
|
| 01/17/2024 | 8782 | SharePoint | Added
- Added the Permanently parameter to the DeleteDocument stored procedure (REST schema) for triggering different behaviors. Enabling it will delete the document specified permanently, whereas disabling it will move the document to the recycle bin instead (default behavior).
Removed
- Removed the RelativeURL and DocumentName parameters from the DeleteDocument stored procedure (REST schema).
Replaced
- Replaced the RelativeURL and DocumentName parameters of the DeleteDocument stored procedure (REST schema) with the Path parameter.
|
| 12/12/2023 | 8746 | SharePoint | Changed
- Added 'Success' as a standard output for all stored procedures to indicate whether the execution was successful or not. The output is a Boolean and replaces the 'Result' and 'Status' outputs.
|
| 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/09/2023 | 8713 | cis | Changed
- Salesforce with SSO Adapter reports the Double type as Doule type instead of Decimial type
- Salesforce with SSO Adapter supports create a table with Clob type column. The Clob type is mapped to Salesforce LongTextArea field.
|
| 10/24/2023 | 8697 | SharePoint | Changed
- The default value for the hidden connection property IncludeReferenceColumn for the REST data model has changed to false and the ParentReference columns is no longer listed by default.
|
| 06/30/2023 | 8581 | SharePoint | Changed
- Enabled UseDisplayNames connection property for the REST schema, enabling this will return the display name as the column name and may affect performance and change the column data type.
|
| 06/20/2023 | 8571 | General | Added
- Added the new sys_lastresultinfo system table.
|
| 04/25/2023 | 8515 | General | Removed
- Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
|
| 03/01/2023 | 8460 | SharePoint | Added
- Added ServerRelativeUrl column in Lists View.
|
| 01/19/2023 | 8419 | SharePoint | Added
- Added the links on the Connecting to REST API page under Sharepoint Online and Sharepoint OnPremise sections.
|
| 12/22/2022 | 8391 | SharePoint | Added
- Added RenameAttachmentOrDocument and MoveAttachmentOrDocument Stored Procedures in SOAP and REST Schema.
|
| 12/21/2022 | 8390 | SharePoint | Changed
- Changed the datatype of PertainingToTerm column from Boolean to String in GetValidTerms View.
|
| 12/19/2022 | 8388 | SharePoint | Added
- Add support for the ReadTimeout option to the download stored procedures in the REST schema. ReadTimeout can be used to force a download to fail after a certain time, unlike Timeout which only triggers if the download stalls for that amount of time.
|
| 12/14/2022 | 8383 | General | Changed
- Added the Default column to the sys_procedureparameters table.
|
| 12/08/2022 | 8377 | SharePoint | Added
- Added the WriteToFile parameter for CreateSchema stored procedure in SOAP schema. This defaults to true and must be disabled to write the schema to FileStream or FileData.
Removed
- Removed SchemaDirectory parameter from CreateSchema stored procedure in SOAP schema. Instead, the Location connection property path will be used to create the schema.
|
| 11/30/2022 | 8369 | SharePoint | Added
- Added UseEntityTypeName property to determine if the table name should be EntityTypeName instead of the title in the REST schema.
|
| 10/25/2022 | 8333 | SharePoint | Added
- Added the FileStream input attribute to add outputstream and FileData output attribute to print the response in DownloadAttachment, DownloadDocument stored procedures in SOAP and REST schema.
- Added the FileStream input attribute to add outputstream and FileData output attribute to print the response in CreateSchema stored procedure in SOAP schema.
- Added the Content input attribute to add inputstream in AddAttachment, UploadDocument stored procedures in SOAP and REST schema.
|
| 09/30/2022 | 8308 | General | Changed
- Added the IsPath column to the sys_procedureparameters table.
|
| 07/29/2022 | 8245 | SharePoint | Removed
- Removed the Enum value Germany from AzureEnvironments as Microsoft has retired its Germany-based cloud.
|
| 05/24/2022 | 8179 | SharePoint | Changed
- Changed provider name to Microsoft SharePoint.
|
| 05/19/2022 | 8174 | SharePoint | Deprecated
- OAuthGrantType has been deprecated. Use the AuthScheme connection property instead.
|
| 03/15/2022 | 8109 | SharePoint | Added
- Added a new Id column for the Users view in the REST Schema.
|
| 03/14/2022 | 8108 | SharePoint | Added
- Added the ItemId column to get RoleAssignments, RoleAssignmentMember, RoleDefinitionBindings.
|
| 09/02/2021 | 7915 | General | Added
- Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
|
| 08/23/2021 | 7905 | SharePoint | Added
- Added the stored procedures CreateFolder, UploadDocument, DeleteDocument, CopyDocument, CheckInDocument, CheckOutDocument, DiscardCheckOutDocument, AddAttachment, DeleteAttachment to the REST Schema.
|
| 08/10/2021 | 7892 | SharePoint | Added
- Added new AuthScheme "SharePointOAuth" to support client credentials flow using SharePoint App.
|
| 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.
|
| 08/05/2021 | 7887 | SharePoint | Removed
- Removed the Permissions view from the REST schema.
Replacements
- Replaced Permissions with RoleAssignments, RoleAssignmentMember and RoleDefinitionBindings views in the REST schema.
|
| 07/29/2021 | 7880 | SharePoint | Added
- Added new columns LoginName, Title, IsHiddenInUI for the Users view and Id for the Groups view in the REST schema.
|
| 07/28/2021 | 7879 | SharePoint | Added
- Added support for Attachments, Permissions and SubSites views in the REST schema.
|
| 07/27/2021 | 7878 | SharePoint | Added
- Added support for OAuth Authentication without JWT cert for Client Credentials by when using a SharePoint App.
|
| 06/16/2021 | 7837 | SharePoint | Added
- Added support for PingFederate identity provider in Sharepoint Online SOAP schema.
|
| 06/05/2021 | 7826 | SharePoint | Added
- Added support for the AzureServicePrinciple authentication scheme only using a JWT certs instead of the OAuthClientSecret.
- Added support to authenticate submitting JWT certs instead of the OAuthClientSecret for the AzureServicePrinciple, OAuth and AzureAD authentication schemes.
|
| 04/25/2021 | 7785 | General | Added
- Added support for handling client side formulas during insert / update. For example: UPDATE Table SET Col1 = CONCAT(Col1, " - ", Col2) WHERE Col2 LIKE 'A%'
|
| 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 | Added
- Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
|
| 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/15/2021 | 7775 | General | Changed
- Kerberos authentication is updated to use TCP by default, but will fall back to UDP if a TCP connection cannot be established.
|
| 03/31/2021 | 7760 | SharePoint | Deprecated
- The UseSSO connection property is deprecated. You should select the preferred SSO scheme directly from the AuthScheme property instead.
- The URNAddress is deprecated. This property is used inside the SSOProperties and it should be specified when authenticating to ADFS on Sharepoint On-Premise. Instead RelyingParty should be used as in other drivers.
|
| 11/03/2020 | 7612 | SharePoint | Added
- Added support for retrieving information regarding the current logged in user via the GetCurrentUser stored procedure.
|