SQL Server
SQL Server
eBay -- Create or Replace Inventory Item
See more eBay Examples
This example shows how to create a new inventory item record or update an existing inventory item record.See Create or Replace Inventory Item for more REST API details.
Chilkat SQL Server Downloads
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
DECLARE @success int
SELECT @success = 0
-- 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.
-- PUT https://api.ebay.com/sell/inventory/v1/inventory_item/GP-Cam-01
-- {
-- "availability":
-- {
-- "shipToLocationAvailability":
-- {
-- "quantity": 50
-- }
-- },
-- "condition": "NEW",
-- "product":
-- {
-- "title": "GoPro Hero4 Helmet Cam",
-- "description": "New GoPro Hero4 Helmet Cam. Unopened box.",
-- "aspects": {
-- "Brand" :["GoPro"],
-- "Type" : ["Helmet/Action"],
-- "Storage Type" : ["Removable"],
-- "Recording Definition" : ["High Definition"],
-- "Media Format" : ["Flash Drive (SSD)"],
-- "Optical Zoom" : ["10x"]
-- },
-- "imageUrls": [
-- "http://i.ebayimg.com/images/i/182196556219-0-1/s-l1000.jpg",
-- "http://i.ebayimg.com/images/i/182196556219-0-1/s-l1001.jpg",
-- "http://i.ebayimg.com/images/i/182196556219-0-1/s-l1002.jpg"
-- ]
-- }
-- }
-- First, generate the JSON using this code:
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
EXEC sp_OASetProperty @json, 'EmitCompact', 0
EXEC sp_OAMethod @json, 'UpdateNumber', @success OUT, 'availability.shipToLocationAvailability.quantity', '50'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'condition', 'NEW'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'product.title', 'GoPro Hero4 Helmet Cam'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'product.description', 'New GoPro Hero4 Helmet Cam. Unopened box.'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'product.aspects.Brand[0]', 'GoPro'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'product.aspects.Type[0]', 'Helmet/Action'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'product.aspects."Storage Type"[0]', 'Removable'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'product.aspects."Recording Definition"[0]', 'High Definition'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'product.aspects."Media Format"[0]', 'Flash Drive (SSD)'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'product.aspects."Optical Zoom"[0]', '10x'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'product.imageUrls[0]', 'http://i.ebayimg.com/images/i/182196556219-0-1/s-l1000.jpg'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'product.imageUrls[1]', 'http://i.ebayimg.com/images/i/182196556219-0-1/s-l1001.jpg'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'product.imageUrls[2]', 'http://i.ebayimg.com/images/i/182196556219-0-1/s-l1002.jpg'
-- Show the JSON to be sent:
EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT
PRINT @sTmp0
-- 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=="
DECLARE @accessToken nvarchar(4000)
SELECT @accessToken = 'EBAY_ACCESS_TOKEN'
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
-- 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 "GP-Cam-01".
DECLARE @url nvarchar(4000)
SELECT @url = 'https://api.sandbox.ebay.com/sell/inventory/v1/inventory_item/GP-Cam-01'
EXEC sp_OASetProperty @json, 'EmitCompact', 1
-- Set your Content-Language to whatever is desired.
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Content-Language', 'en-US'
-- Add our access token to the request, which is a header
-- having the following format:
-- Authorization: Bearer <userAccessToken>
DECLARE @sbAuth int
EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbAuth OUT
EXEC sp_OAMethod @sbAuth, 'Append', @success OUT, 'Bearer '
EXEC sp_OAMethod @sbAuth, 'Append', @success OUT, @accessToken
EXEC sp_OAMethod @sbAuth, 'GetAsString', @sTmp0 OUT
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Authorization', @sTmp0
EXEC sp_OASetProperty @http, 'Accept', 'application/json'
EXEC sp_OASetProperty @http, 'AllowGzip', 0
DECLARE @resp int
EXEC @hr = sp_OACreate 'Chilkat.HttpResponse', @resp OUT
EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT
EXEC sp_OAMethod @http, 'HttpStr', @success OUT, 'PUT', @url, @sTmp0, 'utf-8', 'application/json', @resp
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbAuth
EXEC @hr = sp_OADestroy @resp
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
PRINT 'Response status code = ' + @iTmp0
EXEC sp_OAGetProperty @http, 'LastStatus', @iTmp0 OUT
IF @iTmp0 <> 204
BEGIN
EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Failed'
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbAuth
EXEC @hr = sp_OADestroy @resp
RETURN
END
-- On success (status code = 204), there is no output payload (strResponse will be empty).
PRINT 'Inventory item successfully created.'
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @sbAuth
EXEC @hr = sp_OADestroy @resp
END
GO