Developer

Andy Brown

<div>
Thank you Shaun - sorry for taking so long to come back to you (I've been away). &nbsp;I had come up with a fix - but will have a look at this as it looks really helpful.<br />
<br />
Thanks again.
</div>


Thank you Shaun - sorry for taking so long to come back to you (I've been away).  I had come up with a fix - but will have a look at this as it looks really helpful.

Thanks again.

<div>
<div class="content wysiwyg-content">
Using VBA - I need to write a REST/POST command with JSON parameters. &nbsp;However, I can't seem to find a simple example that I can follow. &nbsp;Does anyone have anything?
</div>
</div>


Using VBA - I need to write a REST/POST command with JSON parameters.  However, I can't seem to find a simple example that I can follow.  Does anyone have anything?

VBA - Writing a REST/POST command with JSON parameters.

A Web service is a method of communication between two electronic devices over a network. It is a software function provided at a network address over the Web with the service always on as in the concept of utility computing. A web service has an interface described in Web Services Description Language (WSDL). Other systems interact with the Web service in a manner prescribed by its description using SOAP (Simple Object Access Protocol) messages. There are two major classes of Web services: REST-compliant web services, and Arbitrary web services.

Web Services

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Representational state transfer (REST) is an architectural style that gives a coordinated set of constraints to the design of components in a distributed hypermedia system used to design networked applications. RESTful systems typically communicate over Hypertext Transfer Protocol (HTTP) with the same HTTP verbs (GET, POST, PUT, DELETE, etc.) that web browsers use to retrieve web pages and to send data to remote servers. REST interfaces with external systems using resources identified by Uniform Resource Identifier (URI) that can be operated upon using standard verbs.

REST

JavaScript Object Notation, or JSON, is human-readable text used when transmitting data objects consisting of attribute:value pairs between a server and a web application as an alternative to XML. JSON, while it is originally derived from JavaScript, is a language-independent data format. Code for parsing and generating JSON data is available in many programming languages.