(Lianja) Peoplevox GetReportData

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

Chilkat Lianja Extension Download Chilkat Lianja Extension

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

loReq = createobject("CkHttpRequest")
loReq.HttpVerb = "POST"
loReq.SendCharset = .T.
loReq.Charset = "utf-8"
loReq.AddHeader("Content-Type","text/xml")
loReq.AddHeader("SOAPAction","http://www.peoplevox.net/GetReportData")
loReq.Path = "/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx"
llSuccess = loReq.LoadBodyFromString(loSbSoapXml.GetAsString(),"utf-8")

loHttp = createobject("CkHttp")
loHttp.FollowRedirects = .T.

loResp = loHttp.SynchronousRequest("qac.peoplevox.net",443,.T.,loReq)
if (loHttp.LastMethodSuccess <> .T.) then
    ? loHttp.LastErrorText
    release loSbSoapXml
    release loReq
    release loHttp
    return
endif

// We should expect a 200 response if successful.
if (loResp.StatusCode <> 200) then
    ? "Response StatusCode = " + str(loResp.StatusCode)
    ? "Response StatusLine: " + loResp.StatusLine
    ? "Response Header:"
    ? loResp.Header
    ? loResp.BodyStr
    release loSbSoapXml
    release loReq
    release loHttp
    return
endif

loXmlResponse = createobject("CkXml")
llSuccess = loXmlResponse.LoadXml(loResp.BodyStr)
? loXmlResponse.GetXml()
release loResp

lcDetail = loXmlResponse.ChilkatPath("soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*")

loCsv = createobject("CkCsv")
loCsv.HasColumnNames = .T.
loCsv.LoadFromString(lcDetail)

? "NumRows = " + str(loCsv.NumRows)
? "NumColumns = " + str(loCsv.NumColumns)

// Iterate over the rows, getting the ItemCode, Name, and Barcode
i = 0
lnNumRows = loCsv.NumRows
do while i < lnNumRows
    ? "Item code: " + loCsv.GetCellByName(i,"Item code")
    ? "Date timestamp: " + loCsv.GetCellByName(i,"Date timestamp")
    ? "From: " + loCsv.GetCellByName(i,"From")
    ? "To: " + loCsv.GetCellByName(i,"To")
    ? "Quantity: " + loCsv.GetCellByName(i,"Quantity")
    ? "Comments: " + loCsv.GetCellByName(i,"Comments")
    ? "-"
    i = i + 1
enddo


release loSbSoapXml
release loReq
release loHttp
release loXmlResponse
release loCsv