(Xojo Plugin) Walmart - Get Inventory for an Item

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

Chilkat Xojo Plugin Download Xojo Plugin for Windows, Linux, Mac OS X, and ARM, ARM64

// ---------------------------------------------------------------------------------------------------------
// 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}

Dim sbUrl As New Chilkat.StringBuilder
Dim success As Boolean
success = sbUrl.Append("https://marketplace.walmartapis.com/v2/inventory?sku={SKU}")
Dim numReplaced As Int32
numReplaced = sbUrl.Replace("{SKU}","HOPP~904~51041")

Dim requestMethod As String
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.
Dim authUtil As New Chilkat.AuthUtil

Dim wmConsumerId As String
wmConsumerId = "WALMART_CONSUMER_ID"
Dim wmPrivateKey As String
wmPrivateKey = "WALMART_PRIVATE_KEY"
Dim jsonStr As String
jsonStr = authUtil.WalmartSignature(sbUrl.GetAsString(),wmConsumerId,wmPrivateKey,requestMethod)
If (authUtil.LastMethodSuccess <> True) Then
    System.DebugLog(authUtil.LastErrorText)
    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
Dim json As New Chilkat.JsonObject
success = json.Load(jsonStr)

Dim http As New Chilkat.Http
http.SetRequestHeader "WM_SVC.NAME","Walmart Marketplace"
http.SetRequestHeader "WM_QOS.CORRELATION_ID",json.StringOf("correlation_id")
http.SetRequestHeader "WM_SEC.TIMESTAMP",json.StringOf("timestamp")
http.SetRequestHeader "WM_SEC.AUTH_SIGNATURE",json.StringOf("signature")
http.SetRequestHeader "WM_CONSUMER.ID",wmConsumerId
http.Accept = "application/xml"

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

Dim xmlStr As String
xmlStr = http.QuickGetStr(sbUrl.GetAsString())
If (http.LastMethodSuccess <> True) Then
    System.DebugLog(http.LastErrorText)
    Return
End If

Dim xml As New Chilkat.Xml
success = xml.LoadXml(xmlStr)

// A successful response should have a 200 response status
If (http.LastStatus <> 200) Then
    System.DebugLog(xml.GetXml())
    System.DebugLog("Response Status Code: " + Str(http.LastStatus))
    System.DebugLog("Failed.")
    Return
End If

// A sample XML response is shown below..
System.DebugLog(xml.GetXml())
System.DebugLog("--")

// To get the quantity:
Dim quantity As Int32
quantity = xml.GetChildIntValue("quantity|amount")
System.DebugLog("quantity = " + Str(quantity))

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