Easy way to connect to SharePoint lists and files stored on a SharePoint/OneDrive

[DIVIDESbyZER0]

What inspired this wish list request? Challenges with establishing the ability to pull data from SharePoint lists and/or files stored on sharepoint.  SharePoint is a tool that is used for managing tasks and incoming work.  There are several instances where we would like to be able to pull from these lists to use the data for metrics and dashboards.  Connecting to the lists and having the ability to pull in files (.jmp, .xlxs, .csv) that are stored on the SharePoint is very important to use.

What is the improvement you would like to see? 

Something similar to what is available to Google Docs to allow easy access to import SharePoint lists and documents stored on a SharePoin

Why is this idea important? 

To ensure metrics are accurate and up to date.

[Sarah-Sylvestre]

Hi @DIVIDESbyZER0, thank you for your suggestion! We have captured your request and will take it under consideration.

[wilt0041]

To work with JMP documents saved on Sharepoint, we found that syncing the Sharepoint site to our computer works well. Then you can access the files in Windows file explorer - the same as any locally stored file. 

https://support.microsoft.com/en-us/office/sync-sharepoint-files-and-folders-87a96948-4dd7-43e4-aca1...

Now just need a way to lock files so that multiple users do not open the same file and edit it then have to save copies