(Chilkat2-Python) Peoplevox GetReportData

Demonstrates how to export data from a Peoplevox Warehouse Management System (WMS) using a system report template.

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

import sys
import chilkat2

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

# Sends a POST that looks like this:

# 	POST /PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx HTTP/1.1
# 	Content-Type: text/xml;charset=UTF-8
# 	SOAPAction: http://www.peoplevox.net/GetReportData
# 	Content-Length: (automatically computed and added by Chilkat)
# 	Host: qac.peoplevox.net
# 
# 	<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:peop="http://www.peoplevox.net/">
# 	   <soap:Header>
# 	      <peop:UserSessionCredentials>
# 	         <peop:UserId>PEOPLEVOX_USER_ID</peop:UserId>
# 	         <peop:ClientId>PEOPLEVOX_CLIENT_ID</peop:ClientId>
# 	         <peop:SessionId>PEOPLEVOX_SESSION_ID</peop:SessionId>
# 	      </peop:UserSessionCredentials>
# 	   </soap:Header>
#         <soap:Body>
#           <peop:GetReportData>
#              <peop:getReportRequest>
#                 <peop:TemplateName>Item movement history</peop:TemplateName>
#                 <peop:PageNo>1</peop:PageNo>
#                 <peop:ItemsPerPage>20</peop:ItemsPerPage>
#                 <peop:OrderBy>[Date timestamp]</peop:OrderBy>
#                 <peop:Columns>[Item code],[Date timestamp],[From],[To],[Quantity],[Comments]</peop:Columns>
#                 <peop:SearchClause>([Date timestamp] > DateTime(2016,01,01,09,00,00))</peop:SearchClause>
#              </peop:getReportRequest>
#           </peop:GetReportData>
#        </soap:Body>
# 	</soap:Envelope>
# 

# Notice that a UserId is needed here.  This is different than the username required for Peoplevox authentication.
#    The UserId for the admin account is 1.
#     
sbSoapXml = chilkat2.StringBuilder()
sbSoapXml.Append("<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n")
sbSoapXml.Append("<soap:Envelope xmlns:soap=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:peop=\"http://www.peoplevox.net/\">\r\n")
sbSoapXml.Append("   <soap:Header>\r\n")
sbSoapXml.Append("      <peop:UserSessionCredentials>\r\n")
sbSoapXml.Append("         <peop:UserId>PEOPLEVOX_USER_ID</peop:UserId>\r\n")
sbSoapXml.Append("         <peop:ClientId>PEOPLEVOX_CLIENT_ID</peop:ClientId>\r\n")
sbSoapXml.Append("         <peop:SessionId>PEOPLEVOX_SESSION_ID</peop:SessionId>\r\n")
sbSoapXml.Append("      </peop:UserSessionCredentials>\r\n")
sbSoapXml.Append("   </soap:Header>\r\n")
sbSoapXml.Append("   <soap:Body>\r\n")
sbSoapXml.Append("      <peop:GetReportData>\r\n")
sbSoapXml.Append("         <peop:getReportRequest>\r\n")
sbSoapXml.Append("            <peop:TemplateName>Item movement history</peop:TemplateName>\r\n")
sbSoapXml.Append("            <peop:PageNo>1</peop:PageNo>\r\n")
sbSoapXml.Append("            <peop:ItemsPerPage>20</peop:ItemsPerPage>\r\n")
sbSoapXml.Append("            <peop:OrderBy>[Date timestamp]</peop:OrderBy>\r\n")
sbSoapXml.Append("            <peop:Columns>[Item code],[Date timestamp],[From],[To],[Quantity],[Comments]</peop:Columns>\r\n")
sbSoapXml.Append("            <peop:SearchClause>([Date timestamp] > DateTime(2016,01,01,09,00,00))</peop:SearchClause>\r\n")
sbSoapXml.Append("         </peop:getReportRequest>\r\n")
sbSoapXml.Append("      </peop:GetReportData>\r\n")
sbSoapXml.Append("   </soap:Body>\r\n")
sbSoapXml.Append("</soap:Envelope>")

req = chilkat2.HttpRequest()
req.HttpVerb = "POST"
req.SendCharset = True
req.Charset = "utf-8"
req.AddHeader("Content-Type","text/xml")
req.AddHeader("SOAPAction","http://www.peoplevox.net/GetReportData")
req.Path = "/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx"
success = req.LoadBodyFromString(sbSoapXml.GetAsString(),"utf-8")

http = chilkat2.Http()
http.FollowRedirects = True

# resp is a CkHttpResponse
resp = http.SynchronousRequest("qac.peoplevox.net",443,True,req)
if (http.LastMethodSuccess != True):
    print(http.LastErrorText)
    sys.exit()

# We should expect a 200 response if successful.
if (resp.StatusCode != 200):
    print("Response StatusCode = " + str(resp.StatusCode))
    print("Response StatusLine: " + resp.StatusLine)
    print("Response Header:")
    print(resp.Header)
    print(resp.BodyStr)
    sys.exit()

xmlResponse = chilkat2.Xml()
success = xmlResponse.LoadXml(resp.BodyStr)
print(xmlResponse.GetXml())

detail = xmlResponse.ChilkatPath("soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*")

csv = chilkat2.Csv()
csv.HasColumnNames = True
csv.LoadFromString(detail)

print("NumRows = " + str(csv.NumRows))
print("NumColumns = " + str(csv.NumColumns))

# Iterate over the rows, getting the ItemCode, Name, and Barcode
i = 0
numRows = csv.NumRows
while i < numRows :
    print("Item code: " + csv.GetCellByName(i,"Item code"))
    print("Date timestamp: " + csv.GetCellByName(i,"Date timestamp"))
    print("From: " + csv.GetCellByName(i,"From"))
    print("To: " + csv.GetCellByName(i,"To"))
    print("Quantity: " + csv.GetCellByName(i,"Quantity"))
    print("Comments: " + csv.GetCellByName(i,"Comments"))
    print("-")
    i = i + 1