(PowerBuilder) 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

integer li_rc
integer li_Success
oleobject loo_SbSoapXml
oleobject loo_Req
oleobject loo_Http
oleobject loo_Resp
oleobject loo_XmlResponse
string ls_Detail
oleobject loo_Csv
integer i
integer li_NumRows

// 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.
//     
loo_SbSoapXml = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbSoapXml.ConnectToNewObject("Chilkat.StringBuilder")
if li_rc < 0 then
    destroy loo_SbSoapXml
    MessageBox("Error","Connecting to COM object failed")
    return
end if
loo_SbSoapXml.Append("<?xml version=~"1.0~" encoding=~"utf-8~"?>~r~n")
loo_SbSoapXml.Append("<soap:Envelope xmlns:soap=~"http://www.w3.org/2003/05/soap-envelope~" xmlns:peop=~"http://www.peoplevox.net/~">~r~n")
loo_SbSoapXml.Append("   <soap:Header>~r~n")
loo_SbSoapXml.Append("      <peop:UserSessionCredentials>~r~n")
loo_SbSoapXml.Append("         <peop:UserId>PEOPLEVOX_USER_ID</peop:UserId>~r~n")
loo_SbSoapXml.Append("         <peop:ClientId>PEOPLEVOX_CLIENT_ID</peop:ClientId>~r~n")
loo_SbSoapXml.Append("         <peop:SessionId>PEOPLEVOX_SESSION_ID</peop:SessionId>~r~n")
loo_SbSoapXml.Append("      </peop:UserSessionCredentials>~r~n")
loo_SbSoapXml.Append("   </soap:Header>~r~n")
loo_SbSoapXml.Append("   <soap:Body>~r~n")
loo_SbSoapXml.Append("      <peop:GetReportData>~r~n")
loo_SbSoapXml.Append("         <peop:getReportRequest>~r~n")
loo_SbSoapXml.Append("            <peop:TemplateName>Item movement history</peop:TemplateName>~r~n")
loo_SbSoapXml.Append("            <peop:PageNo>1</peop:PageNo>~r~n")
loo_SbSoapXml.Append("            <peop:ItemsPerPage>20</peop:ItemsPerPage>~r~n")
loo_SbSoapXml.Append("            <peop:OrderBy>[Date timestamp]</peop:OrderBy>~r~n")
loo_SbSoapXml.Append("            <peop:Columns>[Item code],[Date timestamp],[From],[To],[Quantity],[Comments]</peop:Columns>~r~n")
loo_SbSoapXml.Append("            <peop:SearchClause>([Date timestamp] > DateTime(2016,01,01,09,00,00))</peop:SearchClause>~r~n")
loo_SbSoapXml.Append("         </peop:getReportRequest>~r~n")
loo_SbSoapXml.Append("      </peop:GetReportData>~r~n")
loo_SbSoapXml.Append("   </soap:Body>~r~n")
loo_SbSoapXml.Append("</soap:Envelope>")

loo_Req = create oleobject
// Use "Chilkat_9_5_0.HttpRequest" for versions of Chilkat < 10.0.0
li_rc = loo_Req.ConnectToNewObject("Chilkat.HttpRequest")

loo_Req.HttpVerb = "POST"
loo_Req.SendCharset = 1
loo_Req.Charset = "utf-8"
loo_Req.AddHeader("Content-Type","text/xml")
loo_Req.AddHeader("SOAPAction","http://www.peoplevox.net/GetReportData")
loo_Req.Path = "/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx"
li_Success = loo_Req.LoadBodyFromString(loo_SbSoapXml.GetAsString(),"utf-8")

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")

loo_Http.FollowRedirects = 1

loo_Resp = loo_Http.SynchronousRequest("qac.peoplevox.net",443,1,loo_Req)
if loo_Http.LastMethodSuccess <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_SbSoapXml
    destroy loo_Req
    destroy loo_Http
    return
end if

// We should expect a 200 response if successful.
if loo_Resp.StatusCode <> 200 then
    Write-Debug "Response StatusCode = " + string(loo_Resp.StatusCode)
    Write-Debug "Response StatusLine: " + loo_Resp.StatusLine
    Write-Debug "Response Header:"
    Write-Debug loo_Resp.Header
    Write-Debug loo_Resp.BodyStr
    destroy loo_SbSoapXml
    destroy loo_Req
    destroy loo_Http
    return
end if

loo_XmlResponse = create oleobject
// Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0
li_rc = loo_XmlResponse.ConnectToNewObject("Chilkat.Xml")

li_Success = loo_XmlResponse.LoadXml(loo_Resp.BodyStr)
Write-Debug loo_XmlResponse.GetXml()
destroy loo_Resp

ls_Detail = loo_XmlResponse.ChilkatPath("soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*")

loo_Csv = create oleobject
// Use "Chilkat_9_5_0.Csv" for versions of Chilkat < 10.0.0
li_rc = loo_Csv.ConnectToNewObject("Chilkat.Csv")

loo_Csv.HasColumnNames = 1
loo_Csv.LoadFromString(ls_Detail)

Write-Debug "NumRows = " + string(loo_Csv.NumRows)
Write-Debug "NumColumns = " + string(loo_Csv.NumColumns)

// Iterate over the rows, getting the ItemCode, Name, and Barcode
i = 0
li_NumRows = loo_Csv.NumRows
do while i < li_NumRows
    Write-Debug "Item code: " + loo_Csv.GetCellByName(i,"Item code")
    Write-Debug "Date timestamp: " + loo_Csv.GetCellByName(i,"Date timestamp")
    Write-Debug "From: " + loo_Csv.GetCellByName(i,"From")
    Write-Debug "To: " + loo_Csv.GetCellByName(i,"To")
    Write-Debug "Quantity: " + loo_Csv.GetCellByName(i,"Quantity")
    Write-Debug "Comments: " + loo_Csv.GetCellByName(i,"Comments")
    Write-Debug "-"
    i = i + 1
loop


destroy loo_SbSoapXml
destroy loo_Req
destroy loo_Http
destroy loo_XmlResponse
destroy loo_Csv