SharePoint Online Connector
Documentation
Version: 19
Documentation

Release notes


On this page you can find what's new in SharePoint Online Connector.
Date Description
2025-05-12 Modified - Removed Sites.Read, Sites.ReadWrite scopes from selection (Microsoft Graph API does not support them anymore).
2025-05-12 New - Added response caching for get_excel_worksheet and get_excel_worksheet_autodetect endpoints for better speed and reduced API calls.
2025-05-12 New - Added an option for get_excel_worksheet and get_excel_worksheet_autodetect to read the formatted text values, formulas and raw values (Default is raw values). This option is useful for datetime values, which are otherwise returned as numeric serial values (e.g. 44563.25) rather than formatted date time (e.g. 01/03/2022 06:00).
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