Release Notes
On this page you can find what's new in SharePoint Online Connector.
| Date | Description |
|---|---|
| 2025-04-24 | New - Added support for Certificate Authentication (Sign JWT using Certificate File / Private Key - *.p12, *.pem, *.pfx). |
| 2025-04-24 | Fix - list_folders endpoint look for *.xls files rather than folders. |
| 2025-02-11 | Modified - Beautified PowerShell script in Application Credentials authentication instructions. |
| 2025-01-30 | New - Sorted Files and Folders in Dropdown selection on UI, also included full path rather than name. |
| 2025-01-30 | New - Added webUrlPath column in many endpoints, which list Files and folders. This path included a relative path after /Documents/ part in webUrl |
| 2025-01-30 | New - Reduced Folder selection dropdown limit to 200 items to load UI faster. |
| 2025-01-30 | New - Added new endpoint copy_item to copy file or folder. |
| 2025-01-30 | New - Added new endpoint move_rename_item to move or rename file or folder. |
| 2024-01-24 | New - Added granting SharePoint permissions to app using PowerShell in authentication instructions. |
| 2024-12-19 | Fix - Default search type (recursive) fails in Application Credentials, now non-recursive is enforced if its Application credentials. |
| 2024-12-19 | New - Added a default value and a new option to Redirect URL parameter in User Credentials authentication (https://zappysys.com/oauth). |
| 2024-12-19 | Modified - Updated authentication instructions with explanatory images. |
| 2024-12-19 | Fix - Made Redirect URL parameter required in User Credentials authentication (https://zappysys.com/oauth). |
| 2024-10-22 | New - (*.xls) Legacy Excel Format (Office 97-2003) not listed in various excel endpoints e.g. list_excel_worksheets / get_excel_worksheet_autodetect. |
| 2024-10-22 | New - Show additional columns for list_excel_worksheets (new columns are ID, Position, Visible). |
| 2024-10-22 | New - Use ID rather than Name for SheetId parameter in get_excel_worksheet and get_excel_worksheet_autodetect endpoints to allow to rename of tab with not getting error. |
| 2024-10-22 | New - Added a new parameter ContinueOn404Error in many endpoints to allow 404 file not found error. |
| 2024-10-22 | New - Added a new tables FileReaderWriterCsv / FileReaderWriterJson to support CSV / JSON data Read/Write scenarios. |
| 2024-10-22 | New - Added a new endpoints create_csv_file, create_json_file to write CSV and JSON file data using rows / columns mapping. |
| 2024-10-22 | New - Added a new endpoints get_csv_file, get_json_file to read CSV and JSON file data using rows/columns mapping (without downloading to local disk). |
| 2024-10-22 | New - Added retry on error code 423 (File is locked). |
| 2024-10-22 | New - Added a new option (UseSourceFileTimeStamp) to set Created/Modified on Uploaded file same as Source File in upload_file endpoint. By default, Upload time is used to set Creation/Modified date on target file after upload is done. |
| 2024-10-22 | New - Added a new option (ConflictBehavior) in upload_file endpoint to replace/rename if target file exists. |
| 2024-10-22 | New - Added a new connection level options (ExtraHeaders and SearchOptionForNonIndexedFields). |
| 2024-10-22 | New - Added a new SearchPath option for list_files, list_folders, list_excel_files endpoints. |
| 2024-10-22 | New - Added a new SearchType option with Recursive and Non-Recursive scan modes for list_files, list_folders, list_excel_files endpoints. |
| 2024-10-22 | New - Added a new OrderBy parameter for list_files, list_folders, list_excel_files endpoints. |
| 2024-10-22 | New - Added a ODataType fields to allow Update / Insert for Multi Select Choice, Lookup, PersonOrGroup Field types. When you set multi value choice set MyFieldNameODataType along with Value. Example: [MyMultiChoiceFieldOdataType]='Collection(Edm.String)'. For Lookup/PersonOrGroup Edm type must be Edm.Int32 and for Choice must be Edm.String. Other values not allowed in this field. |
| 2024-10-22 | New - Added Insert / Update option for Multi Select Choice Field (Previously not possible) - Must set MyMultiChoiceField='["AA","BB"]' and [MyMultiChoiceFieldOdataType]='Collection(Edm.String)' both fields. |
| 2024-10-22 | New - Added a Default Drive Id parameter at connection level, Updated Auth SiteId Param to have extra option entry (root). |
| 2024-10-22 | New - Added a UseRawCache option in get_list_fields to avoid duplicate API calls and fetch Columns metadata faster. |
| 2024-04-18 | New - Dynamic columns of SharePoint Lookup fields in "insert_list_item" and "update_list_item" endpoints are now RAW. |
| 2023-08-23 | New - Allow CRUD operations on ListItems Table (e.g. Allow Insert, Update, Delete, Lookup). |
| 2023-08-23 | New - Added new endpoint get_excel_worksheet_autodetect so user doesn't need Address Range (Dynamically detect max rows and columns for data read. |
| 2023-06-19 | New - Fixed typo in example description. |
| 2023-04-12 | New - Added 'Filter' parameter to 'get_list_items' and 'get_list_items_dynamic' endpoints" |
| 2023-03-28 | New - Updated examples and added two new tables - "Sites" and "Drives" |
| 2023-02-24 | New - Updated upload_file endpoint to refresh DriveId dropdown on UI when SiteId changes |
| 2023-01-06 | New - Added Retry for API Limit errors (status code 429 or 503) |
| 2023-01-06 | New - Added Login Prompt option (e.g. Force Login Prompt for new account). |
| 2022-12-02 | New - Added SystemLists table. Removed readonly columns from 'create_list_item' and 'update_list_item' endpoints. |
| 2022-11-23 | New - Added support for Lookup type columns/fields when inserting and updating a list. |
| 2022-09-19 | New - Added support for Lookup and Managed Metadata fields. If user needs to expand specific fields then they can set expand parameters for complex types. |
| 2022-06-02 | New - Added new endpoint get_list_items_dynamic to read complex datatypes (e.g. Lookup, Location). Other endpoint will show null value in such case use this one. |
| 2022-03-16 | New - Added ContinueOn404Error option for get_list_item endpoint (read single list item by ID) to prevent error if ID is bad. |
| 2022-02-24 | New - Added 'SiteId' parameter to 'upload_file' endpoint. |
| 2022-01-27 | New - Added server side WHERE clause support for ListItem Id column for SELECT, UPDATE and DELETE operations for faster response / lookup operations |
| 2022-01-27 | New - Added download_file_to_disk endpoint to download a file |
| 2022-01-27 | New - Added support for very large file upload |
| 2021-10-05 | New - Made parameter "expand" configurable |
| 2021-10-05 | New - Changed comments in examples |
| 2021-03-29 | New - Initial version |