(Excel) BrickLink OAuth1 using Chilkat REST

See more BrickLink Examples

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

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 oauth1 As Chilkat.OAuth1
Set oauth1 = Chilkat.NewOAuth1

oauth1.ConsumerKey = "Your Consumer Key"
oauth1.ConsumerSecret = "Your Consumer Secret"
oauth1.Token = "Your OAuth1 Token"
oauth1.TokenSecret = "Your Token Secret"
oauth1.SignatureMethod = "HMAC-SHA1"

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

Dim success As Boolean
success = rest.SetAuthOAuth1(oauth1,False)

success = rest.Connect("api.bricklink.com",443,True,True)
If (success = False) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Dim sbResponse As Chilkat.StringBuilder
Set sbResponse = Chilkat.NewStringBuilder
success = rest.FullRequestNoBodySb("GET","/api/store/v1/orders?direction=in",sbResponse)
If (success = False) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Debug.Print "Response status code = "; rest.ResponseStatusCode

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.LoadSb(sbResponse)
json.EmitCompact = False
Debug.Print json.Emit()