(Excel) Update an Inventory Listing using OAuth1 Authentication

See more Etsy Examples

Updates an inventory listing. This example uses OAuth1 authentication instead of providing an api_key=MY_ETSY_KEYSTRING query parameter.

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

' See this example for getting an OAuth1 token for Etsy

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.LoadFile("qa_data/tokens/etsy.json")
If (success = False) Then
    Debug.Print "Failed to load previously fetched Etsy OAuth1 access token."
    Exit Sub
End If

Dim oauth1 As Chilkat.OAuth1
Set oauth1 = Chilkat.NewOAuth1

oauth1.ConsumerKey = "app_keystring"
oauth1.ConsumerSecret = "app_shared_secret"
oauth1.Token = json.StringOf("oauth_token")
oauth1.TokenSecret = json.StringOf("oauth_token_secret")
oauth1.SignatureMethod = "HMAC-SHA1"
Dim success As Boolean
success = oauth1.GenNonce(16)


autoReconnect = True

tls = True
success = rest.Connect("openapi.etsy.com",443,tls,autoReconnect)
If (success = False) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Tell the REST object to use the OAuth1 object.
success = rest.SetAuthOAuth1(oauth1,True)


jsonText = "[{""product_id"":1999949999,""property_values"":[],""offerings"":[{""offering_id"":9999905883,""price"":""36.23"",""quantity"":1}]}]"

success = rest.AddQueryParam("products",jsonText)
success = rest.AddHeader("Content-Type","application/x-www-form-urlencoded")


jsonResponseText = rest.FullRequestFormUrlEncoded("PUT","/v2/listings/228827035/inventory")
If (rest.LastMethodSuccess = False) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Dim jsonResponse As Chilkat.JsonObject
Set jsonResponse = Chilkat.NewJsonObject
success = jsonResponse.Load(jsonResponseText)
jsonResponse.EmitCompact = False

Debug.Print jsonResponse.Emit()

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