Go
Go
Peoplevox GetReportData
See more Peoplevox Examples
Demonstrates how to export data from a Peoplevox Warehouse Management System (WMS) using a system report template.Chilkat Go Downloads
success := false
// 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.
//
sbSoapXml := chilkat.NewStringBuilder()
sbSoapXml.Append("<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n")
sbSoapXml.Append("<soap:Envelope xmlns:soap=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:peop=\"http://www.peoplevox.net/\">\r\n")
sbSoapXml.Append(" <soap:Header>\r\n")
sbSoapXml.Append(" <peop:UserSessionCredentials>\r\n")
sbSoapXml.Append(" <peop:UserId>PEOPLEVOX_USER_ID</peop:UserId>\r\n")
sbSoapXml.Append(" <peop:ClientId>PEOPLEVOX_CLIENT_ID</peop:ClientId>\r\n")
sbSoapXml.Append(" <peop:SessionId>PEOPLEVOX_SESSION_ID</peop:SessionId>\r\n")
sbSoapXml.Append(" </peop:UserSessionCredentials>\r\n")
sbSoapXml.Append(" </soap:Header>\r\n")
sbSoapXml.Append(" <soap:Body>\r\n")
sbSoapXml.Append(" <peop:GetReportData>\r\n")
sbSoapXml.Append(" <peop:getReportRequest>\r\n")
sbSoapXml.Append(" <peop:TemplateName>Item movement history</peop:TemplateName>\r\n")
sbSoapXml.Append(" <peop:PageNo>1</peop:PageNo>\r\n")
sbSoapXml.Append(" <peop:ItemsPerPage>20</peop:ItemsPerPage>\r\n")
sbSoapXml.Append(" <peop:OrderBy>[Date timestamp]</peop:OrderBy>\r\n")
sbSoapXml.Append(" <peop:Columns>[Item code],[Date timestamp],[From],[To],[Quantity],[Comments]</peop:Columns>\r\n")
sbSoapXml.Append(" <peop:SearchClause>([Date timestamp] > DateTime(2016,01,01,09,00,00))</peop:SearchClause>\r\n")
sbSoapXml.Append(" </peop:getReportRequest>\r\n")
sbSoapXml.Append(" </peop:GetReportData>\r\n")
sbSoapXml.Append(" </soap:Body>\r\n")
sbSoapXml.Append("</soap:Envelope>")
req := chilkat.NewHttpRequest()
req.SetHttpVerb("POST")
req.SetSendCharset(true)
req.SetCharset("utf-8")
req.AddHeader("Content-Type","text/xml")
req.AddHeader("SOAPAction","http://www.peoplevox.net/GetReportData")
req.SetPath("/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx")
success = req.LoadBodyFromString(*sbSoapXml.GetAsString(),"utf-8")
http := chilkat.NewHttp()
http.SetFollowRedirects(true)
resp := chilkat.NewHttpResponse()
success = http.HttpSReq("qac.peoplevox.net",443,true,req,resp)
if success == false {
fmt.Println(http.LastErrorText())
sbSoapXml.DisposeStringBuilder()
req.DisposeHttpRequest()
http.DisposeHttp()
resp.DisposeHttpResponse()
return
}
// We should expect a 200 response if successful.
if resp.StatusCode() != 200 {
fmt.Println("Response StatusCode = ", resp.StatusCode())
fmt.Println("Response StatusLine: ", resp.StatusLine())
fmt.Println("Response Header:")
fmt.Println(resp.Header())
fmt.Println(resp.BodyStr())
sbSoapXml.DisposeStringBuilder()
req.DisposeHttpRequest()
http.DisposeHttp()
resp.DisposeHttpResponse()
return
}
xmlResponse := chilkat.NewXml()
success = xmlResponse.LoadXml(resp.BodyStr())
fmt.Println(*xmlResponse.GetXml())
detail := xmlResponse.ChilkatPath("soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*")
csv := chilkat.NewCsv()
csv.SetHasColumnNames(true)
csv.LoadFromString(*detail)
fmt.Println("NumRows = ", csv.NumRows())
fmt.Println("NumColumns = ", csv.NumColumns())
// Iterate over the rows, getting the ItemCode, Name, and Barcode
i := 0
numRows := csv.NumRows()
for i < numRows {
fmt.Println("Item code: ", *csv.GetCellByName(i,"Item code"))
fmt.Println("Date timestamp: ", *csv.GetCellByName(i,"Date timestamp"))
fmt.Println("From: ", *csv.GetCellByName(i,"From"))
fmt.Println("To: ", *csv.GetCellByName(i,"To"))
fmt.Println("Quantity: ", *csv.GetCellByName(i,"Quantity"))
fmt.Println("Comments: ", *csv.GetCellByName(i,"Comments"))
fmt.Println("-")
i = i + 1
}
sbSoapXml.DisposeStringBuilder()
req.DisposeHttpRequest()
http.DisposeHttp()
resp.DisposeHttpResponse()
xmlResponse.DisposeXml()
csv.DisposeCsv()