Delphi ActiveX
Delphi ActiveX
Peoplevox GetReportData
See more Peoplevox Examples
Demonstrates how to export data from a Peoplevox Warehouse Management System (WMS) using a system report template.Chilkat Delphi ActiveX Downloads
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: TChilkatHttpResponse;
xmlResponse: TChilkatXml;
detail: WideString;
csv: TChilkatCsv;
i: Integer;
numRows: Integer;
begin
success := 0;
// 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 := TChilkatHttpResponse.Create(Self);
success := http.HttpSReq('qac.peoplevox.net',443,1,req.ControlInterface,resp.ControlInterface);
if (success = 0) 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;