I noticed indexer-plugin.db has file paths for locally stored instances
Is it possible to retrieve file path for an instance using API?
no 
Hello,
Please check out the following FAQ: How does Orthanc store its database? — Orthanc Book documentation
Regards,
Sébastien-