(Excel) HTTP POST JSON (application/json)

Demonstrates how to send a JSON POST using the application/json content-type.

Download Excel Class Modules Chilkat Excel Class Modules

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

' If any custom headers need to be included with the POST, add them
' by calling SetRequestHeader

' Note: An application should never explicitly set the Content-Length header.
' The Content-Length is automatically computed and added by Chilkat.

' Here are some examples of custom headers.  

' Perhaps your particular app needs some sort of custom-computed Authorization header...
http.SetRequestHeader "Authorization","my-custom-computed-auth-value"

' Another custom header for some hypothetical app:
http.SetRequestHeader "X-Pass-Timestamp","my-custom-computed-timestamp-value"

' We don't need to set the Content-Type header, becaue it is automatically set by Chilkat
' in the PostJson2 call below.

' The following "Accept" header may be set, but it really isn't necessary:
http.SetRequestHeader "Accept","application/json"


jsonText = "{ some JSON text ... }"

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

Set resp = http.PostJson2("http://www.someserver.com/someJsonEndpoint","application/json",jsonText)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
Else
    ' Display the JSON response.
    Debug.Print resp.BodyStr

End If