Swift

Peoplevox GetReportData

See more Peoplevox Examples

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

func chilkatTest() {
    var success: Bool = 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.
    //     
    let sbSoapXml = CkoStringBuilder()!
    sbSoapXml.append(value: "<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n")
    sbSoapXml.append(value: "<soap:Envelope xmlns:soap=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:peop=\"http://www.peoplevox.net/\">\r\n")
    sbSoapXml.append(value: "   <soap:Header>\r\n")
    sbSoapXml.append(value: "      <peop:UserSessionCredentials>\r\n")
    sbSoapXml.append(value: "         <peop:UserId>PEOPLEVOX_USER_ID</peop:UserId>\r\n")
    sbSoapXml.append(value: "         <peop:ClientId>PEOPLEVOX_CLIENT_ID</peop:ClientId>\r\n")
    sbSoapXml.append(value: "         <peop:SessionId>PEOPLEVOX_SESSION_ID</peop:SessionId>\r\n")
    sbSoapXml.append(value: "      </peop:UserSessionCredentials>\r\n")
    sbSoapXml.append(value: "   </soap:Header>\r\n")
    sbSoapXml.append(value: "   <soap:Body>\r\n")
    sbSoapXml.append(value: "      <peop:GetReportData>\r\n")
    sbSoapXml.append(value: "         <peop:getReportRequest>\r\n")
    sbSoapXml.append(value: "            <peop:TemplateName>Item movement history</peop:TemplateName>\r\n")
    sbSoapXml.append(value: "            <peop:PageNo>1</peop:PageNo>\r\n")
    sbSoapXml.append(value: "            <peop:ItemsPerPage>20</peop:ItemsPerPage>\r\n")
    sbSoapXml.append(value: "            <peop:OrderBy>[Date timestamp]</peop:OrderBy>\r\n")
    sbSoapXml.append(value: "            <peop:Columns>[Item code],[Date timestamp],[From],[To],[Quantity],[Comments]</peop:Columns>\r\n")
    sbSoapXml.append(value: "            <peop:SearchClause>([Date timestamp] > DateTime(2016,01,01,09,00,00))</peop:SearchClause>\r\n")
    sbSoapXml.append(value: "         </peop:getReportRequest>\r\n")
    sbSoapXml.append(value: "      </peop:GetReportData>\r\n")
    sbSoapXml.append(value: "   </soap:Body>\r\n")
    sbSoapXml.append(value: "</soap:Envelope>")

    let req = CkoHttpRequest()!
    req.httpVerb = "POST"
    req.sendCharset = true
    req.charset = "utf-8"
    req.addHeader(name: "Content-Type", value: "text/xml")
    req.addHeader(name: "SOAPAction", value: "http://www.peoplevox.net/GetReportData")
    req.path = "/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx"
    success = req.loadBody(fromString: sbSoapXml.getAsString(), charset: "utf-8")

    let http = CkoHttp()!
    http.followRedirects = true

    let resp = CkoHttpResponse()!
    success = http.httpSReq(domain: "qac.peoplevox.net", port: 443, ssl: true, request: req, response: resp)
    if success == false {
        print("\(http.lastErrorText!)")
        return
    }

    // We should expect a 200 response if successful.
    if resp.statusCode.intValue != 200 {
        print("Response StatusCode = \(resp.statusCode.intValue)")
        print("Response StatusLine: \(resp.statusLine!)")
        print("Response Header:")
        print("\(resp.header!)")
        print("\(resp.bodyStr!)")
        return
    }

    let xmlResponse = CkoXml()!
    success = xmlResponse.load(xmlData: resp.bodyStr)
    print("\(xmlResponse.getXml()!)")

    var detail: String? = xmlResponse.chilkatPath(cmd: "soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*")

    let csv = CkoCsv()!
    csv.hasColumnNames = true
    csv.load(fromString: detail)

    print("NumRows = \(csv.numRows.intValue)")
    print("NumColumns = \(csv.numColumns.intValue)")

    // Iterate over the rows, getting the ItemCode, Name, and Barcode
    var i: Int = 0
    var numRows: Int = csv.numRows.intValue
    while i < numRows {
        print("Item code: \(csv.getCell(byName: i, columnName: "Item code")!)")
        print("Date timestamp: \(csv.getCell(byName: i, columnName: "Date timestamp")!)")
        print("From: \(csv.getCell(byName: i, columnName: "From")!)")
        print("To: \(csv.getCell(byName: i, columnName: "To")!)")
        print("Quantity: \(csv.getCell(byName: i, columnName: "Quantity")!)")
        print("Comments: \(csv.getCell(byName: i, columnName: "Comments")!)")
        print("-")
        i = i + 1
    }


}