Ruby Requires Chilkat v11.0.0+

Peoplevox GetReportData

See more Peoplevox Examples

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

require 'chilkat'

success = false

#  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 = Chilkat::CkStringBuilder.new()
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 = Chilkat::CkHttpRequest.new()
req.put_HttpVerb("POST")
req.put_SendCharset(true)
req.put_Charset("utf-8")
req.AddHeader("Content-Type","text/xml")
req.AddHeader("SOAPAction","http://www.peoplevox.net/GetReportData")
req.put_Path("/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx")
success = req.LoadBodyFromString(sbSoapXml.getAsString(),"utf-8")

http = Chilkat::CkHttp.new()
http.put_FollowRedirects(true)

resp = Chilkat::CkHttpResponse.new()
success = http.HttpSReq("qac.peoplevox.net",443,true,req,resp)
if (success == false)
    print http.lastErrorText() + "\n";
    exit
end

#  We should expect a 200 response if successful.
if (resp.get_StatusCode() != 200)
    print "Response StatusCode = " + resp.get_StatusCode().to_s() + "\n";
    print "Response StatusLine: " + resp.statusLine() + "\n";
    print "Response Header:" + "\n";
    print resp.header() + "\n";
    print resp.bodyStr() + "\n";
    exit
end

xmlResponse = Chilkat::CkXml.new()
success = xmlResponse.LoadXml(resp.bodyStr())
print xmlResponse.getXml() + "\n";

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

csv = Chilkat::CkCsv.new()
csv.put_HasColumnNames(true)
csv.LoadFromString(detail)

print "NumRows = " + csv.get_NumRows().to_s() + "\n";
print "NumColumns = " + csv.get_NumColumns().to_s() + "\n";

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