(Excel) Walmart v3 Bulk Item Setup

Updates items in bulk.

For more information, see https://developer.walmart.com/#/apicenter/marketPlace/latest#bulkCreateUpdateItems

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Implements the following CURL command:

' curl -X POST \
'   https://marketplace.walmartapis.com/v3/feeds?feedType=item \
'   -H 'WM_SVC.NAME: Walmart Marketplace'
'   -H 'WM_SEC.ACCESS_TOKEN: eyJraWQiOiIzZjVhYTFmNS1hYWE5LTQzM.....'
'   -H 'WM_QOS.CORRELATION_ID: b3261d2d-028a-4ef7-8602-633c23200af6'
'   -H 'Content-Type: multipart/form-data'
'   -H 'Accept: application/xml'
'   -F feed=@qa_data/walmart/itemFeed.xml

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.HttpVerb = "POST"
req.Path = "/v3/feeds?feedType=item"
req.ContentType = "multipart/form-data"
success = req.AddFileForUpload2("feed","qa_data/walmart/itemFeed.xml","application/xml")

req.AddHeader "WM_QOS.CORRELATION_ID","b3261d2d-028a-4ef7-8602-633c23200af6"
req.AddHeader "Expect","100-continue"
req.AddHeader "Content-Type","multipart/form-data"
req.AddHeader "WM_SEC.ACCESS_TOKEN","eyJraWQiOiIzZjVhYTFmNS1hYWE5LTQzM....."
req.AddHeader "Accept","application/xml"
req.AddHeader "WM_SVC.NAME","Walmart Marketplace"


Set resp = http.SynchronousRequest("marketplace.walmartapis.com",443,True,req)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = resp.GetBodySb(sbResponseBody)

Dim xmlResponse As Chilkat.Xml
Set xmlResponse = Chilkat.NewXml
success = xmlResponse.LoadSb(sbResponseBody,True)
Debug.Print xmlResponse.GetXml()

' Sample XML response:
' (Sample code for parsing the XML response is shown below)

' <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
' <FeedAcknowledgement xmlns:ns2="http://walmart.com/">
'     <feedId>E9C04D1FFD99479FBC1341D56DD5F930@AQMB_wA</feedId>
' </FeedAcknowledgement>

' Sample code for parsing the XML response...
' Use the following online tool to generate parsing code from sample XML:
' Generate Parsing Code from XML

FeedAcknowledgement_xmlns_ns2 = xmlResponse.GetAttrValue("xmlns:ns2")
feedId = xmlResponse.GetChildContent("feedId")