Over the last several years a group of people have loaded files into Dropbox, manually copied a link to that file from Dropbox browser and stored the link in an external database. Now we have over 700 entries in the database. Some of the links are no longer valid (the dropbox file was deleted) and some are in the wrong directory on Dropbox. And we're continuing to add files and generate links, complete with new human-caused errors.
I'm looking for a programmatic way to validate that each link points to a valid Dropbox file, and get the name and parent directory of the Dropbox file.
I've discovered the Dropbox API, but can't tell if there is a function that will let me supply a link and get back the above data. From reading the documentation it looks to me like FileMetadata and FileMetadata.builder might be what I'm looking for, but I can't tell for sure.
I'm a retired Java programmer and it will be a significant effort for me to get back up to speed with Java, Github, Maven, etc. I'm willing to do this, but before doing so I'd like to have some confidence that what I need is there.
Can anyone offer some advice on this?
Thanks,
Bob