Java 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. Chilkat2 Java

import com.chilkatsoft.chilkat2.ChilkatException;
import com.chilkatsoft.chilkat2.Csv;
import com.chilkatsoft.chilkat2.Http;
import com.chilkatsoft.chilkat2.HttpRequest;
import com.chilkatsoft.chilkat2.HttpResponse;
import com.chilkatsoft.chilkat2.StringBuilder;
import com.chilkatsoft.chilkat2.Xml;

public class ChilkatExample {

    public static void main(String[] args) {
        // 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.
        //
        StringBuilder 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>");

        HttpRequest req = new HttpRequest();
        req.setHttpVerb("POST");
        req.setSendCharset(true);
        req.setCharset("utf-8");
        req.addHeader("Content-Type", "text/xml");
        req.addHeader("SOAPAction", "http://www.peoplevox.net/GetReportData");
        req.setPath("/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx");
        req.loadBodyFromString(sbSoapXml.getAsString(), "utf-8");

        Http http = new Http();
        http.setFollowRedirects(true);

        HttpResponse resp = new HttpResponse();
        try {
            http.httpSReq("qac.peoplevox.net", 443, true, req, resp);
        } catch (ChilkatException e) {
            System.out.println(e.getLastErrorText());
            return;
        }

        // We should expect a 200 response if successful.
        if (resp.getStatusCode() != 200) {
            System.out.println("Response StatusCode = " + resp.getStatusCode());
            System.out.println("Response StatusLine: " + resp.getStatusLine());
            System.out.println("Response Header:");
            System.out.println(resp.getHeader());
            System.out.println(resp.getBodyStr());
            return;
        }

        Xml xmlResponse = new Xml();
        xmlResponse.loadXml(resp.getBodyStr());
        System.out.println(xmlResponse.getXml());

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

        Csv csv = new Csv();
        csv.setHasColumnNames(true);
        csv.loadFromString(detail);

        System.out.println("NumRows = " + csv.getNumRows());
        System.out.println("NumColumns = " + csv.getNumColumns());

        // Iterate over the rows, getting the ItemCode, Name, and Barcode
        int i = 0;
        int numRows = csv.getNumRows();
        while (i < numRows) {
            System.out.println("Item code: " + csv.getCellByName(i, "Item code"));
            System.out.println("Date timestamp: " + csv.getCellByName(i, "Date timestamp"));
            System.out.println("From: " + csv.getCellByName(i, "From"));
            System.out.println("To: " + csv.getCellByName(i, "To"));
            System.out.println("Quantity: " + csv.getCellByName(i, "Quantity"));
            System.out.println("Comments: " + csv.getCellByName(i, "Comments"));
            System.out.println("-");
            i = i + 1;
        }
    }
}