Xbase++ Requires Chilkat v11.0.0+
Xbase++
Peoplevox GetReportData
See more Peoplevox Examples
Demonstrates how to export data from a Peoplevox Warehouse Management System (WMS) using a system report template.Chilkat Xbase++ Downloads
LOCAL nSuccess
LOCAL oSbSoapXml
LOCAL oReq
LOCAL oHttp
LOCAL oResp
LOCAL oXmlResponse
LOCAL cDetail
LOCAL oCsv
LOCAL i
LOCAL nNumRows
nSuccess := 0
// 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.
//
oSbSoapXml := CreateObject("Chilkat.StringBuilder")
oSbSoapXml:Append('<?xml version="1.0" encoding="utf-8"?>' + Chr(13) + Chr(10))
oSbSoapXml:Append('<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:peop="http://www.peoplevox.net/">' + Chr(13) + Chr(10))
oSbSoapXml:Append(" <soap:Header>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <peop:UserSessionCredentials>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <peop:UserId>PEOPLEVOX_USER_ID</peop:UserId>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <peop:ClientId>PEOPLEVOX_CLIENT_ID</peop:ClientId>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <peop:SessionId>PEOPLEVOX_SESSION_ID</peop:SessionId>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" </peop:UserSessionCredentials>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" </soap:Header>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <soap:Body>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <peop:GetReportData>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <peop:getReportRequest>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <peop:TemplateName>Item movement history</peop:TemplateName>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <peop:PageNo>1</peop:PageNo>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <peop:ItemsPerPage>20</peop:ItemsPerPage>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <peop:OrderBy>[Date timestamp]</peop:OrderBy>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <peop:Columns>[Item code],[Date timestamp],[From],[To],[Quantity],[Comments]</peop:Columns>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" <peop:SearchClause>([Date timestamp] > DateTime(2016,01,01,09,00,00))</peop:SearchClause>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" </peop:getReportRequest>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" </peop:GetReportData>" + Chr(13) + Chr(10))
oSbSoapXml:Append(" </soap:Body>" + Chr(13) + Chr(10))
oSbSoapXml:Append("</soap:Envelope>")
oReq := CreateObject("Chilkat.HttpRequest")
oReq:HttpVerb := "POST"
oReq:SendCharset := 1
oReq:Charset := "utf-8"
oReq:AddHeader("Content-Type", "text/xml")
oReq:AddHeader("SOAPAction", "http://www.peoplevox.net/GetReportData")
oReq:Path := "/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx"
nSuccess := oReq:LoadBodyFromString(oSbSoapXml:GetAsString(), "utf-8")
oHttp := CreateObject("Chilkat.Http")
oHttp:FollowRedirects := 1
oResp := CreateObject("Chilkat.HttpResponse")
nSuccess := oHttp:HttpSReq("qac.peoplevox.net", 443, 1, oReq, oResp)
IF (nSuccess == 0)
? oHttp:LastErrorText
oSbSoapXml:destroy()
oReq:destroy()
oHttp:destroy()
oResp:destroy()
RETURN
ENDIF
// We should expect a 200 response if successful.
IF (oResp:StatusCode != 200)
? "Response StatusCode = " + Str(oResp:StatusCode)
? "Response StatusLine: " + oResp:StatusLine
? "Response Header:"
? oResp:Header
? oResp:BodyStr
oSbSoapXml:destroy()
oReq:destroy()
oHttp:destroy()
oResp:destroy()
RETURN
ENDIF
oXmlResponse := CreateObject("Chilkat.Xml")
nSuccess := oXmlResponse:LoadXml(oResp:BodyStr)
? oXmlResponse:GetXml()
cDetail := oXmlResponse:ChilkatPath("soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*")
oCsv := CreateObject("Chilkat.Csv")
oCsv:HasColumnNames := 1
oCsv:LoadFromString(cDetail)
? "NumRows = " + Str(oCsv:NumRows)
? "NumColumns = " + Str(oCsv:NumColumns)
// Iterate over the rows, getting the ItemCode, Name, and Barcode
i := 0
nNumRows := oCsv:NumRows
DO WHILE i < nNumRows
? "Item code: " + oCsv:GetCellByName(i, "Item code")
? "Date timestamp: " + oCsv:GetCellByName(i, "Date timestamp")
? "From: " + oCsv:GetCellByName(i, "From")
? "To: " + oCsv:GetCellByName(i, "To")
? "Quantity: " + oCsv:GetCellByName(i, "Quantity")
? "Comments: " + oCsv:GetCellByName(i, "Comments")
? "-"
i := i + 1
ENDDO
oSbSoapXml:destroy()
oReq:destroy()
oHttp:destroy()
oResp:destroy()
oXmlResponse:destroy()
oCsv:destroy()