Tcl
Tcl
Peoplevox GetReportData
See more Peoplevox Examples
Demonstrates how to export data from a Peoplevox Warehouse Management System (WMS) using a system report template.Chilkat Tcl Downloads
load ./chilkat.dll
set success 0
# 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
set resp [new_CkHttpResponse]
set success [CkHttp_HttpSReq $http "qac.peoplevox.net" 443 1 $req $resp]
if {$success == 0} then {
puts [CkHttp_lastErrorText $http]
delete_CkStringBuilder $sbSoapXml
delete_CkHttpRequest $req
delete_CkHttp $http
delete_CkHttpResponse $resp
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
delete_CkHttpResponse $resp
exit
}
set xmlResponse [new_CkXml]
set success [CkXml_LoadXml $xmlResponse [CkHttpResponse_bodyStr $resp]]
puts [CkXml_getXml $xmlResponse]
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_CkHttpResponse $resp
delete_CkXml $xmlResponse
delete_CkCsv $csv