Sample code for 30+ languages & platforms
Visual Basic 6.0

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.

Chilkat Visual Basic 6.0 Downloads

Visual Basic 6.0
Dim success As Long
success = 0

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim rest As New ChilkatRest

' See this example for getting an OAuth1 token for Etsy

Dim json As New ChilkatJsonObject
success = json.LoadFile("qa_data/tokens/etsy.json")
If (success = 0) Then
    Debug.Print "Failed to load previously fetched Etsy OAuth1 access token."
    Exit Sub
End If

Dim oauth1 As New ChilkatOAuth1

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"
success = oauth1.GenNonce(16)

Dim autoReconnect As Long
autoReconnect = 1
Dim tls As Long
tls = 1
success = rest.Connect("openapi.etsy.com",443,tls,autoReconnect)
If (success = 0) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

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

Dim jsonText As String
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")

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

Dim jsonResponse As New ChilkatJsonObject
success = jsonResponse.Load(jsonResponseText)
jsonResponse.EmitCompact = 0

Debug.Print jsonResponse.Emit()

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