CData Python Connector for Microsoft SharePoint

Build 24.0.9062

変更履歴

General Changes

DateBuild
Number		Change
Type		Description
10/10/20249049Microsoft SharePointAdded
  • 新たな接続プロパティ、GetColumnsMetadata が追加され、REST スキーマでカラムメタデータを取得する方法を制御できるようになりました。
10/03/20249042Microsoft SharePointAdded
  • 新たな接続プロパティ、IncludeLookupDisplayValueColumns が追加されました。これはREST スキーマのみに適用されます。
08/19/20248997Microsoft SharePointChanged
  • Roles テーブル（SOAP スキーマ）で、Permissions フィールドのデータ型がLONG からSTRING に変更されました。
08/12/20248990Microsoft SharePointAdded
  • AddRoleAssignment、BreakRoleInheritance、およびRemoveRoleAssingment ストアドプロシージャがREST スキーマに追加されました。
07/16/20248963Microsoft SharePointChanged
  • RoleDefinitionBindings ビューにId とPrincipleID からなる複合キーが追加されました。以前はプライマリキーでした。
06/14/20248931Microsoft SharePointChanged
  • デフォルトのAuthScheme がAzureAD に変更されました。

Deprecated
  • OAuth AuthScheme は廃止されました。代わりにAzureAD、AzurePassword、またはAzureServicePrincipalCert を使用する必要があります。
06/13/20248930Microsoft SharePointAdded
  • REST データモデルのRoleAssignmentMember ビューに"PrincipalType" カラムが追加されました。

Changed
  • REST データモデルのAttachments ビューで、"Updated" カラムがvarchar からdatetime に変更されました。
  • REST データモデルのAttachments ビューで、"ItemId" カラムがvarchar からint に変更されました。
  • REST データモデルのFiles ビューで、"Size" カラムがvarchar からlong に変更されました。
  • REST データモデルのFiles ビューで、"TimeCreated" および"TimeLastModified" カラムがvarchar からdatetime に変更されました。
  • REST データモデルのRoleAssignments ビューで、"ItemId" カラムがvarchar からint に変更されました。
  • REST データモデルのRoleAssignmentMember ビューで、複数のカラムがvarchar からint、datetime、boolean に変更されました。
  • REST データモデルのRoleDefinitionBindings ビューで、複数のカラムがvarchar からint、long、boolean に変更されました。
06/12/20248929Microsoft SharePointDeprecated
  • OAuthJWT AuthScheme は廃止されました。

Added
  • AuthSchemes のサポート対象に"AzureServicePrincipalCert" が追加されました。
06/11/20248928Microsoft SharePointRemoved
  • REST スキーマのSubSites ビューからKeepFieldUserResources フィールドが削除されました。
06/08/20248925Microsoft SharePointChanged
  • REST スキーマのRoleAssignments ビューにおけるUpdated カラムのデータ型がVARCHAR からTIMESTAMP に変更されました。

Removed
  • REST スキーマのRoleAssignments ビューから、VARCHAR データ型の重複するPrincipalId カラムが削除されました。
06/05/20248922PythonAdded
  • Python 3.12のサポートが追加されました。
05/24/20248910Microsoft SharePointChanged
  • Users.Id、Users.GroupId、およびGroups.Id のデータ型がVARCHAR からINTEGER に変更されました。
05/09/20248895GeneralChanged
  • 以前はROUND 関数は負の値を受け取りませんでした。その機能は復元されました。
04/09/20248865Microsoft SharePointAdded
  • AddList、AddListColumn、DeleteList、およびDeleteListColumn ストアドプロシージャがREST スキーマに追加されました。
03/27/20248852Microsoft SharePointAdded
  • MaxSelectLength 隠し接続プロパティが追加され、OData $select クエリオプションで許可される最大文字数を制御できるようになりました。この制限を超えた場合、対応するエンティティのエンドポイントに複数のリクエストを行い、各リクエストにカラムのサブセットが含まれるようにして、完全なデータを取得するための最終ステップとしてクライアントサイドでセルフジョインを行います。これは、ユーザーがデータモデルで公開されているリスト、ライブラリ、または多くのカラムを持つ他のエンティティからデータを読み取る際に、生成されたURL がAPI の制限に達する（長すぎる）場合や正しく動作しない可能性がある場合に便利です。
03/15/20248840GeneralAdded
  • Java のString.compare() 機能をSQL クエリに提供するSTRING_COMPARE という新しいSQL 関数が作成されました。2つの文字列の比較値を表す数値を返します。
03/11/20248836Microsoft SharePointAdded
  • 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/20248819Microsoft SharePointChanged
  • 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/20248815Microsoft SharePointChanged
  • Changed endpoint for file retrieval. The ID column in Files view is updated to show the document GUID.
01/22/20248787Microsoft SharePointChanged
  • 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/20248784Microsoft SharePointChanged
  • 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/20248782Microsoft SharePointAdded
  • 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/20238746Microsoft SharePointChanged
  • 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/20238733GeneralChanged
  • 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/20238732GeneralAdded
  • Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
