Sample code for 30+ languages & platforms
B4X 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.

Chilkat B4X Downloads

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

Dim req As ChilkatHttpRequest
req.Initialize
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 ChilkatHttp
http.Initialize("http")
http.FollowRedirects = True

Dim resp As ChilkatHttpResponse
resp.Initialize
success = http.HttpSReq("qac.peoplevox.net", 443, True, req, resp)
If success = False Then
    Log(http.LastErrorText)
    Return
End If


'  We should expect a 200 response if successful.
If resp.StatusCode <> 200 Then
    Log("Response StatusCode = " & resp.StatusCode)
    Log("Response StatusLine: " & resp.StatusLine)
    Log("Response Header:")
    Log(resp.Header)
    Log(resp.BodyStr)
    Return
End If


Dim xmlResponse As ChilkatXml
xmlResponse.Initialize
success = xmlResponse.LoadXml(resp.BodyStr)
Log(xmlResponse.GetXml)

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

Dim csv As ChilkatCsv
csv.Initialize
csv.HasColumnNames = True
csv.LoadFromString(detail)

Log("NumRows = " & csv.NumRows)
Log("NumColumns = " & csv.NumColumns)

'  Iterate over the rows, getting the ItemCode, Name, and Barcode
Dim i As Int = 0
Dim numRows As Int = csv.NumRows
Do While i < numRows
    Log("Item code: " & csv.GetCellByName(i, "Item code"))
    Log("Date timestamp: " & csv.GetCellByName(i, "Date timestamp"))
    Log("From: " & csv.GetCellByName(i, "From"))
    Log("To: " & csv.GetCellByName(i, "To"))
    Log("Quantity: " & csv.GetCellByName(i, "Quantity"))
    Log("Comments: " & csv.GetCellByName(i, "Comments"))
    Log("-")
    i = i + 1
Loop