(Excel) Duplicate curl POST with JSON Body

Demonstrates how to duplicate the following curl command, which sends a POST w/ a JSON body.

curl -H "Content-Type: application/json" -i https://my-store.com/wp-json/wc/v2/products/batch?consumer_key=YOUR_CONSUMER_KEY&consumer_secret=YOUR_CONSUMER_SECRET  -d @test_product.txt

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 rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Connect using TLS.

bAutoReconnect = True
success = rest.Connect("my-store.com",443,True,bAutoReconnect)

' test_product.txt contains this string:
Dim sbJson As Chilkat.StringBuilder
Set sbJson = Chilkat.NewStringBuilder
Dim success As Boolean
success = sbJson.Append("{""create"": [{""name"": ""Woo Single #1"",""type"": ""simple"",""regular_price"": ""21.99""}]}")

' Add query parameters

' Add the Content-Type HTTP request header.
success = rest.AddHeader("Content-Type","application/json")


jsonResponseStr = rest.FullRequestString("POST","/wp-json/wc/v2/products/batch?consumer_key=YOUR_CONSUMER_KEY&consumer_secret=YOUR_CONSUMER_SECRET",sbJson.GetAsString())
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Show the JSON response.  (See below for a sample JSON response.)
Debug.Print "Json Response: "; jsonResponseStr