VBScript

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. VBScript

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

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

set rest = CreateObject("Chilkat.Rest")

' See this example for getting an OAuth1 token for Etsy

set json = CreateObject("Chilkat.JsonObject")
success = json.LoadFile("qa_data/tokens/etsy.json")
If (success = 0) Then
    outFile.WriteLine("Failed to load previously fetched Etsy OAuth1 access token.")
    WScript.Quit
End If

set oauth1 = CreateObject("Chilkat.OAuth1")

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)

autoReconnect = 1
tls = 1
success = rest.Connect("openapi.etsy.com",443,tls,autoReconnect)
If (success = 0) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

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

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 = 0) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

set jsonResponse = CreateObject("Chilkat.JsonObject")
success = jsonResponse.Load(jsonResponseText)
jsonResponse.EmitCompact = 0

outFile.WriteLine(jsonResponse.Emit())

outFile.WriteLine("Response status code: " & rest.ResponseStatusCode)

outFile.Close