(Excel) Simple GET using REST

Demonstrates how to do a simple HTTP GET request using REST.

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

' Connect to the REST server.

bTls = True

port = 443

bAutoReconnect = True

success = rest.Connect("my-store.com",port,bTls,bAutoReconnect)


responseJson = rest.FullRequestNoBody("GET","/wp-json/wc/v1/products?consumer_key=YOUR_CONSUMER_KEY&consumer_secret=YOUR_CONSUMER_SECRET")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Debug.Print responseJson
Debug.Print "----"

' We can alternatively do this:
Dim success As Boolean
success = rest.ClearAllQueryParams()
success = rest.AddQueryParam("consumer_key","YOUR_CONSUMER_KEY")
success = rest.AddQueryParam("consumer_secret","YOUR_CONSUMER_SECRET")
responseJson = rest.FullRequestNoBody("GET","/wp-json/wc/v1/products")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Debug.Print responseJson