C++

Peoplevox GetReportData

See more Peoplevox Examples

Demonstrates how to export data from a Peoplevox Warehouse Management System (WMS) using a system report template. C++

#include <CkStringBuilder.h>
#include <CkHttpRequest.h>
#include <CkHttp.h>
#include <CkHttpResponse.h>
#include <CkXml.h>
#include <CkCsv.h>

void ChilkatSample(void)
    {
    bool success = false;

    //  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.
    //      
    CkStringBuilder sbSoapXml;
    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>");

    CkHttpRequest req;
    req.put_HttpVerb("POST");
    req.put_SendCharset(true);
    req.put_Charset("utf-8");
    req.AddHeader("Content-Type","text/xml");
    req.AddHeader("SOAPAction","http://www.peoplevox.net/GetReportData");
    req.put_Path("/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx");
    success = req.LoadBodyFromString(sbSoapXml.getAsString(),"utf-8");

    CkHttp http;
    http.put_FollowRedirects(true);

    CkHttpResponse resp;
    success = http.HttpSReq("qac.peoplevox.net",443,true,req,resp);
    if (success == false) {
        std::cout << http.lastErrorText() << "\r\n";
        return;
    }

    //  We should expect a 200 response if successful.
    if (resp.get_StatusCode() != 200) {
        std::cout << "Response StatusCode = " << resp.get_StatusCode() << "\r\n";
        std::cout << "Response StatusLine: " << resp.statusLine() << "\r\n";
        std::cout << "Response Header:" << "\r\n";
        std::cout << resp.header() << "\r\n";
        std::cout << resp.bodyStr() << "\r\n";
        return;
    }

    CkXml xmlResponse;
    success = xmlResponse.LoadXml(resp.bodyStr());
    std::cout << xmlResponse.getXml() << "\r\n";

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

    CkCsv csv;
    csv.put_HasColumnNames(true);
    csv.LoadFromString(detail);

    std::cout << "NumRows = " << csv.get_NumRows() << "\r\n";
    std::cout << "NumColumns = " << csv.get_NumColumns() << "\r\n";

    //  Iterate over the rows, getting the ItemCode, Name, and Barcode
    int i = 0;
    int numRows = csv.get_NumRows();
    while (i < numRows) {
        std::cout << "Item code: " << csv.getCellByName(i,"Item code") << "\r\n";
        std::cout << "Date timestamp: " << csv.getCellByName(i,"Date timestamp") << "\r\n";
        std::cout << "From: " << csv.getCellByName(i,"From") << "\r\n";
        std::cout << "To: " << csv.getCellByName(i,"To") << "\r\n";
        std::cout << "Quantity: " << csv.getCellByName(i,"Quantity") << "\r\n";
        std::cout << "Comments: " << csv.getCellByName(i,"Comments") << "\r\n";
        std::cout << "-" << "\r\n";
        i = i + 1;
    }
    }