(Excel) BrickLink OAuth1 using Chilkat HTTP

See more BrickLink Examples

Demonstrates sending an api.bricklink.com request with OAuth1 authentication using Chilkat HTTP.

Note: This example requires Chilkat v9.5.0.91 or greater (due to adjustments made within Chilkat to support bricklink OAuth1 needs).

For more information, see https://www.bricklink.com/v3/api.page?page=auth

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 http As Chilkat.Http
Set http = Chilkat.NewHttp

http.OAuth1 = True
http.OAuthConsumerKey = "Your Consumer Key"
http.OAuthConsumerSecret = "Your Consumer Secret"
http.OAuthToken = "Your OAuth1 Token"
http.OAuthTokenSecret = "Your Token Secret"
http.OAuthSigMethod = "HMAC-SHA1"


Set resp = http.QuickGetObj("https://api.bricklink.com/api/store/v1/orders?direction=in")
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

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

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = resp.GetBodyJson(json)

json.EmitCompact = False
Debug.Print json.Emit()