SQL Server

Amazon SP-API Upload Feed

See more Amazon SP-API Examples

Upload a feed document to the feed previously created. SQL Server

-- 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 requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    -- Load your own feed data file.
    DECLARE @sbRequestBody int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbRequestBody OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @sbRequestBody, 'LoadFile', @success OUT, 'C:/AAWorkarea/test-despatch-upload.txt', 'utf-8'
    IF @success = 0
      BEGIN

        PRINT 'Failed to load test-despatch-upload.txt.'
        EXEC @hr = sp_OADestroy @sbRequestBody
        RETURN
      END

    -- The SP-API Create Feed example returned JSON such as this.

    -- {
    --   "feedDocumentId": "amzn1.tortuga.4.eu.8fb6f9c4-XXXX-4e7f-824f-XXXXXXXXXXXXX.ZZZZZZZZZZZZZZ",
    --   "url": "https://tortuga-prod-eu.s3-eu-west-1.amazonaws.com/%2FNinetyDays/amzn1.tortuga.4.eu.8fb6f9c4-XXXX-4e7f-824f-XXXXXXXXXXXXX.ZZZZZZZZZZZZZZ?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20230222T014944Z&X-Amz-SignedHeaders=content-type%3Bhost&X-Amz-Expires=300&X-Amz-Credential=XXXXXXXXXXXXXXXXX%2F20230222%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Signature=XXXXXXXXXXXXXXXXXXXXXXXXXXXX"
    -- }

    -- Load the JSON feed file created by this example:  SP-API Create Feed
    DECLARE @jsonFeedInfo int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jsonFeedInfo OUT

    EXEC sp_OAMethod @jsonFeedInfo, 'LoadFile', @success OUT, 'qa_data/json/sp_api_feed_upload_info.json'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @jsonFeedInfo, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @sbRequestBody
        EXEC @hr = sp_OADestroy @jsonFeedInfo
        RETURN
      END

    -- Get the pre-signed URL
    DECLARE @url nvarchar(4000)
    EXEC sp_OAMethod @jsonFeedInfo, 'StringOf', @url OUT, 'url'

    -- We can use the Chilkat HTTP object because the URL is pre-signed.
    -- We don't need to add our own AWS authentication because it's already in the pre-signed URL,
    -- which is only valid for short amount of time.
    DECLARE @http int
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT

    -- NOTE: The string "text/tab-separated-values; charset=UTF-8" must match exactly the contentType specified when creating the feed.
    DECLARE @resp int
    EXEC @hr = sp_OACreate 'Chilkat.HttpResponse', @resp OUT

    EXEC sp_OAMethod @http, 'HttpSb', @success OUT, 'PUT', @url, @sbRequestBody, 'utf-8', 'text/tab-separated-values; charset=UTF-8', @resp
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @sbRequestBody
        EXEC @hr = sp_OADestroy @jsonFeedInfo
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @resp
        RETURN
      END


    EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
    PRINT 'status code = ' + @iTmp0

    EXEC sp_OAGetProperty @resp, 'StatusText', @sTmp0 OUT
    PRINT 'status text = ' + @sTmp0

    PRINT 'response body:'
    EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
    PRINT @sTmp0

    EXEC @hr = sp_OADestroy @sbRequestBody
    EXEC @hr = sp_OADestroy @jsonFeedInfo
    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @resp


END
GO