Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Node.js) Peoplevox GetReportDataDemonstrates how to export data from a Peoplevox Warehouse Management System (WMS) using a system report template.
var os = require('os'); if (os.platform() == 'win32') { if (os.arch() == 'ia32') { var chilkat = require('@chilkat/ck-node21-win-ia32'); } else { var chilkat = require('@chilkat/ck-node21-win64'); } } else if (os.platform() == 'linux') { if (os.arch() == 'arm') { var chilkat = require('@chilkat/ck-node21-arm'); } else if (os.arch() == 'x86') { var chilkat = require('@chilkat/ck-node21-linux32'); } else { var chilkat = require('@chilkat/ck-node21-linux64'); } } else if (os.platform() == 'darwin') { if (os.arch() == 'arm64') { var chilkat = require('@chilkat/ck-node21-mac-m1'); } else { var chilkat = require('@chilkat/ck-node21-macosx'); } } function chilkatExample() { // This example requires the Chilkat API to have been previously unlocked. // See Global Unlock Sample for sample code. var success; // 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. // var sbSoapXml = new chilkat.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>"); var req = new chilkat.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"; success = req.LoadBodyFromString(sbSoapXml.GetAsString(),"utf-8"); var http = new chilkat.Http(); http.FollowRedirects = true; // resp: HttpResponse var resp = http.SynchronousRequest("qac.peoplevox.net",443,true,req); if (http.LastMethodSuccess !== true) { 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; } var xmlResponse = new chilkat.Xml(); success = xmlResponse.LoadXml(resp.BodyStr); console.log(xmlResponse.GetXml()); var detail = xmlResponse.ChilkatPath("soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*"); var csv = new chilkat.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 var i = 0; var 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 = i+1; } } chilkatExample(); |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.