(Visual FoxPro) 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

LOCAL lcRequestUrl
LOCAL lcRequestMethod
LOCAL loAuthUtil
LOCAL lcWmConsumerId
LOCAL lcWmPrivateKey
LOCAL lcJsonStr
LOCAL loJson
LOCAL loHttp
LOCAL lcXmlStr
LOCAL loXml
LOCAL lnNumFeeds
LOCAL i

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

lcRequestUrl = "https://marketplace.walmartapis.com/v2/feeds"
lcRequestMethod = "GET"

* First we need to generate a signature for our request.
* The signature needs to be re-generated for each new Walmart HTTP request.
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.AuthUtil')
loAuthUtil = CreateObject('Chilkat.AuthUtil')

lcWmConsumerId = "WALMART_CONSUMER_ID"
lcWmPrivateKey = "WALMART_PRIVATE_KEY"
lcJsonStr = loAuthUtil.WalmartSignature(lcRequestUrl,lcWmConsumerId,lcWmPrivateKey,lcRequestMethod)
IF (loAuthUtil.LastMethodSuccess <> 1) THEN
    ? loAuthUtil.LastErrorText
    RELEASE loAuthUtil
    CANCEL
ENDIF

* 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
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.Load(lcJsonStr)

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
loHttp = CreateObject('Chilkat.Http')
loHttp.SetRequestHeader("WM_SVC.NAME","Walmart Marketplace")
loHttp.SetRequestHeader("WM_QOS.CORRELATION_ID",loJson.StringOf("correlation_id"))
loHttp.SetRequestHeader("WM_SEC.TIMESTAMP",loJson.StringOf("timestamp"))
loHttp.SetRequestHeader("WM_SEC.AUTH_SIGNATURE",loJson.StringOf("signature"))
loHttp.SetRequestHeader("WM_CONSUMER.ID",lcWmConsumerId)
loHttp.Accept = "application/xml"

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

lcXmlStr = loHttp.QuickGetStr(lcRequestUrl)
IF (loHttp.LastMethodSuccess <> 1) THEN
    ? loHttp.LastErrorText
    RELEASE loAuthUtil
    RELEASE loJson
    RELEASE loHttp
    CANCEL
ENDIF

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Xml')
loXml = CreateObject('Chilkat.Xml')
loXml.LoadXml(lcXmlStr)

* A successful response should have a 200 response status
IF (loHttp.LastStatus <> 200) THEN
    ? loXml.GetXml()
    ? "Response Status Code: " + STR(loHttp.LastStatus)
    ? "Failed."
    RELEASE loAuthUtil
    RELEASE loJson
    RELEASE loHttp
    RELEASE loXml
    CANCEL
ENDIF

* A sample XML response is shown below..

* To iterate over the Walmart feeds:
lnNumFeeds = loXml.NumChildrenAt("ns2:results")
i = 0
DO WHILE i < lnNumFeeds
    loXml.I = i

    ? "Feed ID: " + loXml.GetChildContent("ns2:results|ns2:feed[i]|ns2:feedId")
    ? "Feed Type: " + loXml.GetChildContent("ns2:results|ns2:feed[i]|ns2:feedType")
    ? "Num Items Recieved: " + STR(loXml.GetChildIntValue("ns2:results|ns2:feed[i]|ns2:itemsReceived"))
    ? "Feed Status: " + loXml.GetChildContent("ns2:results|ns2:feed[i]|ns2:feedStatus")
    ? "--"

    i = i + 1
ENDDO

? "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>

RELEASE loAuthUtil
RELEASE loJson
RELEASE loHttp
RELEASE loXml