(VBScript) Peoplevox GetReportData

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

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.HttpRequest")
set req = CreateObject("Chilkat.HttpRequest")
req.HttpVerb = "POST"
req.SendCharset = 1
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")

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")
http.FollowRedirects = 1

' resp is a Chilkat.HttpResponse
Set resp = http.SynchronousRequest("qac.peoplevox.net",443,1,req)
If (http.LastMethodSuccess <> 1) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Xml")
set xmlResponse = CreateObject("Chilkat.Xml")
success = xmlResponse.LoadXml(resp.BodyStr)
outFile.WriteLine(xmlResponse.GetXml())

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Csv")
set csv = CreateObject("Chilkat.Csv")
csv.HasColumnNames = 1
success = csv.LoadFromString(detail)

outFile.WriteLine("NumRows = " & csv.NumRows)
outFile.WriteLine("NumColumns = " & csv.NumColumns)

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

outFile.Close