(Excel) eBay -- Create or Replace Inventory Item (2nd example)

Another example for creating an inventory item, with different data.

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.

' This example sends the following sample PUT request to create (or replace) a new inventory item.

' { 
'     "product": { 
'         "title": "Test listing - do not bid or buy - awesome Apple watch test 2",
'         "aspects": { 
'             "Feature" : ["Water resistance", "GPS"],
'             "CPU" : ["Dual-Core Processor"]
'         },
'         "description": "Test listing - do not bid or buy \n Built-in GPS. Water resistance to 50 meters.1 A new lightning-fast dual-core processor. And a display that\u2019s two times brighter than before. Full of features that help you stay active, motivated, and connected, Apple Watch Series 2 is designed for all the ways you move ",
'         "upc": ["888462079525"],
'         "imageUrls": [
'             "http://store.storeimages.cdn-apple.com/4973/as-images.apple.com/is/image/AppleInc/aos/published/images/S/1/S1/42/S1-42-alu-silver-sport-white-grid?wid=332&hei=392&fmt=jpeg&qlt=95&op_sharpen=0&resMode=bicub&op_usm=0.5,0.5,0,0&iccEmbed=0&layer=comp&.v=1472247758975",
'             "http://store.storeimages.cdn-apple.com/4973/as-images.apple.com/is/image/AppleInc/aos/published/images/4/2/42/stainless/42-stainless-sport-white-grid?wid=332&hei=392&fmt=jpeg&qlt=95&op_sharpen=0&resMode=bicub&op_usm=0.5,0.5,0,0&iccEmbed=0&layer=comp&.v=1472247760390",
'             "http://store.storeimages.cdn-apple.com/4973/as-images.apple.com/is/image/AppleInc/aos/published/images/4/2/42/ceramic/42-ceramic-sport-cloud-grid?wid=332&hei=392&fmt=jpeg&qlt=95&op_sharpen=0&resMode=bicub&op_usm=0.5,0.5,0,0&iccEmbed=0&layer=comp&.v=1472247758007"
'         ]
'     },
'     "condition": "NEW",
'     "packageWeightAndSize": { 
'         "dimensions": { 
'             "height": 5,
'             "length": 10,
'             "width": 15,
'             "unit": "INCH"
'         },
'         "packageType": "MAILING_BOX",
'         "weight": { 
'             "value": 2,
'             "unit": "POUND"
'         }
'     },
'     "availability": { 
'         "shipToLocationAvailability": { 
'             "quantity": 10
'         }
'     }
' }

' First, generate the JSON using this code:
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False

Dim success As Boolean
success = json.UpdateString("product.title","Test listing - do not bid or buy - awesome Apple watch test 2")
success = json.UpdateString("product.aspects.Feature[0]","Water resistance")
success = json.UpdateString("product.aspects.Feature[1]","GPS")
success = json.UpdateString("product.aspects.CPU[0]","Dual-Core Processor")
success = json.UpdateString("product.description","Test listing - do not bid or buy\n Built-in GPS. Water resistance to 50 meters.1 A new lightning-fast dual-core processor. And a display thats two times brighter than before. Full of features that help you stay active, motivated, and connected, Apple Watch Series 2 is designed for all the ways you move ")
success = json.UpdateString("product.upc[0]","888462079525")
success = json.UpdateString("product.imageUrls[0]","http://store.storeimages.cdn-apple.com/4973/as-images.apple.com/is/image/AppleInc/aos/published/images/S/1/S1/42/S1-42-alu-silver-sport-white-grid?wid=332&hei=392&fmt=jpeg&qlt=95&op_sharpen=0&resMode=bicub&op_usm=0.5,0.5,0,0&iccEmbed=0&layer=comp&.v=1472247758975")
success = json.UpdateString("product.imageUrls[1]","http://store.storeimages.cdn-apple.com/4973/as-images.apple.com/is/image/AppleInc/aos/published/images/4/2/42/stainless/42-stainless-sport-white-grid?wid=332&hei=392&fmt=jpeg&qlt=95&op_sharpen=0&resMode=bicub&op_usm=0.5,0.5,0,0&iccEmbed=0&layer=comp&.v=1472247760390")
success = json.UpdateString("product.imageUrls[2]","http://store.storeimages.cdn-apple.com/4973/as-images.apple.com/is/image/AppleInc/aos/published/images/4/2/42/ceramic/42-ceramic-sport-cloud-grid?wid=332&hei=392&fmt=jpeg&qlt=95&op_sharpen=0&resMode=bicub&op_usm=0.5,0.5,0,0&iccEmbed=0&layer=comp&.v=1472247758007")
success = json.UpdateString("condition","NEW")
success = json.UpdateNumber("packageWeightAndSize.dimensions.height","5")
success = json.UpdateNumber("packageWeightAndSize.dimensions.length","10")
success = json.UpdateNumber("packageWeightAndSize.dimensions.width","15")
success = json.UpdateString("packageWeightAndSize.dimensions.unit","INCH")
success = json.UpdateString("packageWeightAndSize.packageType","MAILING_BOX")
success = json.UpdateNumber("packageWeightAndSize.weight.value","2")
success = json.UpdateString("packageWeightAndSize.weight.unit","POUND")
success = json.UpdateNumber("availability.shipToLocationAvailability.quantity","10")

' Show the JSON to be sent:
Debug.Print json.Emit()

' Use a previously obtained user token.  The token should look something like this:
' "v^1.1#i^1#r^0#p^3#I^3#f^0#t^H4sIAAAAAAAAAOVXa2wUVRTu9k ... 89xuCWYREAAA=="

accessToken = "EBAY_ACCESS_TOKEN"

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' This example uses the sandbox.  
' Change "api.sandbox.ebay.com" to "api.ebay.com" to use the production system.
' Note: The last part of the url is the SKU.  In this URL, the SKU is "AppleWatch".

url = "https://api.sandbox.ebay.com/sell/inventory/v1/inventory_item/AppleWatch"
json.EmitCompact = True

' Set your Content-Language to whatever is desired.
http.SetRequestHeader "Content-Language","en-US"

' Add our access token to the request, which is a header
' having the following format:
' Authorization: Bearer <userAccessToken>
Dim sbAuth As Chilkat.StringBuilder
Set sbAuth = Chilkat.NewStringBuilder
success = sbAuth.Append("Bearer ")
success = sbAuth.Append(accessToken)
http.SetRequestHeader "Authorization",sbAuth.GetAsString()

http.Accept = "application/json"
http.AllowGzip = False


strResponse = http.PutText(url,json.Emit(),"utf-8","application/json",False,False)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

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

If (http.LastStatus <> 204) Then
    Debug.Print strResponse
    Debug.Print "Failed"
    Exit Sub
End If

' On success (status code = 204), there is no output payload (strResponse will be empty).
Debug.Print "Inventory item successfully created."