Alexis Valdez
asked on
VBA for CRUD in consuming an API (Web Service)
MS Access VBA modules to Create, Read, Update, Delete (CRUD) using API (Web Service) via odata or SOAP protocol. This project is particularly consuming an MSD (Microsoft Dynamics) APIs.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
The term " API (Web Service)" makes no sense. Cause everything can be an API.
So you may rephrase your question, please.
But: Consuming a REST or SOAP service is better done in .Net.
While you can consume REST and SOAP services by using MSXML and XMLHTTP60, you may stumble upon:
- A service in the Dynamics environment may have some higher requirements for authentication.
- SOAP can get very fast very complex because of its XML content.
- REST often supports only JSON, there is no native support for that in VBA. And parsing JSON isn't also that easy.
But you can do it.
SOAP:
Open in new window
A call to a REST service looks pretty much the same, but is shorter, cause you don't need to exchange messages. E.g. like here.