(CkPython) effectconnect Read Orderlist

Get a set of orders filtered by the parameters in the XML payload.

Chilkat Python Downloads install with pip pip3 install chilkat or download... Python Module for Windows, MacOS, Linux, Alpine Linux, Solaris

import sys
import chilkat

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

fullUri = "https://submit.effectconnect.com/orderlist"
uri = "/orderlist"
apiVersion = "2.0"

http = chilkat.CkHttp()

# Use your effectconnect public key here..
http.SetRequestHeader("KEY","PUBLIC_KEY")
http.SetRequestHeader("VERSION",apiVersion)
http.SetRequestHeader("URI",uri)
http.SetRequestHeader("RESPONSETYPE","XML")
http.SetRequestHeader("RESPONSELANGUAGE","en")

# Get the current date/time in timestamp format.
dt = chilkat.CkDateTime()
dt.SetFromCurrentSystemTime()
timestamp = dt.getAsTimestamp(True)

http.SetRequestHeader("TIME",timestamp)
print("timestamp = " + timestamp)

# Create the following XML request body:
# <?xml version="1.0" encoding="utf-8"?>
# <list>
#   <filters>
#     <fromDateFilter>
#       <filterValue>2018-09-14T12:12:12+01:00</filterValue>
#     </fromDateFilter>
#     <toDateFilter>
#       <filterValue>2019-04-13T23:59:59+01:00</filterValue>
#     </toDateFilter>
#     <hasStatusFilter>
#       <filterValue>paid</filterValue>
#     </hasStatusFilter>
#     <hasTagFilter>
#       <filterValue>
#         <tagName>Test</tagName>
#         <exclude>false</exclude>
#       </filterValue>
#     </hasTagFilter>
#   </filters>
# </list>

# Use this online tool to generate the code from sample XML: 
# Generate Code to Create XML

xml = chilkat.CkXml()
xml.put_Tag("list")
xml.UpdateChildContent("filters|fromDateFilter|filterValue","2018-09-14T12:12:12+01:00")
xml.UpdateChildContent("filters|toDateFilter|filterValue","2019-04-13T23:59:59+01:00")
xml.UpdateChildContent("filters|hasStatusFilter|filterValue","paid")
xml.UpdateChildContent("filters|hasTagFilter|filterValue|tagName","Test")
xml.UpdateChildContent("filters|hasTagFilter|filterValue|exclude","false")
xml.put_EmitCompact(True)

sbXml = chilkat.CkStringBuilder()
xml.GetXmlSb(sbXml)

# Build a string-to-sign and sign it using our effectconnect private key
sbStringToSign = chilkat.CkStringBuilder()
sbStringToSign.AppendInt(sbXml.get_Length())
sbStringToSign.Append("POST")
sbStringToSign.Append(uri)
sbStringToSign.Append(apiVersion)
sbStringToSign.Append(timestamp)

crypt = chilkat.CkCrypt2()
crypt.put_MacAlgorithm("hmac")
crypt.put_HashAlgorithm("sha512")
crypt.put_EncodingMode("base64")
# Use your effectconnect private key here:
crypt.SetMacKeyString("PRIVATE_KEY")
http.SetRequestHeader("SIGNATURE",crypt.macStringENC(sbStringToSign.getAsString()))

# Send the POST..
# resp is a CkHttpResponse
resp = http.PostXml(fullUri,xml.getXml(),"utf-8")
if (http.get_LastMethodSuccess() == False):
    print(http.lastErrorText())
    sys.exit()

print("response status code = " + str(resp.get_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.
xmlResp = chilkat.CkXml()
xmlResp.LoadXml(resp.bodyStr())

print("response body:")
print(xmlResp.getXml())

# Remove previously set headers (unless we want the same headers for the next request,
# in which case we may remove or update individual headers by calling SetRequestHeader.
http.ClearHeaders()