Rust Requires Chilkat v11.0.0+

Peoplevox GetReportData

See more Peoplevox Examples

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

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

let req = chilkat::HttpRequest::new();
req.set_http_verb("POST");
req.set_send_charset(true);
req.set_charset("utf-8");
req.add_header("Content-Type", "text/xml");
req.add_header("SOAPAction", "http://www.peoplevox.net/GetReportData");
req.set_path("/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx");
let _ = req.load_body_from_string(&sb_soap_xml.get_as_string().unwrap_or_default(), "utf-8").is_ok();

let http = chilkat::Http::new();
http.set_follow_redirects(true);

let resp = chilkat::HttpResponse::new();
if http.http_s_req("qac.peoplevox.net", 443, true, &req, &resp).is_err() {
    println!("{}", http.last_error_text());
    return;
}

// We should expect a 200 response if successful.
if resp.status_code() != 200 {
    println!("Response StatusCode = {}", resp.status_code());
    println!("Response StatusLine: {}", resp.status_line());
    println!("Response Header:");
    println!("{}", resp.header());
    println!("{}", resp.body_str());
    return;
}

let xml_response = chilkat::Xml::new();
let _ = xml_response.load_xml(&resp.body_str()).is_ok();
println!("{}", xml_response.get_xml().unwrap_or_default());

let detail = xml_response.chilkat_path("soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*").unwrap_or_default();

let csv = chilkat::Csv::new();
csv.set_has_column_names(true);
let _ = csv.load_from_string(&detail);

println!("NumRows = {}", csv.num_rows());
println!("NumColumns = {}", csv.num_columns());

// Iterate over the rows, getting the ItemCode, Name, and Barcode
let mut i = 0;
let num_rows = csv.num_rows();
while i < num_rows {
    println!("Item code: {}", csv.get_cell_by_name(i, "Item code").unwrap_or_default());
    println!("Date timestamp: {}", csv.get_cell_by_name(i, "Date timestamp").unwrap_or_default());
    println!("From: {}", csv.get_cell_by_name(i, "From").unwrap_or_default());
    println!("To: {}", csv.get_cell_by_name(i, "To").unwrap_or_default());
    println!("Quantity: {}", csv.get_cell_by_name(i, "Quantity").unwrap_or_default());
    println!("Comments: {}", csv.get_cell_by_name(i, "Comments").unwrap_or_default());
    println!("-");
    i = i + 1;
}