(Excel) HTTP POST JSON

Demonstrates how to send a JSON POST and get the JSON response.

Download Excel Class Modules Chilkat Excel Class Modules

' This requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' This example duplicates the HTTP POST shown at
' http://json.org/JSONRequest.html

' Specifically, the request to be sent looks like this:

' POST /request HTTP/1.1
' Accept: application/jsonrequest
' Content-Encoding: identity
' Content-Length: 72
' Content-Type: application/jsonrequest
' Host: json.penzance.org
' 
' {"user":"doctoravatar@penzance.com","forecast":7,"t":"vlIj","zip":94089}

' First, remove default header fields that would be automatically
' sent.  (These headers are harmless, and shouldn't need to 
' be suppressed, but just in case...)
http.AcceptCharset = ""
http.UserAgent = ""
http.AcceptLanguage = ""
' Suppress the Accept-Encoding header by disallowing 
' a gzip response:
http.AllowGzip = False

' If a Cookie needs to be added..
http.SetRequestHeader "Cookie","JSESSIONID=1234"


jsonText = "{""user"":""doctoravatar@penzance.com"",""forecast"":7,""t"":""vlIj"",""zip"":94089}"

' To use SSL/TLS, simply use "https://" in the URL.

' IMPORTANT: Make sure to change the URL, JSON text,
' and other data items to your own values.  The URL used
' in this example will not actually work.

Set resp = http.PostJson("http://json.penzance.org/request",jsonText)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
Else
    ' Display the JSON response.
    Debug.Print resp.BodyStr

End If