In Apps script library with plugins for multiple backend cache platforms I covered a way to get more into cache and property services, and the bmCrusher library came with built in plugins for Drive, CacheService and PropertyService. Google Cloud Storage platform cache plugin for Apps Script crusher showed how to extend this concept to other back end platforms, using Google Cloud Storage as the service. In this article I’ll show you how to write a plugin to use Microsoft One Drive as the backend
Benefits of using Microsoft OneDrive
Seems pretty crazy, right ? What’s the point when we have Cloud Storage, Property Service, Cache service and even Google Drive. Well, there’s this emerging goodie. Microsoft’s answer to Apps Script – maybe the next installment in the evolution of VBA, Office Script . I’ve written about JavaScript for Office in various posts on this site, and of course plenty about VBA (even a book about it), but Office Script is quite different. I’ll be writing about that quite a bit in coming posts. But to get back to the point – having a universal cache platform to share real time data easily between the Apps Script and Office script world sounds like it would be interesting. So that’s what this is leading to. We can also use much of the same code to read and write content directly to OneDrive for other stuff.
In Apps script library with plugins for multiple backend cache platforms I covered a way to get more into cache and property services, and the bmCrusher library came with built in plugins for Drive, CacheService and PropertyService. Google Cloud Storage platform cache plugin for Apps Script crusher showed how to extend this concept to other back end platforms, using Google Cloud Storage as the service. In this article I’ll show you how to write a plugin to use Microsoft One Drive as the backend
Benefits of using Microsoft OneDrive Seems pretty crazy, right ? What’s the point when we have Cloud Storage, Property Service, Cache service and even Google Drive. Well, there’s this emerging goodie. Microsoft’s answer to Apps Script – maybe the next installment in the evolution of VBA, Office Script . I’ve written about JavaScript for Office in various posts on this site, and of course plenty about VBA (even a book about it), but Office Script is quite different. I’ll be writing about that quite a bit in coming posts. But to get back to the point – having a universal cache platform to share real time data easily between the Apps Script and Office script world sounds like it would be interesting. So that’s what this is leading to. We can also use much of the same code to read and write content directly to OneDrive for other stuff.
https://ramblings.mcpher.com/apps-script/apps-script-cache-crusher/onedrive-gas-cache/ Links bmCrusher library id: 1nbx8f-kt1rw53qbwn4SO2nKaw9hLYl5OI3xeBgkBC7bpEdWKIPBDkVG0 Github: https://github.com/brucemcpherson/bmCrusher Scrviz: https://scrviz.web.app/?repo=brucemcpherson/bmCrusher
cGoa library id: 1v_l4xN3ICa0lAW315NQEzAHPSoNiFdWHsMEwj2qA5t9cgZ5VWci2Qxv2 Github: https://github.com/brucemcpherson/cGoa Scrviz: https://scrviz.web.app/?repo=brucemcpherson/cGoa