CARDDAV call to get list of contacts (all properties) as VCF file

Can someone PLEASE share an example on how to call the standard Contacts dav addressbook to extract all the contact info in 1 file - I want to call it using VBA to add all contacts to a spreadsheet for bulk editing. I managed to access info using XML calls via the OCS API, but this one… (I tried the PROPFIND method, successfully authenticate but from there cannot get any details extracted).

  1. Is there a way I can UPDATE specific contacts via the API yet?

Many thanks.