(Excel) effectconnect Product Update

Use this call to update a product (f.e. stock or price) in EffectConnect.

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.


uri = "/products"

apiVersion = "2.0"

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp
Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest

' Use your effectconnect public key here...
req.AddHeader "KEY","PUBLIC_KEY"
req.AddHeader "VERSION",apiVersion
req.AddHeader "URI",uri
req.AddHeader "RESPONSETYPE","XML"
req.AddHeader "RESPONSELANGUAGE","en"

' Get the current date/time in timestamp format.
Dim dt As Chilkat.CkDateTime
Set dt = Chilkat.NewCkDateTime
success = dt.SetFromCurrentSystemTime()

timestamp = dt.GetAsTimestamp(True)

req.AddHeader "TIME",timestamp
Debug.Print "timestamp = "; timestamp

Dim sbXml As Chilkat.StringBuilder
Set sbXml = Chilkat.NewStringBuilder
success = sbXml.LoadFile("qa_data/xml/effectconnect/effconUpdate.xml","utf-8")
Debug.Print "length = "; sbXml.Length

req.HttpVerb = "PUT"
req.Path = uri
req.ContentType = "multipart/form-data"
success = req.AddStringForUpload("payload","effconUpdate.xml",sbXml.GetAsString(),"utf-8")
If (success = False) Then
    Debug.Print req.LastErrorText
    Exit Sub
End If

' Build a string-to-sign and sign it using our effectconnect private key
Dim sbStringToSign As Chilkat.StringBuilder
Set sbStringToSign = Chilkat.NewStringBuilder
success = sbStringToSign.AppendInt(sbXml.Length)
success = sbStringToSign.Append("PUT")
success = sbStringToSign.Append(uri)
success = sbStringToSign.Append(apiVersion)
success = sbStringToSign.Append(timestamp)

Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2
crypt.MacAlgorithm = "hmac"
crypt.HashAlgorithm = "sha512"
crypt.EncodingMode = "base64"
' Use your effectconnect private key here:
success = crypt.SetMacKeyString("PRIVATE_KEY")
req.AddHeader "SIGNATURE",crypt.MacStringENC(sbStringToSign.GetAsString())


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

Debug.Print "response status code = "; resp.StatusCode

' Examine the response.  The response status code can be 200 for both errors and success.
' The success or error is based on the XML returned in the response body.
Dim xmlResp As Chilkat.Xml
Set xmlResp = Chilkat.NewXml
success = xmlResp.LoadXml(resp.BodyStr)

Debug.Print "response body:"
Debug.Print xmlResp.GetXml()

' A sample response:

' <?xml version="1.0" encoding="utf-8"?>
' <ApiResponseContainer>
'     <Request>
'         <RequestType>Products</RequestType>
'         <RequestAction>Update</RequestAction>
'         <RequestVersion>2.0</RequestVersion>
'         <RequestIdentifier/>
'         <ProcessedAt>2019-04-18T15:37:32+02:00</ProcessedAt>
'     </Request>
'     <Response>
'         <Result>Success</Result>
'         <ProductsUpdateResponseContainer>
'             <ProcessID><![CDATA[f81ngzD2S7gooFk3]]></ProcessID>
'         </ProductsUpdateResponseContainer>
'     </Response>
' </ApiResponseContainer>
' 

RequestType = xmlResp.GetChildContent("Request|RequestType")
RequestAction = xmlResp.GetChildContent("Request|RequestAction")
RequestVersion = xmlResp.GetChildContent("Request|RequestVersion")
ProcessedAt = xmlResp.GetChildContent("Request|ProcessedAt")
Result = xmlResp.GetChildContent("Response|Result")
ProcessID = xmlResp.GetChildContent("Response|ProductsUpdateResponseContainer|ProcessID")