(Tcl) Peoplevox GetReportData

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

Chilkat Tcl Extension Downloads Chilkat Tcl Extension Downloads

load ./chilkat.dll

# 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.
#     
set sbSoapXml [new_CkStringBuilder]

CkStringBuilder_Append $sbSoapXml "<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n"
CkStringBuilder_Append $sbSoapXml "<soap:Envelope xmlns:soap=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:peop=\"http://www.peoplevox.net/\">\r\n"
CkStringBuilder_Append $sbSoapXml "   <soap:Header>\r\n"
CkStringBuilder_Append $sbSoapXml "      <peop:UserSessionCredentials>\r\n"
CkStringBuilder_Append $sbSoapXml "         <peop:UserId>PEOPLEVOX_USER_ID</peop:UserId>\r\n"
CkStringBuilder_Append $sbSoapXml "         <peop:ClientId>PEOPLEVOX_CLIENT_ID</peop:ClientId>\r\n"
CkStringBuilder_Append $sbSoapXml "         <peop:SessionId>PEOPLEVOX_SESSION_ID</peop:SessionId>\r\n"
CkStringBuilder_Append $sbSoapXml "      </peop:UserSessionCredentials>\r\n"
CkStringBuilder_Append $sbSoapXml "   </soap:Header>\r\n"
CkStringBuilder_Append $sbSoapXml "   <soap:Body>\r\n"
CkStringBuilder_Append $sbSoapXml "      <peop:GetReportData>\r\n"
CkStringBuilder_Append $sbSoapXml "         <peop:getReportRequest>\r\n"
CkStringBuilder_Append $sbSoapXml "            <peop:TemplateName>Item movement history</peop:TemplateName>\r\n"
CkStringBuilder_Append $sbSoapXml "            <peop:PageNo>1</peop:PageNo>\r\n"
CkStringBuilder_Append $sbSoapXml "            <peop:ItemsPerPage>20</peop:ItemsPerPage>\r\n"
CkStringBuilder_Append $sbSoapXml "            <peop:OrderBy>[Date timestamp]</peop:OrderBy>\r\n"
CkStringBuilder_Append $sbSoapXml "            <peop:Columns>[Item code],[Date timestamp],[From],[To],[Quantity],[Comments]</peop:Columns>\r\n"
CkStringBuilder_Append $sbSoapXml "            <peop:SearchClause>([Date timestamp] > DateTime(2016,01,01,09,00,00))</peop:SearchClause>\r\n"
CkStringBuilder_Append $sbSoapXml "         </peop:getReportRequest>\r\n"
CkStringBuilder_Append $sbSoapXml "      </peop:GetReportData>\r\n"
CkStringBuilder_Append $sbSoapXml "   </soap:Body>\r\n"
CkStringBuilder_Append $sbSoapXml "</soap:Envelope>"

set req [new_CkHttpRequest]

CkHttpRequest_put_HttpVerb $req "POST"
CkHttpRequest_put_SendCharset $req 1
CkHttpRequest_put_Charset $req "utf-8"
CkHttpRequest_AddHeader $req "Content-Type" "text/xml"
CkHttpRequest_AddHeader $req "SOAPAction" "http://www.peoplevox.net/GetReportData"
CkHttpRequest_put_Path $req "/PEOPLEVOX_CLIENT_ID/resources/integrationservicev4.asmx"
set success [CkHttpRequest_LoadBodyFromString $req [CkStringBuilder_getAsString $sbSoapXml] "utf-8"]

set http [new_CkHttp]

CkHttp_put_FollowRedirects $http 1

# resp is a CkHttpResponse
set resp [CkHttp_SynchronousRequest $http "qac.peoplevox.net" 443 1 $req]
if {[CkHttp_get_LastMethodSuccess $http] != 1} then {
    puts [CkHttp_lastErrorText $http]
    delete_CkStringBuilder $sbSoapXml
    delete_CkHttpRequest $req
    delete_CkHttp $http
    exit
}

# We should expect a 200 response if successful.
if {[CkHttpResponse_get_StatusCode $resp] != 200} then {
    puts "Response StatusCode = [CkHttpResponse_get_StatusCode $resp]"
    puts "Response StatusLine: [CkHttpResponse_statusLine $resp]"
    puts "Response Header:"
    puts [CkHttpResponse_header $resp]
    puts [CkHttpResponse_bodyStr $resp]
    delete_CkStringBuilder $sbSoapXml
    delete_CkHttpRequest $req
    delete_CkHttp $http
    exit
}

set xmlResponse [new_CkXml]

set success [CkXml_LoadXml $xmlResponse [CkHttpResponse_bodyStr $resp]]
puts [CkXml_getXml $xmlResponse]
delete_CkHttpResponse $resp

set detail [CkXml_chilkatPath $xmlResponse "soap:Body|GetReportDataResponse|GetReportDataResult|Detail|*"]

set csv [new_CkCsv]

CkCsv_put_HasColumnNames $csv 1
CkCsv_LoadFromString $csv $detail

puts "NumRows = [CkCsv_get_NumRows $csv]"
puts "NumColumns = [CkCsv_get_NumColumns $csv]"

# Iterate over the rows, getting the ItemCode, Name, and Barcode
set i 0
set numRows [CkCsv_get_NumRows $csv]
while {$i < $numRows} {
    puts "Item code: [CkCsv_getCellByName $csv $i Item code]"
    puts "Date timestamp: [CkCsv_getCellByName $csv $i Date timestamp]"
    puts "From: [CkCsv_getCellByName $csv $i From]"
    puts "To: [CkCsv_getCellByName $csv $i To]"
    puts "Quantity: [CkCsv_getCellByName $csv $i Quantity]"
    puts "Comments: [CkCsv_getCellByName $csv $i Comments]"
    puts "-"
    set i [expr $i + 1]
}

delete_CkStringBuilder $sbSoapXml
delete_CkHttpRequest $req
delete_CkHttp $http
delete_CkXml $xmlResponse
delete_CkCsv $csv