(PowerBuilder) Walmart - Update Inventory for an Item

Demonstrates how to update inventory for an item.

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

integer li_rc
oleobject loo_SbUrl
integer li_Success
integer li_NumReplaced
string ls_RequestMethod
oleobject loo_AuthUtil
string ls_WmConsumerId
string ls_WmPrivateKey
string ls_JsonStr
oleobject loo_Json
oleobject loo_Http
integer li_OriginalAmount
oleobject loo_XmlBody
string ls_XmlStr
oleobject loo_Xml

// ---------------------------------------------------------------------------------------------------------
// 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 PUT request:
// PUT https://marketplace.walmartapis.com/v2/inventory?sku={SKU}

loo_SbUrl = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbUrl.ConnectToNewObject("Chilkat.StringBuilder")
if li_rc < 0 then
    destroy loo_SbUrl
    MessageBox("Error","Connecting to COM object failed")
    return
end if
li_Success = loo_SbUrl.Append("https://marketplace.walmartapis.com/v2/inventory?sku={SKU}")
li_NumReplaced = loo_SbUrl.Replace("{SKU}","HOPP~~904~~51041")

ls_RequestMethod = "PUT"

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

ls_WmConsumerId = "WALMART_CONSUMER_ID"
ls_WmPrivateKey = "WALMART_PRIVATE_KEY"
ls_JsonStr = loo_AuthUtil.WalmartSignature(loo_SbUrl.GetAsString(),ls_WmConsumerId,ls_WmPrivateKey,ls_RequestMethod)
if loo_AuthUtil.LastMethodSuccess <> 1 then
    Write-Debug loo_AuthUtil.LastErrorText
    destroy loo_SbUrl
    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.

// The body of the PUT request will be XML that looks like this:

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

// Build the XML request body:
li_OriginalAmount = 234

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

loo_XmlBody.Tag = "wm:inventory"
loo_XmlBody.AddAttribute("xmlns:wm","http://walmart.com/")
loo_XmlBody.UpdateChildContent("wm:sku","HOPP~~904~~51041")
loo_XmlBody.UpdateChildContent("wm:quantity|wm:unit","EACH")
loo_XmlBody.UpdateChildContentInt("wm:quantity|wm:amount",li_OriginalAmount + 1)
loo_XmlBody.UpdateChildContent("wm:fulfillmentLagTime","5")

Write-Debug "PUT request body:"
Write-Debug loo_XmlBody.GetXml()
Write-Debug "--"

// This is a simple PUT that can be sent w/ the PutText method.
ls_XmlStr = loo_Http.PutText(loo_SbUrl.GetAsString(),loo_XmlBody.GetXml(),"utf-8","application/xml",0,0)
if loo_Http.LastMethodSuccess <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_SbUrl
    destroy loo_AuthUtil
    destroy loo_Json
    destroy loo_Http
    destroy loo_XmlBody
    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_SbUrl
    destroy loo_AuthUtil
    destroy loo_Json
    destroy loo_Http
    destroy loo_XmlBody
    destroy loo_Xml
    return
end if

// A sample XML response is shown below..
Write-Debug loo_Xml.GetXml()
Write-Debug "--"
Write-Debug "Success!"

// ---------------------------------------
// 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>235</amount>
//     </quantity>
//     <fulfillmentLagTime>5</fulfillmentLagTime>
// </inventory>


destroy loo_SbUrl
destroy loo_AuthUtil
destroy loo_Json
destroy loo_Http
destroy loo_XmlBody
destroy loo_Xml