Post JSON to web in excel vba

by

JSON can be very sensitive to how it’s formatted, so I would make sure everything is quoted properly before it is sent. I would recommend splitting Body into a separate variable and debugging the value with http://jsonformatter.curiousconcept.com/ before sending. 

Dim Body As String
Body = "{""mType"":""OPEN_SYSTEM_TRADE"",""systemOwnerId"":10}"

' Set breakpoint here, get the Body value, and check with JSON validator
oHttp.Send Body

I ran into many similar issues when working with Salesforce’s REST API and combined my work into a library that may be useful to you: https://github.com/VBA-tools/VBA-Web. Using this library, your example would look like:

Dim Body As New Dictionary
Body.Add "mType", "OPEN_SYSTEM_TRADE"
Body.Add "systemOwnerId", 10

Dim Client As New WebClient
Dim Response As WebResponse
Set Response = Client.PostJson("somewebsite.com", Body)

Worksheets("Open1").Range("A1").Value = Response.Content

More Related Contents:

  1. Parsing JSON in Excel VBA
  2. Returning Null JSON Throwing Type Mismatch Error in VBA
  3. Excel VBA: Parsed JSON Object Loop
  4. In Excel VBA on Windows, for parsed JSON variables what is this JScriptTypeInfo anyway?
  5. In Excel VBA on Windows, how to get stringified JSON respresentation instead of “[object Object]” for parsed JSON variables?
  6. Handle JSON Object in XMLHttp response in Excel VBA Code
  7. How can I send an HTTP POST request to a server from Excel using VBA?
  8. How to make HTTP Post request with JSON body in Swift
  9. What are the differences between application/json and application/x-www-form-urlencoded?
  10. AngularJS $http-post – convert binary to excel file and download
  11. Retrieving JSON Object Literal from HttpServletRequest
  12. How to parse JSON with VBA without external libraries?
  13. How to receive JSON in a POST request in CherryPy?
  14. HTTP POST with Json on Body – Flutter/Dart
  15. Parsing JSON feed automatically into MS Access
  16. Accessing a request’s body using classic ASP?
  17. Can Server Sent Events (SSE) with EventSource pass parameter by POST
  18. Using VBA and VBA-JSON to access JSON data from WordPress API
  19. Do the JSON keys have to be surrounded by quotes?
  20. Is There a JSON Parser for VB6 / VBA?
  21. Loop through each cell in a range of cells when given a Range object
  22. jq not working on tag name with dashes and numbers
  23. Checking for #N/A in Excel cell from VBA code
  24. Non-web SQL Injection
  25. Create a folder and sub folder in Excel VBA
  26. How to not marshal an empty struct into JSON with Go?
  27. Break out of a While…Wend loop
  28. How to make safe API Timers in VBA?
  29. Range.Find not making a difference between January and November (February and December) in VBA Excel
  30. How to use jackson to deserialize to Kotlin collections

Leave a Comment