'FileMaker Pro and Onedrive
I have been tasked with a unique filemaker pro problem and was hoping I could get help with. My company wants to place an excel file on onedrive and for that file to connect to a FM database, meaning when the excel is edited, the database is updated/edited, is this possible?
Solution 1:[1]
Yep. You can use Microsoft's API to read the file on OneDrive and reimport it into a FileMaker table if it changed.
This can be done with a FileMaker server schedule, running as frequently as you want. (Every 20 minutes?)
Solution 2:[2]
Take a look at DBServices sample file here: https://dbservices.com/blog/filemaker-onedrive-integration
This covers everything from Creating a folder, uploading & downloading files from OneDrive!
The rest is pretty much scripting to compare files / timestamps.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | bruderdog |
| Solution 2 | Geniewave |