(PowerBuilder) 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

integer li_rc
string ls_RequestUrl
string ls_RequestMethod
oleobject loo_AuthUtil
string ls_WmConsumerId
string ls_WmPrivateKey
string ls_JsonStr
oleobject loo_Json
oleobject loo_Http
string ls_XmlStr
oleobject loo_Xml
integer li_NumFeeds
integer 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

ls_RequestUrl = "https://marketplace.walmartapis.com/v2/feeds"
ls_RequestMethod = "GET"

// First we need to generate a signature for our request.
// The signature needs to be re-generated for each new Walmart HTTP request.
loo_AuthUtil = create oleobject
// Use "Chilkat_9_5_0.AuthUtil" for versions of Chilkat < 10.0.0
li_rc = loo_AuthUtil.ConnectToNewObject("Chilkat.AuthUtil")
if li_rc < 0 then
    destroy loo_AuthUtil
    MessageBox("Error","Connecting to COM object failed")
    return
end if

ls_WmConsumerId = "WALMART_CONSUMER_ID"
ls_WmPrivateKey = "WALMART_PRIVATE_KEY"
ls_JsonStr = loo_AuthUtil.WalmartSignature(ls_RequestUrl,ls_WmConsumerId,ls_WmPrivateKey,ls_RequestMethod)
if loo_AuthUtil.LastMethodSuccess <> 1 then
    Write-Debug loo_AuthUtil.LastErrorText
    destroy loo_AuthUtil
    return
end if

// 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
loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.Load(ls_JsonStr)

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")

loo_Http.SetRequestHeader("WM_SVC.NAME","Walmart Marketplace")
loo_Http.SetRequestHeader("WM_QOS.CORRELATION_ID",loo_Json.StringOf("correlation_id"))
loo_Http.SetRequestHeader("WM_SEC.TIMESTAMP",loo_Json.StringOf("timestamp"))
loo_Http.SetRequestHeader("WM_SEC.AUTH_SIGNATURE",loo_Json.StringOf("signature"))
loo_Http.SetRequestHeader("WM_CONSUMER.ID",ls_WmConsumerId)
loo_Http.Accept = "application/xml"

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

ls_XmlStr = loo_Http.QuickGetStr(ls_RequestUrl)
if loo_Http.LastMethodSuccess <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_AuthUtil
    destroy loo_Json
    destroy loo_Http
    return
end if

loo_Xml = create oleobject
// Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0
li_rc = loo_Xml.ConnectToNewObject("Chilkat.Xml")

loo_Xml.LoadXml(ls_XmlStr)

// A successful response should have a 200 response status
if loo_Http.LastStatus <> 200 then
    Write-Debug loo_Xml.GetXml()
    Write-Debug "Response Status Code: " + string(loo_Http.LastStatus)
    Write-Debug "Failed."
    destroy loo_AuthUtil
    destroy loo_Json
    destroy loo_Http
    destroy loo_Xml
    return
end if

// A sample XML response is shown below..

// To iterate over the Walmart feeds:
li_NumFeeds = loo_Xml.NumChildrenAt("ns2:results")
i = 0
do while i < li_NumFeeds
    loo_Xml.I = i

    Write-Debug "Feed ID: " + loo_Xml.GetChildContent("ns2:results|ns2:feed[i]|ns2:feedId")
    Write-Debug "Feed Type: " + loo_Xml.GetChildContent("ns2:results|ns2:feed[i]|ns2:feedType")
    Write-Debug "Num Items Recieved: " + string(loo_Xml.GetChildIntValue("ns2:results|ns2:feed[i]|ns2:itemsReceived"))
    Write-Debug "Feed Status: " + loo_Xml.GetChildContent("ns2:results|ns2:feed[i]|ns2:feedStatus")
    Write-Debug "--"

    i = i + 1
loop

Write-Debug "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>


destroy loo_AuthUtil
destroy loo_Json
destroy loo_Http
destroy loo_Xml