(Lianja) Walmart - Get Inventory for an Item

Demonstrates how to get inventory for an item and parse the result.

Chilkat Lianja Extension Download Chilkat Lianja Extension

// ---------------------------------------------------------------------------------------------------------
// Note: This example is deprecated.  The Walmart API no longer uses the Signature method of authenticating.
// Walmart now uses OAuth2.  
// ---------------------------------------------------------------------------------------------------------

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

// Sends the following GET request:
// GET https://marketplace.walmartapis.com/v2/inventory?sku={SKU}

loSbUrl = createobject("CkStringBuilder")
llSuccess = loSbUrl.Append("https://marketplace.walmartapis.com/v2/inventory?sku={SKU}")
lnNumReplaced = loSbUrl.Replace("{SKU}","HOPP~904~51041")

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.
loAuthUtil = createobject("CkAuthUtil")

lcWmConsumerId = "WALMART_CONSUMER_ID"
lcWmPrivateKey = "WALMART_PRIVATE_KEY"
lcJsonStr = loAuthUtil.WalmartSignature(loSbUrl.GetAsString(),lcWmConsumerId,lcWmPrivateKey,lcRequestMethod)
if (loAuthUtil.LastMethodSuccess <> .T.) then
    ? loAuthUtil.LastErrorText
    release loSbUrl
    release loAuthUtil
    return
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
loJson = createobject("CkJsonObject")
loJson.Load(lcJsonStr)

loHttp = createobject("CkHttp")
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(loSbUrl.GetAsString())
if (loHttp.LastMethodSuccess <> .T.) then
    ? loHttp.LastErrorText
    release loSbUrl
    release loAuthUtil
    release loJson
    release loHttp
    return
endif

loXml = createobject("CkXml")
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 loSbUrl
    release loAuthUtil
    release loJson
    release loHttp
    release loXml
    return
endif

// A sample XML response is shown below..
? loXml.GetXml()
? "--"

// To get the quantity:
lnQuantity = loXml.GetChildIntValue("quantity|amount")
? "quantity = " + str(lnQuantity)

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

// <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
// <inventory xmlns="http://walmart.com/">
//     <sku>HOPP~904~51041</sku>
//     <quantity>
//         <unit>EACH</unit>
//         <amount>234</amount>
//     </quantity>
//     <fulfillmentLagTime>5</fulfillmentLagTime>
// </inventory>


release loSbUrl
release loAuthUtil
release loJson
release loHttp
release loXml