(VBScript) Walmart - Get Inventory for an Item

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

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

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbUrl = CreateObject("Chilkat.StringBuilder")
success = sbUrl.Append("https://marketplace.walmartapis.com/v2/inventory?sku={SKU}")
numReplaced = sbUrl.Replace("{SKU}","HOPP~904~51041")

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.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.AuthUtil")
set authUtil = CreateObject("Chilkat.AuthUtil")

wmConsumerId = "WALMART_CONSUMER_ID"
wmPrivateKey = "WALMART_PRIVATE_KEY"
jsonStr = authUtil.WalmartSignature(sbUrl.GetAsString(),wmConsumerId,wmPrivateKey,requestMethod)
If (authUtil.LastMethodSuccess <> 1) Then
    outFile.WriteLine(authUtil.LastErrorText)
    WScript.Quit
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
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set json = CreateObject("Chilkat.JsonObject")
success = json.Load(jsonStr)

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("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.

xmlStr = http.QuickGetStr(sbUrl.GetAsString())
If (http.LastMethodSuccess <> 1) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Xml")
set xml = CreateObject("Chilkat.Xml")
success = xml.LoadXml(xmlStr)

' A successful response should have a 200 response status
If (http.LastStatus <> 200) Then
    outFile.WriteLine(xml.GetXml())
    outFile.WriteLine("Response Status Code: " & http.LastStatus)
    outFile.WriteLine("Failed.")
    WScript.Quit
End If

' A sample XML response is shown below..
outFile.WriteLine(xml.GetXml())
outFile.WriteLine("--")

' To get the quantity:
quantity = xml.GetChildIntValue("quantity|amount")
outFile.WriteLine("quantity = " & 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>

outFile.Close