(Unicode C) Peoplevox GetReportData

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

Chilkat C/C++ Library Downloads
MS Visual C/C++ Linux/CentOS C/C++ Alpine Linux C/C++ MAC OS X C/C++	armhf/aarch64 C/C++ C++ Builder iOS C/C++ Android C/C++	Solaris C/C++ MinGW C/C++

#include <C_CkStringBuilderW.h>
#include <C_CkHttpRequestW.h>
#include <C_CkHttpW.h>
#include <C_CkHttpResponseW.h>
#include <C_CkXmlW.h>
#include <C_CkCsvW.h>

void ChilkatSample(void)
    {
    BOOL success;
    HCkStringBuilderW sbSoapXml;
    HCkHttpRequestW req;
    HCkHttpW http;
    HCkHttpResponseW resp;
    HCkXmlW xmlResponse;
    const wchar_t *detail;
    HCkCsvW csv;
    int i;
    int numRows;

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

    req = CkHttpRequestW_Create();
    CkHttpRequestW_putHttpVerb(req,L"POST");
    CkHttpRequestW_putSendCharset(req,TRUE);
    CkHttpRequestW_putCharset(req,L"utf-8");
    CkHttpRequestW_AddHeader(req,L"Content-Type",L"text/xml");
    CkHttpRequestW_AddHeader(req,L"SOAPAction",L"http://www.peoplevox.net/GetReportData");
    CkHttpRequestW_putPath(req,L"/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx");
    success = CkHttpRequestW_LoadBodyFromString(req,CkStringBuilderW_getAsString(sbSoapXml),L"utf-8");

    http = CkHttpW_Create();
    CkHttpW_putFollowRedirects(http,TRUE);

    resp = CkHttpW_SynchronousRequest(http,L"qac.peoplevox.net",443,TRUE,req);
    if (CkHttpW_getLastMethodSuccess(http) != TRUE) {
        wprintf(L"%s\n",CkHttpW_lastErrorText(http));
        CkStringBuilderW_Dispose(sbSoapXml);
        CkHttpRequestW_Dispose(req);
        CkHttpW_Dispose(http);
        return;
    }

    // We should expect a 200 response if successful.
    if (CkHttpResponseW_getStatusCode(resp) != 200) {
        wprintf(L"Response StatusCode = %d\n",CkHttpResponseW_getStatusCode(resp));
        wprintf(L"Response StatusLine: %s\n",CkHttpResponseW_statusLine(resp));
        wprintf(L"Response Header:\n");
        wprintf(L"%s\n",CkHttpResponseW_header(resp));
        wprintf(L"%s\n",CkHttpResponseW_bodyStr(resp));
        CkStringBuilderW_Dispose(sbSoapXml);
        CkHttpRequestW_Dispose(req);
        CkHttpW_Dispose(http);
        return;
    }

    xmlResponse = CkXmlW_Create();
    success = CkXmlW_LoadXml(xmlResponse,CkHttpResponseW_bodyStr(resp));
    wprintf(L"%s\n",CkXmlW_getXml(xmlResponse));
    CkHttpResponseW_Dispose(resp);

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

    csv = CkCsvW_Create();
    CkCsvW_putHasColumnNames(csv,TRUE);
    CkCsvW_LoadFromString(csv,detail);

    wprintf(L"NumRows = %d\n",CkCsvW_getNumRows(csv));
    wprintf(L"NumColumns = %d\n",CkCsvW_getNumColumns(csv));

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



    CkStringBuilderW_Dispose(sbSoapXml);
    CkHttpRequestW_Dispose(req);
    CkHttpW_Dispose(http);
    CkXmlW_Dispose(xmlResponse);
    CkCsvW_Dispose(csv);

    }