(Excel) Walmart - Get a FeedItem's Status

Demonstrates how to get a Walmart feedItem's status.

Note: This example requires Chilkat v9.5.0.67 or greater.

Download Excel Class Modules Chilkat Excel Class Modules

' 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/feeds/feeditems/{feedId}?includeDetails={includeDetails}&limit={limit}

Dim sbUrl As Chilkat.StringBuilder
Set sbUrl = Chilkat.NewStringBuilder

success = sbUrl.Append("https://marketplace.walmartapis.com/v2/feeds/feeditems/{feedId}?includeDetails={includeDetails}&limit={limit}")

numReplaced = sbUrl.Replace("{feedId}","AAAA7F0345E9403C91223F7139FFC341@AQsBAQA")
numReplaced = sbUrl.Replace("{includeDetails}","true")
numReplaced = sbUrl.ReplaceI("{limit}",3)


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 Chilkat.AuthUtil
Set authUtil = Chilkat.NewAuthUtil


wmConsumerId = "WALMART_CONSUMER_ID"

wmPrivateKey = "WALMART_PRIVATE_KEY"

jsonStr = authUtil.WalmartSignature(sbUrl.GetAsString(),wmConsumerId,wmPrivateKey,requestMethod)
If (authUtil.LastMethodSuccess <> True) Then
    Debug.Print authUtil.LastErrorText
    Exit Sub
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 Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load(jsonStr)

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp
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 <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

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

' A successful response should have a 200 response status
If (http.LastStatus <> 200) Then
    Debug.Print xml.GetXml()
    Debug.Print "Response Status Code: "; http.LastStatus
    Debug.Print "Failed."
    Exit Sub
End If

' A sample XML response is shown below..
Debug.Print xml.GetXml()
Debug.Print "--"

' To iterate over the ingestion statuses:

numIngestionStatuses = xml.NumChildrenAt("ns2:elements|ns2:itemDetails")

i = 0
Do While i < numIngestionStatuses
    xml.I = i

    Debug.Print "sku: "; xml.GetChildContent("ns2:elements|ns2:itemDetails|ns2:itemIngestionStatus[i]|ns2:sku")
    Debug.Print "status: "; xml.GetChildContent("ns2:elements|ns2:itemDetails|ns2:itemIngestionStatus[i]|ns2:ingestionStatus")
    Debug.Print "--"

    i = i + 1
Loop

Debug.Print "Success."

' ---------------------------------------
' Sample XML response
' ---------------------------------------

' <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
' <ns2:ItemStatusDetail xmlns:ns2="http://walmart.com/">
'     <ns2:meta>
'         <ns2:feedId>AAAAF0345E9403C91223F7139FFC341@AQsBAQA</ns2:feedId>
'         <ns2:feedStatus>PROCESSED</ns2:feedStatus>
'         <ns2:ingestionErrors />
'         <ns2:itemsReceived>130088</ns2:itemsReceived>
'         <ns2:itemsSucceeded>113154</ns2:itemsSucceeded>
'         <ns2:itemsFailed>16934</ns2:itemsFailed>
'         <ns2:itemsProcessing>0</ns2:itemsProcessing>
'         <ns2:limit>3</ns2:limit>
'         <ns2:totalCount>3</ns2:totalCount>
'         <ns2:nextCursor>includeDetails=true&amp;limit=3&amp;skuOffset=ENC%28%2F8D%2FyDen1ByXGA7EsWkArA%3D%3D%29</ns2:nextCursor>
'     </ns2:meta>
'     <ns2:elements>
'         <ns2:itemDetails>
'             <ns2:itemIngestionStatus>
'                 <ns2:martId>0</ns2:martId>
'                 <ns2:sku>0000~0~00141</ns2:sku>
'                 <ns2:index>0</ns2:index>
'                 <ns2:ingestionStatus>DATA_ERROR</ns2:ingestionStatus>
'                 <ns2:ingestionErrors>
'                     <ns2:ingestionError>
'                         <ns2:type>DATA_ERROR</ns2:type>
'                         <ns2:code>PIVI_021</ns2:code>
'                         <ns2:description>No item found with the given SKU.</ns2:description>
'                     </ns2:ingestionError>
'                 </ns2:ingestionErrors>
'             </ns2:itemIngestionStatus>
'             <ns2:itemIngestionStatus>
'                 <ns2:martId>0</ns2:martId>
'                 <ns2:sku>0000~0~03472</ns2:sku>
'                 <ns2:index>1</ns2:index>
'                 <ns2:ingestionStatus>SUCCESS</ns2:ingestionStatus>
'                 <ns2:ingestionErrors />
'             </ns2:itemIngestionStatus>
'             <ns2:itemIngestionStatus>
'                 <ns2:martId>0</ns2:martId>
'                 <ns2:sku>0000~0~08540</ns2:sku>
'                 <ns2:index>2</ns2:index>
'                 <ns2:ingestionStatus>SUCCESS</ns2:ingestionStatus>
'                 <ns2:ingestionErrors />
'             </ns2:itemIngestionStatus>
'         </ns2:itemDetails>
'     </ns2:elements>
' </ns2:ItemStatusDetail>