(Go) Peoplevox GetReportData

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

Chilkat Go Downloads Go Package for Windows, MacOS, Linux, Alpine Linux, Solaris

    // This example requires the Chilkat API to have been previously unlocked.
    // See Global Unlock Sample for sample code.

    var success bool

    // 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 := http.SynchronousRequest("qac.peoplevox.net",443,true,req)
    if http.LastMethodSuccess() != true {
        fmt.Println(http.LastErrorText())
        sbSoapXml.DisposeStringBuilder()
        req.DisposeHttpRequest()
        http.DisposeHttp()
        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()
        return
    }

    xmlResponse := chilkat.NewXml()
    success = xmlResponse.LoadXml(resp.BodyStr())
    fmt.Println(*xmlResponse.GetXml())
    resp.DisposeHttpResponse()

    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()
    xmlResponse.DisposeXml()
    csv.DisposeCsv()