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
Other articles:
Anonymous Mode Email
Web Services - Ws - PDocDetailApi.GetPddList
Combining Multiple Docs into One Doc
Billing - DocVacBasic & DocVacGold
Setup Docs
Excel to Consume Web Services
CSV Files
Financial Statement / Table Extraction
Key Term Search with Wildcards
DocVac Dictionary of Jargon

more