(SQL Server) eBay -- Create or Replace Inventory Item

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 ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- 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)
    -- 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
    -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
    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

    DECLARE @success int
    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
    -- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
    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
    -- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
    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 @strResponse nvarchar(4000)
    EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT
    EXEC sp_OAMethod @http, 'PutText', @strResponse OUT, @url, @sTmp0, 'utf-8', 'application/json', 0, 0
    EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 <> 1
      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
        RETURN
      END


    EXEC sp_OAGetProperty @http, 'LastStatus', @iTmp0 OUT
    PRINT 'Response status code = ' + @iTmp0

    EXEC sp_OAGetProperty @http, 'LastStatus', @iTmp0 OUT
    IF @iTmp0 <> 204
      BEGIN

        PRINT @strResponse

        PRINT 'Failed'
        EXEC @hr = sp_OADestroy @json
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @sbAuth
        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


END
GO