(Objective-C) Peoplevox GetReportData

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

Chilkat Objective-C Library Downloads MAC OS X (Cocoa) Libs iOS Libs

#import <CkoStringBuilder.h>
#import <CkoHttpRequest.h>
#import <CkoHttp.h>
#import <CkoHttpResponse.h>
#import <CkoXml.h>
#import <NSString.h>
#import <CkoCsv.h>

// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.

BOOL success;

// 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.
//     
CkoStringBuilder *sbSoapXml = [[CkoStringBuilder alloc] init];
[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>"];

CkoHttpRequest *req = [[CkoHttpRequest alloc] init];
req.HttpVerb = @"POST";
req.SendCharset = YES;
req.Charset = @"utf-8";
[req AddHeader: @"Content-Type" value: @"text/xml"];
[req AddHeader: @"SOAPAction" value: @"http://www.peoplevox.net/GetReportData"];
req.Path = @"/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx";
success = [req LoadBodyFromString: [sbSoapXml GetAsString] charset: @"utf-8"];

CkoHttp *http = [[CkoHttp alloc] init];
http.FollowRedirects = YES;

CkoHttpResponse *resp = [http SynchronousRequest: @"qac.peoplevox.net" port: [NSNumber numberWithInt: 443] ssl: YES req: req];
if (http.LastMethodSuccess != YES) {
    NSLog(@"%@",http.LastErrorText);
    return;
}

// We should expect a 200 response if successful.
if ([resp.StatusCode intValue] != 200) {
    NSLog(@"%@%d",@"Response StatusCode = ",[resp.StatusCode intValue]);
    NSLog(@"%@%@",@"Response StatusLine: ",resp.StatusLine);
    NSLog(@"%@",@"Response Header:");
    NSLog(@"%@",resp.Header);
    NSLog(@"%@",resp.BodyStr);
    return;
}

CkoXml *xmlResponse = [[CkoXml alloc] init];
success = [xmlResponse LoadXml: resp.BodyStr];
NSLog(@"%@",[xmlResponse GetXml]);

NSString *detail = [xmlResponse ChilkatPath: @"soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*"];

CkoCsv *csv = [[CkoCsv alloc] init];
csv.HasColumnNames = YES;
[csv LoadFromString: detail];

NSLog(@"%@%d",@"NumRows = ",[csv.NumRows intValue]);
NSLog(@"%@%d",@"NumColumns = ",[csv.NumColumns intValue]);

// Iterate over the rows, getting the ItemCode, Name, and Barcode
int i = 0;
int numRows = [csv.NumRows intValue];
while (i < numRows) {
    NSLog(@"%@%@",@"Item code: ",[csv GetCellByName: [NSNumber numberWithInt: i] columnName: @"Item code"]);
    NSLog(@"%@%@",@"Date timestamp: ",[csv GetCellByName: [NSNumber numberWithInt: i] columnName: @"Date timestamp"]);
    NSLog(@"%@%@",@"From: ",[csv GetCellByName: [NSNumber numberWithInt: i] columnName: @"From"]);
    NSLog(@"%@%@",@"To: ",[csv GetCellByName: [NSNumber numberWithInt: i] columnName: @"To"]);
    NSLog(@"%@%@",@"Quantity: ",[csv GetCellByName: [NSNumber numberWithInt: i] columnName: @"Quantity"]);
    NSLog(@"%@%@",@"Comments: ",[csv GetCellByName: [NSNumber numberWithInt: i] columnName: @"Comments"]);
    NSLog(@"%@",@"-");
    i = i + 1;
}