(Excel) Magento Request with OAuth1.0a Authentication

Demonstrates sending a Magento request with OAuth1.0a authentication. (Using the Magento 1.x REST API)

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

http.OAuth1 = True
http.OAuthVerifier = ""
http.OAuthConsumerKey = "MAGENTO_CONSUMER_KEY"
http.OAuthConsumerSecret = "MAGENTO_CONSUMER_SECRET"
http.OAuthToken = "MAGENTO__TOKEN"
http.OAuthTokenSecret = "MAGENTO_TOKEN_SECRET"

http.Accept = "application/json"


url = "http://www.inart.com/api/rest/products/store/2?limit=20&page=1"


jsonStr = http.QuickGetStr(url)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response status code = "; http.LastStatus

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load(jsonStr)
json.EmitCompact = False

Debug.Print json.Emit()

' Use this online tool to generate parsing code from sample JSON: 
' Generate Parsing Code from JSON