React Native 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. React Native

import { Csv, Http, HttpRequest, HttpResponse, StringBuilder, Xml } from '@chilkat/react-native'

async function chilkatExample() {
  // 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.
  //     
  const sbSoapXml = new StringBuilder();
  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>');

  const req = new HttpRequest();
  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');

  const http = new Http();
  http.followRedirects = true;

  const resp = new HttpResponse();
  try {
    await http.httpSReqAsync('qac.peoplevox.net', 443, true, req, resp);
  } catch {
    console.log(http.lastErrorText);
    return;
  }

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

  const xmlResponse = new Xml();
  xmlResponse.loadXml(resp.bodyStr);
  console.log(xmlResponse.getXml());

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

  const csv = new Csv();
  csv.hasColumnNames = true;
  csv.loadFromString(detail);

  console.log(`NumRows = ${csv.numRows}`);
  console.log(`NumColumns = ${csv.numColumns}`);

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