I want to display a multi-folder gallery of our publicly available photos held on OneDrive in conjunction with filename-keyed text (captions, descriptions, etc) currently held on a MySql DB. There seemed two possible approaches:
Launch OneDrive's viewer from a companion JavaScript document and use their document title (contains the filename), to display the details in an 'always-on-top' window. Problem: not sure if its possible to access the title.
Alternative solution: extract and store OneDrive's file "paths" and use these to feed a separate gallery app. Unfortunately, these tags seem to be time limited. Clearly in an application like this, I can't expect casual users to log in.
Doing my head in here and seemingly frustrated at every turn! Anyone got any ideas how it could be achieved?
You should do some research and learn how to interface with One Drive's official API.
https://dev.onedrive.com/README.htm
Ideally you'd be able to use their own API to query for the data you need. They even have a JavaScript file picker SDK.