(SQL Server) Walmart v3 Get a Feed Status

This API returns the feed status for a specified Feed ID.

For more information, see https://developer.walmart.com/#/apicenter/marketPlace/latest#getAFeedStatus

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

    DECLARE @http int
    -- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    -- Implements the following CURL command:

    -- curl -X GET \
    --   https://marketplace.walmartapis.com/v3/feeds/{feedId} \
    --   -H 'WM_SVC.NAME: Walmart Marketplace'
    --   -H 'WM_SEC.ACCESS_TOKEN: eyJraWQiOiIzZjVhYTFmNS1hYWE5LTQzM.....'
    --   -H 'WM_QOS.CORRELATION_ID: b3261d2d-028a-4ef7-8602-633c23200af6'
    --   -H 'Content-Type: application/xml'
    --   -H 'Accept: application/xml'

    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'WM_QOS.CORRELATION_ID', 'b3261d2d-028a-4ef7-8602-633c23200af6'
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Content-Type', 'application/xml'
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'WM_SEC.ACCESS_TOKEN', 'eyJraWQiOiIzZjVhYTFmNS1hYWE5LTQzM.....'
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Accept', 'application/xml'
    EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'WM_SVC.NAME', 'Walmart Marketplace'

    DECLARE @sbResponseBody int
    -- Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbResponseBody OUT

    EXEC sp_OAMethod @http, 'QuickGetSb', @success OUT, 'https://marketplace.walmartapis.com/v3/feeds/{feedId}', @sbResponseBody
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @sbResponseBody
        RETURN
      END

    DECLARE @xmlResponse int
    -- Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Xml', @xmlResponse OUT

    EXEC sp_OAMethod @xmlResponse, 'LoadSb', @success OUT, @sbResponseBody, 1

    -- Sample XML response:
    -- (Sample code for parsing the XML response is shown below)

    -- <?xml version="1.0" encoding="UTF-8"?>
    -- <PartnerFeedResponse xmlns:ns2="http://walmart.com/">
    --     <feedId>1c349f8f-aec0-411f-8454-ead47d12946f</feedId>
    --     <feedStatus>PROCESSED</feedStatus>
    --     <ingestionErrors/>
    --     <itemsReceived>11</itemsReceived>
    --     <itemsSucceeded>11</itemsSucceeded>
    --     <itemsFailed>0</itemsFailed>
    --     <itemsProcessing>0</itemsProcessing>
    --     <offset>0</offset>
    --     <limit>0</limit>
    --     <itemDetails>
    --         <itemIngestionStatus>
    --             <martId>0</martId>
    --             <sku>sku1</sku>
    --             <index>8</index>
    --             <ingestionStatus>SUCCESS</ingestionStatus>
    --             <ingestionErrors/>
    --         </itemIngestionStatus>
    --         <itemIngestionStatus>
    --             <martId>0</martId>
    --             <sku>sku2</sku>
    --             <index>6</index>
    --             <ingestionStatus>SUCCESS</ingestionStatus>
    --             <ingestionErrors/>
    --         </itemIngestionStatus>
    --         <itemIngestionStatus>
    --             <martId>0</martId>
    --             <sku>sku3</sku>
    --             <index>9</index>
    --             <ingestionStatus>SUCCESS</ingestionStatus>
    --             <ingestionErrors/>
    --         </itemIngestionStatus>
    --     </itemDetails>
    -- </PartnerFeedResponse>

    -- Sample code for parsing the XML response...
    -- Use the following online tool to generate parsing code from sample XML:
    -- Generate Parsing Code from XML

    DECLARE @PartnerFeedResponse_xmlns_ns2 nvarchar(4000)

    DECLARE @feedId nvarchar(4000)

    DECLARE @feedStatus nvarchar(4000)

    DECLARE @itemsReceived int

    DECLARE @itemsSucceeded int

    DECLARE @itemsFailed int

    DECLARE @itemsProcessing int

    DECLARE @offset int

    DECLARE @limit int

    DECLARE @i int

    DECLARE @count_i int

    DECLARE @martId int

    DECLARE @sku nvarchar(4000)

    DECLARE @index int

    DECLARE @ingestionStatus nvarchar(4000)

    EXEC sp_OAMethod @xmlResponse, 'GetAttrValue', @PartnerFeedResponse_xmlns_ns2 OUT, 'xmlns:ns2'
    EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @feedId OUT, 'feedId'
    EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @feedStatus OUT, 'feedStatus'
    EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @itemsReceived OUT, 'itemsReceived'
    EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @itemsSucceeded OUT, 'itemsSucceeded'
    EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @itemsFailed OUT, 'itemsFailed'
    EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @itemsProcessing OUT, 'itemsProcessing'
    EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @offset OUT, 'offset'
    EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @limit OUT, 'limit'
    SELECT @i = 0
    EXEC sp_OAMethod @xmlResponse, 'NumChildrenHavingTag', @count_i OUT, 'itemDetails|itemIngestionStatus'
    WHILE @i < @count_i
      BEGIN
        EXEC sp_OASetProperty @xmlResponse, 'I', @i
        EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @martId OUT, 'itemDetails|itemIngestionStatus[i]|martId'
        EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @sku OUT, 'itemDetails|itemIngestionStatus[i]|sku'
        EXEC sp_OAMethod @xmlResponse, 'GetChildIntValue', @index OUT, 'itemDetails|itemIngestionStatus[i]|index'
        EXEC sp_OAMethod @xmlResponse, 'GetChildContent', @ingestionStatus OUT, 'itemDetails|itemIngestionStatus[i]|ingestionStatus'
        SELECT @i = @i + 1
      END

    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @sbResponseBody
    EXEC @hr = sp_OADestroy @xmlResponse


END
GO