(DataFlex) Walmart - Get All Feed Statuses

Note: This is an older example for the Walmart v2 API. You should instead use the Walmart v3 API.

Demonstrates how to send a Walmart REST API request to get all feed statuses.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Use ChilkatAx-win32.pkg

Procedure Test
    String sRequestUrl
    String sRequestMethod
    Handle hoAuthUtil
    String sWmConsumerId
    String sWmPrivateKey
    String sJsonStr
    Handle hoJson
    Boolean iSuccess
    Handle hoHttp
    String sXmlStr
    Handle hoXml
    Integer iNumFeeds
    Integer i
    String sTemp1
    Integer iTemp1
    Boolean bTemp1

    // --------------------------------------------------------------------
    // This example is for the older and deprecated Walmart v2 API.
    // 
    // Use the v3 API instead: Walmart v3 Get All Feed Statuses
    // --------------------------------------------------------------------

    // This example requires the Chilkat API to have been previously unlocked.
    // See Global Unlock Sample for sample code.

    // Demonstrates how to send a request such as the following to get all feed statuses:
    // Also demonstrates how to parse the results.

    // GET /v2/feeds HTTP/1.1
    // WM_SVC.NAME: Walmart Marketplace
    // WM_QOS.CORRELATION_ID: 123456abcdef
    // WM_SEC.TIMESTAMP: 1438147839
    // WM_SEC.AUTH_SIGNATURE: 9khb0lPeRt0WSGbXNGGj4kSQ9L6PMBX/q+ovdy9bDQfvdhYs8NoEsjRX4fD7UNIHTddgkmSVqAqeIIHlaLcRIl0Y4DcJqQYHL27LiWlsm91nYodGssWTKsOq6dJfUHEy95M4zXFGWDDhbHYCor28SCV/g/JdEQybGkcX9Zj5aDyg=
    // WM_CONSUMER.ID: a20ac266-9add-4fc7-9392-fec303f5155c
    // Accept: application/xml
    // Host: https://marketplace.walmartapis.com

    Move "https://marketplace.walmartapis.com/v2/feeds" To sRequestUrl
    Move "GET" To sRequestMethod

    // First we need to generate a signature for our request.
    // The signature needs to be re-generated for each new Walmart HTTP request.
    Get Create (RefClass(cComChilkatAuthUtil)) To hoAuthUtil
    If (Not(IsComObjectCreated(hoAuthUtil))) Begin
        Send CreateComObject of hoAuthUtil
    End

    Move "WALMART_CONSUMER_ID" To sWmConsumerId
    Move "WALMART_PRIVATE_KEY" To sWmPrivateKey
    Get ComWalmartSignature Of hoAuthUtil sRequestUrl sWmConsumerId sWmPrivateKey sRequestMethod To sJsonStr
    Get ComLastMethodSuccess Of hoAuthUtil To bTemp1
    If (bTemp1 <> True) Begin
        Get ComLastErrorText Of hoAuthUtil To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // The JSON returned by WalmartSignature contains the values to be used in the following
    // header fields: WM_SEC.AUTH_SIGNATURE, WM_SEC.TIMESTAMP, and WM_QOS.CORRELATION_ID
    Get Create (RefClass(cComChilkatJsonObject)) To hoJson
    If (Not(IsComObjectCreated(hoJson))) Begin
        Send CreateComObject of hoJson
    End
    Get ComLoad Of hoJson sJsonStr To iSuccess

    Get Create (RefClass(cComChilkatHttp)) To hoHttp
    If (Not(IsComObjectCreated(hoHttp))) Begin
        Send CreateComObject of hoHttp
    End
    Send ComSetRequestHeader To hoHttp "WM_SVC.NAME" "Walmart Marketplace"
    Get ComStringOf Of hoJson "correlation_id" To sTemp1
    Send ComSetRequestHeader To hoHttp "WM_QOS.CORRELATION_ID" sTemp1
    Get ComStringOf Of hoJson "timestamp" To sTemp1
    Send ComSetRequestHeader To hoHttp "WM_SEC.TIMESTAMP" sTemp1
    Get ComStringOf Of hoJson "signature" To sTemp1
    Send ComSetRequestHeader To hoHttp "WM_SEC.AUTH_SIGNATURE" sTemp1
    Send ComSetRequestHeader To hoHttp "WM_CONSUMER.ID" sWmConsumerId
    Set ComAccept Of hoHttp To "application/xml"

    // Note: Do not explicitly set the "Host" header.  Chilkat will set it automatically.

    Get ComQuickGetStr Of hoHttp sRequestUrl To sXmlStr
    Get ComLastMethodSuccess Of hoHttp To bTemp1
    If (bTemp1 <> True) Begin
        Get ComLastErrorText Of hoHttp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get Create (RefClass(cComChilkatXml)) To hoXml
    If (Not(IsComObjectCreated(hoXml))) Begin
        Send CreateComObject of hoXml
    End
    Get ComLoadXml Of hoXml sXmlStr To iSuccess

    // A successful response should have a 200 response status
    Get ComLastStatus Of hoHttp To iTemp1
    If (iTemp1 <> 200) Begin
        Get ComGetXml Of hoXml To sTemp1
        Showln sTemp1
        Get ComLastStatus Of hoHttp To iTemp1
        Showln "Response Status Code: " iTemp1
        Showln "Failed."
        Procedure_Return
    End

    // A sample XML response is shown below..

    // To iterate over the Walmart feeds:
    Get ComNumChildrenAt Of hoXml "ns2:results" To iNumFeeds
    Move 0 To i
    While (i < iNumFeeds)
        Set ComI Of hoXml To i

        Get ComGetChildContent Of hoXml "ns2:results|ns2:feed[i]|ns2:feedId" To sTemp1
        Showln "Feed ID: " sTemp1
        Get ComGetChildContent Of hoXml "ns2:results|ns2:feed[i]|ns2:feedType" To sTemp1
        Showln "Feed Type: " sTemp1
        Get ComGetChildIntValue Of hoXml "ns2:results|ns2:feed[i]|ns2:itemsReceived" To iTemp1
        Showln "Num Items Recieved: " iTemp1
        Get ComGetChildContent Of hoXml "ns2:results|ns2:feed[i]|ns2:feedStatus" To sTemp1
        Showln "Feed Status: " sTemp1
        Showln "--"

        Move (i + 1) To i
    Loop

    Showln "Success."

    // ---------------------------------------
    // Sample XML response
    // ---------------------------------------

    // <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
    // <ns2:list xmlns:ns2="http://walmart.com/">
    //     <ns2:totalResults>1293</ns2:totalResults>
    //     <ns2:offset>0</ns2:offset>
    //     <ns2:limit>50</ns2:limit>
    //     <ns2:results>
    //         <ns2:feed>
    //             <ns2:feedId>AAAA7F0345E9403C91223F7139FFC341@AQsBAQA</ns2:feedId>
    //             <ns2:feedType>inventory</ns2:feedType>
    //             <ns2:partnerId>10000999999</ns2:partnerId>
    //             <ns2:itemsReceived>130088</ns2:itemsReceived>
    //             <ns2:itemsSucceeded>113154</ns2:itemsSucceeded>
    //             <ns2:itemsFailed>16934</ns2:itemsFailed>
    //             <ns2:itemsProcessing>0</ns2:itemsProcessing>
    //             <ns2:feedStatus>PROCESSED</ns2:feedStatus>
    //             <ns2:feedDate>2017-04-27T17:05:42.078Z</ns2:feedDate>
    //             <ns2:modifiedDtm>2017-04-27T18:06:10.795Z</ns2:modifiedDtm>
    //         </ns2:feed>
    //         <ns2:feed>
    //             <ns2:feedId>AAAAF1F402CD407FA363AD2929593FFF@AQsBAQA</ns2:feedId>
    //             <ns2:feedType>inventory</ns2:feedType>
    //             <ns2:partnerId>10000999999</ns2:partnerId>
    //             <ns2:itemsReceived>39594</ns2:itemsReceived>
    //             <ns2:itemsSucceeded>34533</ns2:itemsSucceeded>
    //             <ns2:itemsFailed>5061</ns2:itemsFailed>
    //             <ns2:itemsProcessing>0</ns2:itemsProcessing>
    //             <ns2:feedStatus>PROCESSED</ns2:feedStatus>
    //             <ns2:feedDate>2017-04-27T05:18:59.739Z</ns2:feedDate>
    //             <ns2:modifiedDtm>2017-04-27T05:20:30.192Z</ns2:modifiedDtm>
    //         </ns2:feed>
    // ...
    //     </ns2:results>
    // </ns2:list>


End_Procedure