Xojo Plugin 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. Xojo Plugin

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

Dim req As New Chilkat.HttpRequest
req.HttpVerb = "POST"
req.SendCharset = True
req.Charset = "utf-8"
req.AddHeader "Content-Type","text/xml"
req.AddHeader "SOAPAction","http://www.peoplevox.net/GetReportData"
req.Path = "/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx"
success = req.LoadBodyFromString(sbSoapXml.GetAsString(),"utf-8")

Dim http As New Chilkat.Http
http.FollowRedirects = True

Dim resp As New Chilkat.HttpResponse
success = http.HttpSReq("qac.peoplevox.net",443,True,req,resp)
If (success = False) Then
    System.DebugLog(http.LastErrorText)
    Return
End If

//  We should expect a 200 response if successful.
If (resp.StatusCode <> 200) Then
    System.DebugLog("Response StatusCode = " + Str(resp.StatusCode))
    System.DebugLog("Response StatusLine: " + resp.StatusLine)
    System.DebugLog("Response Header:")
    System.DebugLog(resp.Header)
    System.DebugLog(resp.BodyStr)
    Return
End If

Dim xmlResponse As New Chilkat.Xml
success = xmlResponse.LoadXml(resp.BodyStr)
System.DebugLog(xmlResponse.GetXml())

Dim detail As String
detail = xmlResponse.ChilkatPath("soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*")

Dim csv As New Chilkat.Csv
csv.HasColumnNames = True
success = csv.LoadFromString(detail)

System.DebugLog("NumRows = " + Str(csv.NumRows))
System.DebugLog("NumColumns = " + Str(csv.NumColumns))

//  Iterate over the rows, getting the ItemCode, Name, and Barcode
Dim i As Int32
i = 0
Dim numRows As Int32
numRows = csv.NumRows
While i < numRows
    System.DebugLog("Item code: " + csv.GetCellByName(i,"Item code"))
    System.DebugLog("Date timestamp: " + csv.GetCellByName(i,"Date timestamp"))
    System.DebugLog("From: " + csv.GetCellByName(i,"From"))
    System.DebugLog("To: " + csv.GetCellByName(i,"To"))
    System.DebugLog("Quantity: " + csv.GetCellByName(i,"Quantity"))
    System.DebugLog("Comments: " + csv.GetCellByName(i,"Comments"))
    System.DebugLog("-")
    i = i + 1
Wend