(Excel) HTTP PUT JSON

Demonstrates how to send a JSON PUT and get the JSON response body.

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes 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

' The PUT request to be sent will look like this:

' PUT /request HTTP/1.1
' Content-Type: application/jsonrequest
' Cookie: JSESSIONID=1234
' Content-Encoding: identity
' Host: json.penzance.org
' Accept: application/jsonrequest
' Accept-Encoding:
' Content-Length: 72
' 
' {"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"

' Add the Content-Encoding: identity header.
http.SetRequestHeader "Content-Encoding","identity"

' Modify the default "Accept" header:
http.Accept = "application/jsonrequest"


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.


responseBody = http.PutText("http://json.penzance.org/request",jsonText,"utf-8","application/jsonrequest",False,False)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
Else
    ' Display the JSON response.
    Debug.Print responseBody

End If