C
C
Peoplevox GetReportData
See more Peoplevox Examples
Demonstrates how to export data from a Peoplevox Warehouse Management System (WMS) using a system report template.Chilkat C Downloads
#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);
}