(Delphi ActiveX) Peoplevox GetReportData

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

Chilkat for Delphi Downloads Chilkat ActiveX DLL for Delphi Chilkat non-ActiveX DLL for Delphi * The examples here use the ActiveX DLL.

uses
    Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
    Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Chilkat_TLB;

...

procedure TForm1.Button1Click(Sender: TObject);
var
success: Integer;
sbSoapXml: TChilkatStringBuilder;
req: TChilkatHttpRequest;
http: TChilkatHttp;
resp: IChilkatHttpResponse;
xmlResponse: TChilkatXml;
detail: WideString;
csv: TChilkatCsv;
i: Integer;
numRows: Integer;

begin
// 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 := TChilkatStringBuilder.Create(Self);
sbSoapXml.Append('<?xml version="1.0" encoding="utf-8"?>' + #13#10);
sbSoapXml.Append('<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:peop="http://www.peoplevox.net/">' + #13#10);
sbSoapXml.Append('   <soap:Header>' + #13#10);
sbSoapXml.Append('      <peop:UserSessionCredentials>' + #13#10);
sbSoapXml.Append('         <peop:UserId>PEOPLEVOX_USER_ID</peop:UserId>' + #13#10);
sbSoapXml.Append('         <peop:ClientId>PEOPLEVOX_CLIENT_ID</peop:ClientId>' + #13#10);
sbSoapXml.Append('         <peop:SessionId>PEOPLEVOX_SESSION_ID</peop:SessionId>' + #13#10);
sbSoapXml.Append('      </peop:UserSessionCredentials>' + #13#10);
sbSoapXml.Append('   </soap:Header>' + #13#10);
sbSoapXml.Append('   <soap:Body>' + #13#10);
sbSoapXml.Append('      <peop:GetReportData>' + #13#10);
sbSoapXml.Append('         <peop:getReportRequest>' + #13#10);
sbSoapXml.Append('            <peop:TemplateName>Item movement history</peop:TemplateName>' + #13#10);
sbSoapXml.Append('            <peop:PageNo>1</peop:PageNo>' + #13#10);
sbSoapXml.Append('            <peop:ItemsPerPage>20</peop:ItemsPerPage>' + #13#10);
sbSoapXml.Append('            <peop:OrderBy>[Date timestamp]</peop:OrderBy>' + #13#10);
sbSoapXml.Append('            <peop:Columns>[Item code],[Date timestamp],[From],[To],[Quantity],[Comments]</peop:Columns>' + #13#10);
sbSoapXml.Append('            <peop:SearchClause>([Date timestamp] > DateTime(2016,01,01,09,00,00))</peop:SearchClause>' + #13#10);
sbSoapXml.Append('         </peop:getReportRequest>' + #13#10);
sbSoapXml.Append('      </peop:GetReportData>' + #13#10);
sbSoapXml.Append('   </soap:Body>' + #13#10);
sbSoapXml.Append('</soap:Envelope>');

req := TChilkatHttpRequest.Create(Self);
req.HttpVerb := 'POST';
req.SendCharset := 1;
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 := TChilkatHttp.Create(Self);
http.FollowRedirects := 1;

resp := http.SynchronousRequest('qac.peoplevox.net',443,1,req.ControlInterface);
if (http.LastMethodSuccess <> 1) then
  begin
    Memo1.Lines.Add(http.LastErrorText);
    Exit;
  end;

// We should expect a 200 response if successful.
if (resp.StatusCode <> 200) then
  begin
    Memo1.Lines.Add('Response StatusCode = ' + IntToStr(resp.StatusCode));
    Memo1.Lines.Add('Response StatusLine: ' + resp.StatusLine);
    Memo1.Lines.Add('Response Header:');
    Memo1.Lines.Add(resp.Header);
    Memo1.Lines.Add(resp.BodyStr);
    Exit;
  end;

xmlResponse := TChilkatXml.Create(Self);
success := xmlResponse.LoadXml(resp.BodyStr);
Memo1.Lines.Add(xmlResponse.GetXml());

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

csv := TChilkatCsv.Create(Self);
csv.HasColumnNames := 1;
csv.LoadFromString(detail);

Memo1.Lines.Add('NumRows = ' + IntToStr(csv.NumRows));
Memo1.Lines.Add('NumColumns = ' + IntToStr(csv.NumColumns));

// Iterate over the rows, getting the ItemCode, Name, and Barcode
i := 0;
numRows := csv.NumRows;
while i < numRows do
  begin
    Memo1.Lines.Add('Item code: ' + csv.GetCellByName(i,'Item code'));
    Memo1.Lines.Add('Date timestamp: ' + csv.GetCellByName(i,'Date timestamp'));
    Memo1.Lines.Add('From: ' + csv.GetCellByName(i,'From'));
    Memo1.Lines.Add('To: ' + csv.GetCellByName(i,'To'));
    Memo1.Lines.Add('Quantity: ' + csv.GetCellByName(i,'Quantity'));
    Memo1.Lines.Add('Comments: ' + csv.GetCellByName(i,'Comments'));
    Memo1.Lines.Add('-');
    i := i + 1;
  end;
end;