Excel to Consume Web Services
Excel 2016 (at least Windows version) can be used to consume Document Vacuum web services:
Data - New Query - From Other Sources - From Web
Select Advanced
Url parts : 1st box enter https://documentvacuum.com, 2nd box enter /PDocDetailApi/GetPddList?id=999&identityColumn=PDocId where 999 is a valid integer value (pDocId) for one of your documents.
There's an option to open the file as Json and under Data Source Settings - Global Permissions you can select https://documentvacuum.com and under Type:Basic enter your user name and password.
Last modified: 4/14/2021
more