Dart 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. Dart

import 'package:chilkat/chilkat.dart';

void main() {
  // 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.
  //     
  final sbSoapXml = CkStringBuilder();
  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>');

  final req = CkHttpRequest();
  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';
  req.loadBodyFromString(sbSoapXml.getAsString(), 'utf-8');

  final http = CkHttp();
  http.followRedirects = true;

  final resp = CkHttpResponse();
  try {
    http.httpSReq('qac.peoplevox.net', 443, true, req, resp);
  } on ChilkatException catch (e) {
    print(e.lastErrorText);
    return;
  }

  // We should expect a 200 response if successful.
  if (resp.statusCode != 200) {
    print('Response StatusCode = ${resp.statusCode}');
    print('Response StatusLine: ${resp.statusLine}');
    print('Response Header:');
    print(resp.header);
    print(resp.bodyStr);
    return;
  }

  final xmlResponse = CkXml();
  xmlResponse.loadXml(resp.bodyStr);
  print(xmlResponse.getXml());

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

  final csv = CkCsv();
  csv.hasColumnNames = true;
  csv.loadFromString(detail);

  print('NumRows = ${csv.numRows}');
  print('NumColumns = ${csv.numColumns}');

  // Iterate over the rows, getting the ItemCode, Name, and Barcode
  var i = 0;
  final numRows = csv.numRows;
  while (i < numRows) {
    print('Item code: ${csv.getCellByName(i, 'Item code')}');
    print('Date timestamp: ${csv.getCellByName(i, 'Date timestamp')}');
    print('From: ${csv.getCellByName(i, 'From')}');
    print('To: ${csv.getCellByName(i, 'To')}');
    print('Quantity: ${csv.getCellByName(i, 'Quantity')}');
    print('Comments: ${csv.getCellByName(i, 'Comments')}');
    print('-');
    i++;
  }
}