10/24/20238697Microsoft SharePointChanged
  • 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.
08/29/20238641PythonAdded
  • Added support for SQLAlchemy 2.0.
06/30/20238581Microsoft SharePointChanged
  • 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/20238571GeneralAdded
  • Added the new sys_lastresultinfo system table.
05/19/20238539PythonAdded
  • Added support for Python 3.11 on Windows, Linux and Mac.
05/16/20238536PythonRemoved
  • Removed support for Python 3.7 on Windows and Linux
04/25/20238515GeneralRemoved
  • Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
03/01/20238460Microsoft SharePointAdded
  • Added ServerRelativeUrl column in Lists View.
01/19/20238419Microsoft SharePointAdded
  • Added the links on the Connecting to REST API page under Sharepoint Online and Sharepoint OnPremise sections.
12/22/20228391Microsoft SharePointAdded
  • Added RenameAttachmentOrDocument and MoveAttachmentOrDocument Stored Procedures in SOAP and REST Schema.
12/21/20228390Microsoft SharePointChanged
  • Changed the datatype of PertainingToTerm column from Boolean to String in GetValidTerms View.
12/19/20228388Microsoft SharePointAdded
  • 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/20228383GeneralChanged
  • Added the Default column to the sys_procedureparameters table.
12/08/20228377Microsoft SharePointAdded
  • 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/20228369Microsoft SharePointAdded
  • Added UseEntityTypeName property to determine if the table name should be EntityTypeName instead of the title in the REST schema.
11/15/20228354PythonChanged
  • Updated embedded JRE to jre8u345-b01(Linux x64 / MacOS x64) and jre-17.0.5+8(MacOS aarch64).
10/25/20228333Microsoft SharePointAdded
  • 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/20228308GeneralChanged
  • Added the IsPath column to the sys_procedureparameters table.
07/29/20228245Microsoft SharePointRemoved
  • Removed the Enum value Germany from AzureEnvironments as Microsoft has retired its Germany-based cloud.
05/24/20228179Microsoft SharePointChanged
  • Changed provider name to Microsoft SharePoint.
05/19/20228174Microsoft SharePointDeprecated
  • OAuthGrantType has been deprecated. Use the AuthScheme connection property instead.
05/18/20228173PythonAdded
  • Added support for Python 3.10 on Windows, Linux, and Mac
  • Added support for Python 3.9 on Mac
  • Added support for Mac M1

Removed
  • Removed support for Python 3.6 on Windows and Linux
03/15/20228109Microsoft SharePointAdded
  • Added a new Id column for the Users view in the REST Schema.
03/14/20228108Microsoft SharePointAdded
  • Added the ItemId column to get RoleAssignments, RoleAssignmentMember, RoleDefinitionBindings.
09/02/20217915GeneralAdded
  • Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
08/23/20217905Microsoft SharePointAdded
  • Added the stored procedures CreateFolder, UploadDocument, DeleteDocument, CopyDocument, CheckInDocument, CheckOutDocument, DiscardCheckOutDocument, AddAttachment, DeleteAttachment to the REST Schema.
08/10/20217892Microsoft SharePointAdded
  • Added new AuthScheme "SharePointOAuth" to support client credentials flow using SharePoint App.
08/07/20217889GeneralChanged
  • Added the KeySeq column to the sys_foreignkeys table.
08/06/20217888GeneralChanged
  • Added the new sys_primarykeys system table.
08/05/20217887Microsoft SharePointRemoved
  • Removed the Permissions view from the REST schema.

Replacements
  • Replaced Permissions with RoleAssignments, RoleAssignmentMember and RoleDefinitionBindings views in the REST schema.
07/29/20217880Microsoft SharePointAdded
  • Added new columns LoginName, Title, IsHiddenInUI for the Users view and Id for the Groups view in the REST schema.
07/28/20217879Microsoft SharePointAdded
  • Added support for Attachments, Permissions and SubSites views in the REST schema.
07/27/20217878Microsoft SharePointAdded
  • Added support for OAuth Authentication without JWT cert for Client Credentials by when using a SharePoint App.
07/23/20217874GeneralChanged
  • 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.
06/16/20217837Microsoft SharePointAdded
  • Added support for PingFederate identity provider in Sharepoint Online SOAP schema.
06/05/20217826Microsoft SharePointAdded
  • 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/20217785GeneralAdded
  • 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/20217783GeneralChanged
  • 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/20217776GeneralAdded
  • Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
04/16/20217776GeneralChanged
  • Reduced the length to 255 for varchar primary key and foreign key columns.

Changed
  • Updated index naming convention to avoid duplicates.
04/16/20217776GeneralChanged
  • 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/15/20217775GeneralChanged
  • Kerberos authentication is updated to use TCP by default, but will fall back to UDP if a TCP connection cannot be established.
03/31/20217760Microsoft SharePointDeprecated
  • 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/20207612Microsoft SharePointAdded
  • Added support for retrieving information regarding the current logged in user via the GetCurrentUser stored procedure.

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