(Perl) Peoplevox GetReportData

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

Chilkat Perl Downloads Perl Module for Windows, MacOS, Linux, Alpine Linux, Solaris

use chilkat();

# 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(1);
$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(1);

# resp is a HttpResponse
$resp = $http->SynchronousRequest("qac.peoplevox.net",443,1,$req);
if ($http->get_LastMethodSuccess() != 1) {
    print $http->lastErrorText() . "\r\n";
    exit;
}

# We should expect a 200 response if successful.
if ($resp->get_StatusCode() != 200) {
    print "Response StatusCode = " . $resp->get_StatusCode() . "\r\n";
    print "Response StatusLine: " . $resp->statusLine() . "\r\n";
    print "Response Header:" . "\r\n";
    print $resp->header() . "\r\n";
    print $resp->bodyStr() . "\r\n";
    exit;
}

$xmlResponse = chilkat::CkXml->new();
$success = $xmlResponse->LoadXml($resp->bodyStr());
print $xmlResponse->getXml() . "\r\n";

$detail = $xmlResponse->chilkatPath("soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*");

$csv = chilkat::CkCsv->new();
$csv->put_HasColumnNames(1);
$csv->LoadFromString($detail);

print "NumRows = " . $csv->get_NumRows() . "\r\n";
print "NumColumns = " . $csv->get_NumColumns() . "\r\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") . "\r\n";
    print "Date timestamp: " . $csv->getCellByName($i,"Date timestamp") . "\r\n";
    print "From: " . $csv->getCellByName($i,"From") . "\r\n";
    print "To: " . $csv->getCellByName($i,"To") . "\r\n";
    print "Quantity: " . $csv->getCellByName($i,"Quantity") . "\r\n";
    print "Comments: " . $csv->getCellByName($i,"Comments") . "\r\n";
    print "-" . "\r\n";
    $i = $i + 1;
}