Unicode C
Unicode 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 Unicode C Downloads
#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;
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 = 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 = CkHttpResponseW_Create();
success = CkHttpW_HttpSReq(http,L"qac.peoplevox.net",443,TRUE,req,resp);
if (success == FALSE) {
wprintf(L"%s\n",CkHttpW_lastErrorText(http));
CkStringBuilderW_Dispose(sbSoapXml);
CkHttpRequestW_Dispose(req);
CkHttpW_Dispose(http);
CkHttpResponseW_Dispose(resp);
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);
CkHttpResponseW_Dispose(resp);
return;
}
xmlResponse = CkXmlW_Create();
success = CkXmlW_LoadXml(xmlResponse,CkHttpResponseW_bodyStr(resp));
wprintf(L"%s\n",CkXmlW_getXml(xmlResponse));
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);
CkHttpResponseW_Dispose(resp);
CkXmlW_Dispose(xmlResponse);
CkCsvW_Dispose(csv);
}