OneDrive Connector
Documentation
Version: 9
Documentation

Release notes


On this page you can find what's new in OneDrive Connector.
Date Description
2025-05-12 Modified - Removed Sites.Read.All and Sites.ReadWrite.All scopes from selection.
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-01-30 New - Added two new tables Users and UserDrives.
2025-01-30 New - Sorted Files and Folders in Dropdown selection on UI for many endpoints, 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.
2025-01-30 New - Added ConvertTo option to download_file endpoint to convert supported files to PDF or HTML format.
2024-12-17 New - Added support for Test connection (Previously it was not doing correct way).
2024-12-17 New - Added support for "App Credentials" authentication (You can now List/Read/Write files from other User's or Group's Drive (Shared Drive)).
2024-12-17 New - Added a default value and a new option to Redirect URL parameter in User Credentials authentication (https://zappysys.com/oauth)
2024-12-17 Modified - Updated authentication instructions with explanatory images.
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 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 new endpoint list_files for recursive / non-recursive scan.
2024-10-22 New - Allow Lookup Operation (By ID Param) in Files Table (e.g. SELECT * FROM Files WHERE Id='Abxxx12').
2024-10-22 New - Allow File/Folder ID or Path in most endpoints.
2024-10-22 New - Added an option to select See Shared DriveId (Dropdown on UI) along with User DriverId (me) in list_files / list_folder and many other endpoints.
2024-10-22 New - Added an option to list files / folders Shared With Me (new SearchType option).
2024-10-22 New - Added new tables Files and Folders (default DriveId=me).
2024-10-22 New - Added a new Default DriveId (default=me) parameter at connection level.
2023-08-23 New - Added new endpoint get_excel_worksheet_autodetect so user doesnt need Address Range (Dynamically detect max rows and columns for data read.
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).
2021-11-11 New - Initial version