(Excel) HttpPostJson2 Example

Demonstrates use of the HttpPostJson2 method.

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

'  See PostJson2Async Example for the async equivalent of this example.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

'  Sends a POST equivalent to the following CURL command:

'  curl -X POST https://sandbox.plaid.com/institutions/get \
'    -H 'content-type: application/json' \
'    -d '{
'      "client_id": String,
'      "secret":String,
'      "count": Number,
'      "offset": Number
'    }'

'  Suppress some default headers that would automatically added..
http.AcceptCharset = ""
http.UserAgent = ""
http.AcceptLanguage = ""
http.AllowGzip = False


jsonBody = "{""client_id"": ""PLAID_CLIENT_ID"", ""secret"":""PLAID_SECRET"", ""count"": 10, ""offset"": 0}"

Set resp = http.PostJson2("https://sandbox.plaid.com/institutions/get","application/json",jsonBody)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If


statusCode = resp.StatusCode
Debug.Print "Response status code = "; statusCode

'  Examine the JSON response..
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load(resp.BodyStr)
json.EmitCompact = False
Debug.Print "JSON Response Body:"
Debug.Print json.Emit()