(PowerShell) Peoplevox GetReportData

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

Chilkat .NET Downloads Chilkat .NET Assemblies

Add-Type -Path "C:\chilkat\ChilkatDotNet47-9.5.0-x64\ChilkatDotNet47.dll"

# 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.
#     
$sbSoapXml = New-Object Chilkat.StringBuilder
$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>")

$req = New-Object 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")

$http = New-Object Chilkat.Http
$http.FollowRedirects = $true

$resp = $http.SynchronousRequest("qac.peoplevox.net",443,$true,$req)
if ($http.LastMethodSuccess -ne $true) {
    $($http.LastErrorText)
    exit
}

# We should expect a 200 response if successful.
if ($resp.StatusCode -ne 200) {
    $("Response StatusCode = " + $resp.StatusCode)
    $("Response StatusLine: " + $resp.StatusLine)
    $("Response Header:")
    $($resp.Header)
    $($resp.BodyStr)
    exit
}

$xmlResponse = New-Object Chilkat.Xml
$success = $xmlResponse.LoadXml($resp.BodyStr)
$($xmlResponse.GetXml())

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

$csv = New-Object Chilkat.Csv
$csv.HasColumnNames = $true
$csv.LoadFromString($detail)

$("NumRows = " + $csv.NumRows)
$("NumColumns = " + $csv.NumColumns)

# Iterate over the rows, getting the ItemCode, Name, and Barcode
$i = 0
$numRows = $csv.NumRows
while ($i -lt $numRows) {
    $("Item code: " + $csv.GetCellByName($i,"Item code"))
    $("Date timestamp: " + $csv.GetCellByName($i,"Date timestamp"))
    $("From: " + $csv.GetCellByName($i,"From"))
    $("To: " + $csv.GetCellByName($i,"To"))
    $("Quantity: " + $csv.GetCellByName($i,"Quantity"))
    $("Comments: " + $csv.GetCellByName($i,"Comments"))
    $("-")
    $i = $i + 1
}