(Excel) Duplicate curl -u user:password with Chilkat HTTP

Demonstrates how to duplicate a curl command that uses the -u username:password option. (This assumes HTTP Basic Authentication, and Chilkat requires Basic authentication to be over a TLS connection.)

Duplicates the following curl command:

curl https://api.sandbox.paypal.com/v1/oauth2/token \
  -H "Accept: application/json" \
  -H "Accept-Language: en_US" \
  -u "Client-Id:Secret" \
  -d "grant_type=client_credentials"

Download Excel Class Modules Chilkat Excel Class Modules

'  It requires the Chilkat API to have been previously unlocked.
'  See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp
Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest

'  The AddHeader method corresponds to the curl "-H" argument.
req.AddHeader "Accept","application/json"
req.AddHeader "Accept-Language","en_US"

'  The curl "-d" argument specifies the HTTP request body.  In this case,
'  we're sending an application/x-www-form-urlencoded request, and therefore
'  the body contains the URL-encoded query parameters.
req.AddParam "grant_type","client_credentials"

http.Login = "PAYPAL_REST_API_CLIENT_ID"
http.Password = "PAYPAL_REST_API_SECRET"

'  Sends a POST request where the Content-Type is application/x-www-form-urlencoded

Set resp = http.PostUrlEncoded("https://api.sandbox.paypal.com/v1/oauth2/token",req)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

If (resp.StatusCode <> 200) Then
    Debug.Print "Error status code: "; resp.StatusCode
    Debug.Print resp.BodyStr

    Exit Sub
End If

'  The JSON response is in the resp BodyStr property
Debug.Print resp.BodyStr
Debug.Print "-- Success."