(C) Peoplevox GetReportData

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

Note: This example requires Chilkat v11.0.0 or greater.

Chilkat C/C++ Library Downloads
MS Visual C/C++ C++ Builder Linux C/C++ Alpine Linux C/C++	MacOS C/C++ iOS C/C++ Android C/C++ MinGW C/C++

#include <C_CkStringBuilder.h>
#include <C_CkHttpRequest.h>
#include <C_CkHttp.h>
#include <C_CkHttpResponse.h>
#include <C_CkXml.h>
#include <C_CkCsv.h>

void ChilkatSample(void)
    {
    BOOL success;
    HCkStringBuilder sbSoapXml;
    HCkHttpRequest req;
    HCkHttp http;
    HCkHttpResponse resp;
    HCkXml xmlResponse;
    const char *detail;
    HCkCsv csv;
    int i;
    int numRows;

    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.
    //     
    sbSoapXml = CkStringBuilder_Create();
    CkStringBuilder_Append(sbSoapXml,"<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n");
    CkStringBuilder_Append(sbSoapXml,"<soap:Envelope xmlns:soap=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:peop=\"http://www.peoplevox.net/\">\r\n");
    CkStringBuilder_Append(sbSoapXml,"   <soap:Header>\r\n");
    CkStringBuilder_Append(sbSoapXml,"      <peop:UserSessionCredentials>\r\n");
    CkStringBuilder_Append(sbSoapXml,"         <peop:UserId>PEOPLEVOX_USER_ID</peop:UserId>\r\n");
    CkStringBuilder_Append(sbSoapXml,"         <peop:ClientId>PEOPLEVOX_CLIENT_ID</peop:ClientId>\r\n");
    CkStringBuilder_Append(sbSoapXml,"         <peop:SessionId>PEOPLEVOX_SESSION_ID</peop:SessionId>\r\n");
    CkStringBuilder_Append(sbSoapXml,"      </peop:UserSessionCredentials>\r\n");
    CkStringBuilder_Append(sbSoapXml,"   </soap:Header>\r\n");
    CkStringBuilder_Append(sbSoapXml,"   <soap:Body>\r\n");
    CkStringBuilder_Append(sbSoapXml,"      <peop:GetReportData>\r\n");
    CkStringBuilder_Append(sbSoapXml,"         <peop:getReportRequest>\r\n");
    CkStringBuilder_Append(sbSoapXml,"            <peop:TemplateName>Item movement history</peop:TemplateName>\r\n");
    CkStringBuilder_Append(sbSoapXml,"            <peop:PageNo>1</peop:PageNo>\r\n");
    CkStringBuilder_Append(sbSoapXml,"            <peop:ItemsPerPage>20</peop:ItemsPerPage>\r\n");
    CkStringBuilder_Append(sbSoapXml,"            <peop:OrderBy>[Date timestamp]</peop:OrderBy>\r\n");
    CkStringBuilder_Append(sbSoapXml,"            <peop:Columns>[Item code],[Date timestamp],[From],[To],[Quantity],[Comments]</peop:Columns>\r\n");
    CkStringBuilder_Append(sbSoapXml,"            <peop:SearchClause>([Date timestamp] > DateTime(2016,01,01,09,00,00))</peop:SearchClause>\r\n");
    CkStringBuilder_Append(sbSoapXml,"         </peop:getReportRequest>\r\n");
    CkStringBuilder_Append(sbSoapXml,"      </peop:GetReportData>\r\n");
    CkStringBuilder_Append(sbSoapXml,"   </soap:Body>\r\n");
    CkStringBuilder_Append(sbSoapXml,"</soap:Envelope>");

    req = CkHttpRequest_Create();
    CkHttpRequest_putHttpVerb(req,"POST");
    CkHttpRequest_putSendCharset(req,TRUE);
    CkHttpRequest_putCharset(req,"utf-8");
    CkHttpRequest_AddHeader(req,"Content-Type","text/xml");
    CkHttpRequest_AddHeader(req,"SOAPAction","http://www.peoplevox.net/GetReportData");
    CkHttpRequest_putPath(req,"/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx");
    success = CkHttpRequest_LoadBodyFromString(req,CkStringBuilder_getAsString(sbSoapXml),"utf-8");

    http = CkHttp_Create();
    CkHttp_putFollowRedirects(http,TRUE);

    resp = CkHttpResponse_Create();
    success = CkHttp_HttpSReq(http,"qac.peoplevox.net",443,TRUE,req,resp);
    if (success == FALSE) {
        printf("%s\n",CkHttp_lastErrorText(http));
        CkStringBuilder_Dispose(sbSoapXml);
        CkHttpRequest_Dispose(req);
        CkHttp_Dispose(http);
        CkHttpResponse_Dispose(resp);
        return;
    }

    // We should expect a 200 response if successful.
    if (CkHttpResponse_getStatusCode(resp) != 200) {
        printf("Response StatusCode = %d\n",CkHttpResponse_getStatusCode(resp));
        printf("Response StatusLine: %s\n",CkHttpResponse_statusLine(resp));
        printf("Response Header:\n");
        printf("%s\n",CkHttpResponse_header(resp));
        printf("%s\n",CkHttpResponse_bodyStr(resp));
        CkStringBuilder_Dispose(sbSoapXml);
        CkHttpRequest_Dispose(req);
        CkHttp_Dispose(http);
        CkHttpResponse_Dispose(resp);
        return;
    }

    xmlResponse = CkXml_Create();
    success = CkXml_LoadXml(xmlResponse,CkHttpResponse_bodyStr(resp));
    printf("%s\n",CkXml_getXml(xmlResponse));

    detail = CkXml_chilkatPath(xmlResponse,"soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*");

    csv = CkCsv_Create();
    CkCsv_putHasColumnNames(csv,TRUE);
    CkCsv_LoadFromString(csv,detail);

    printf("NumRows = %d\n",CkCsv_getNumRows(csv));
    printf("NumColumns = %d\n",CkCsv_getNumColumns(csv));

    // Iterate over the rows, getting the ItemCode, Name, and Barcode
    i = 0;
    numRows = CkCsv_getNumRows(csv);
    while (i < numRows) {
        printf("Item code: %s\n",CkCsv_getCellByName(csv,i,"Item code"));
        printf("Date timestamp: %s\n",CkCsv_getCellByName(csv,i,"Date timestamp"));
        printf("From: %s\n",CkCsv_getCellByName(csv,i,"From"));
        printf("To: %s\n",CkCsv_getCellByName(csv,i,"To"));
        printf("Quantity: %s\n",CkCsv_getCellByName(csv,i,"Quantity"));
        printf("Comments: %s\n",CkCsv_getCellByName(csv,i,"Comments"));
        printf("-\n");
        i = i + 1;
    }



    CkStringBuilder_Dispose(sbSoapXml);
    CkHttpRequest_Dispose(req);
    CkHttp_Dispose(http);
    CkHttpResponse_Dispose(resp);
    CkXml_Dispose(xmlResponse);
    CkCsv_Dispose(csv);

    }