(Visual FoxPro) 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

LOCAL lnSuccess
LOCAL loSbSoapXml
LOCAL loReq
LOCAL loHttp
LOCAL loResp
LOCAL loXmlResponse
LOCAL lcDetail
LOCAL loCsv
LOCAL i
LOCAL lnNumRows

* 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.
*     
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
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>")

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.HttpRequest')
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")

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
loHttp = CreateObject('Chilkat.Http')
loHttp.FollowRedirects = 1

loResp = loHttp.SynchronousRequest("qac.peoplevox.net",443,1,loReq)
IF (loHttp.LastMethodSuccess <> 1) THEN
    ? loHttp.LastErrorText
    RELEASE loSbSoapXml
    RELEASE loReq
    RELEASE loHttp
    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
    CANCEL
ENDIF

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Xml')
loXmlResponse = CreateObject('Chilkat.Xml')
lnSuccess = loXmlResponse.LoadXml(loResp.BodyStr)
? loXmlResponse.GetXml()
RELEASE loResp

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Csv')
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 loXmlResponse
RELEASE loCsv