Pascal (Lazarus/Delphi)
Pascal (Lazarus/Delphi)
Peoplevox GetReportData
See more Peoplevox Examples
Demonstrates how to export data from a Peoplevox Warehouse Management System (WMS) using a system report template.Chilkat Pascal (Lazarus/Delphi) Downloads
program ChilkatDemo;
// Demonstrates using the Chilkat Pascal wrapper via the C bridge DLL.
// Builds as a console application under Lazarus (FPC) or Delphi.
{$IFDEF FPC}
{$MODE DELPHI}
{$ENDIF}
{$APPTYPE CONSOLE}
uses
{$IFDEF UNIX}
cthreads,
{$ENDIF}
SysUtils,
CkDllLoader,
Chilkat.Csv,
Chilkat.HttpResponse,
Chilkat.HttpRequest,
Chilkat.StringBuilder,
Chilkat.Xml,
Chilkat.Http;
// ---------------------------------------------------------------------------
procedure RunDemo;
var
success: Boolean;
sbSoapXml: TStringBuilder;
req: THttpRequest;
http: THttp;
resp: THttpResponse;
xmlResponse: TXml;
detail: string;
csv: TCsv;
i: Integer;
numRows: Integer;
begin
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 := TStringBuilder.Create;
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 := THttpRequest.Create;
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 := THttp.Create;
http.FollowRedirects := True;
resp := THttpResponse.Create;
success := http.HttpSReq('qac.peoplevox.net',443,True,req,resp);
if (success = False) then
begin
WriteLn(http.LastErrorText);
Exit;
end;
// We should expect a 200 response if successful.
if (resp.StatusCode <> 200) then
begin
WriteLn('Response StatusCode = ' + resp.StatusCode);
WriteLn('Response StatusLine: ' + resp.StatusLine);
WriteLn('Response Header:');
WriteLn(resp.Header);
WriteLn(resp.BodyStr);
Exit;
end;
xmlResponse := TXml.Create;
success := xmlResponse.LoadXml(resp.BodyStr);
WriteLn(xmlResponse.GetXml());
detail := xmlResponse.ChilkatPath('soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*');
csv := TCsv.Create;
csv.HasColumnNames := True;
csv.LoadFromString(detail);
WriteLn('NumRows = ' + csv.NumRows);
WriteLn('NumColumns = ' + csv.NumColumns);
// Iterate over the rows, getting the ItemCode, Name, and Barcode
i := 0;
numRows := csv.NumRows;
while i < numRows do
begin
WriteLn('Item code: ' + csv.GetCellByName(i,'Item code'));
WriteLn('Date timestamp: ' + csv.GetCellByName(i,'Date timestamp'));
WriteLn('From: ' + csv.GetCellByName(i,'From'));
WriteLn('To: ' + csv.GetCellByName(i,'To'));
WriteLn('Quantity: ' + csv.GetCellByName(i,'Quantity'));
WriteLn('Comments: ' + csv.GetCellByName(i,'Comments'));
WriteLn('-');
i := i + 1;
end;
sbSoapXml.Free;
req.Free;
http.Free;
resp.Free;
xmlResponse.Free;
csv.Free;
end;
// ---------------------------------------------------------------------------
begin
try
RunDemo;
except
on E: Exception do
WriteLn('Unhandled exception: ', E.ClassName, ': ', E.Message);
end;
WriteLn;
{$IFDEF MSWINDOWS}
WriteLn('Press Enter to exit...');
ReadLn;
{$ENDIF}
end.