Visual FoxPro
Visual FoxPro
Peoplevox GetReportData
See more Peoplevox Examples
Demonstrates how to export data from a Peoplevox Warehouse Management System (WMS) using a system report template.Chilkat Visual FoxPro Downloads
LOCAL lnSuccess
LOCAL loSbSoapXml
LOCAL loReq
LOCAL loHttp
LOCAL loResp
LOCAL loXmlResponse
LOCAL lcDetail
LOCAL loCsv
LOCAL i
LOCAL lnNumRows
lnSuccess = 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.
*
loSbSoapXml = CreateObject('Chilkat.StringBuilder')
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('Chilkat.HttpRequest')
loReq.HttpVerb = "POST"
loReq.SendCharset = 1
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"
lnSuccess = loReq.LoadBodyFromString(loSbSoapXml.GetAsString(),"utf-8")
loHttp = CreateObject('Chilkat.Http')
loHttp.FollowRedirects = 1
loResp = CreateObject('Chilkat.HttpResponse')
lnSuccess = loHttp.HttpSReq("qac.peoplevox.net",443,1,loReq,loResp)
IF (lnSuccess = 0) THEN
? loHttp.LastErrorText
RELEASE loSbSoapXml
RELEASE loReq
RELEASE loHttp
RELEASE loResp
CANCEL
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
RELEASE loResp
CANCEL
ENDIF
loXmlResponse = CreateObject('Chilkat.Xml')
lnSuccess = loXmlResponse.LoadXml(loResp.BodyStr)
? loXmlResponse.GetXml()
lcDetail = loXmlResponse.ChilkatPath("soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*")
loCsv = CreateObject('Chilkat.Csv')
loCsv.HasColumnNames = 1
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 loResp
RELEASE loXmlResponse
RELEASE loCsv