ACCEPTED SOLUTION
Accepted Solutions
I just tried with Fiddler web debugger and I do not see any XML response (pls refer to 1st image). I also tried using the URL on Chrome - Postman app with both request type as POST and GET and i could not see any XML response (refer 2nd & 3rd image).
Below is the service I have created & calling: it takes a Document Number in windchill as input.
//Fetch container
var containers = Things["ptc-windchill-demo-thing"].Query({
criteria:"name = 'Site'",
dataShape: 'WCContainerShape.wt.inf.container.WTContainer',
type: 'WCTYPE|wt.inf.container.WTContainer'
});
if(containers.getRowCount() > 0) {
var containerUfid = containers.getRow(0).ufid;
logger.debug("Using container UFID " + containerUfid);
}
//Fetch Report templates
var reportTemplates = Things["ptc-windchill-demo-thing"].Query({
criteria: "name = 'WTDOCSearch'",
dataShape: 'ReportTemplateShape.wt.query.template.ReportTemplate',
type: 'WCTYPE|wt.query.template.ReportTemplate',
containerUfid: containerUfid
});
if(reportTemplates.getRowCount() > 0) {
var reportTemplateUfid = reportTemplates.getRow(0).ufid;
logger.debug('Using report template UFID ' + reportTemplateUfid);
}
//Execute Report
var properties = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({
infoTableName : "InfoTable",
dataShapeName : "IEProperty"
});
properties.AddRow({
name : 'object_ref',
value: reportTemplateUfid
});
properties.AddRow({
name : 'input',
value: "number='" + Number + "'"
});
var result = me.ExecuteTask({
params: properties,
dataShape: 'strykerDocumentSearchDataShape',
uri: 'com/ptc/windchill/enterprise/report/ExecuteReportTemplate.xml',
objects: undefined
});
Most of the services on the WindchillConnector are just using the out of the box Windchill SOAP Web Service (com.ptc.windchill.ws aka GWS).
I recommend you to test this Web Service outside ThingWorx, for example you can use SoapUI as SOAP client.
1. Create a SOAP Project using <windchill_app_url>/servlet/TwxIEWebService?wsdl as WSDL.
2. Invoke the ExecuteReportTemplate.xml task using the ExecuteTask service (you have to specify a wnc authentication):
Below a copy of the above request (the oid of my report is wt.query.template.ReportTemplate:148161 - this report does not need inputs):
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ws="http://ws.windchill.ptc.com.service.jws.ptc.com/">
<soapenv:Header/>
<soapenv:Body>
<ws:ExecuteTask>
<!--Optional:-->
<uri>com/ptc/windchill/enterprise/report/ExecuteReportTemplate.xml</uri>
<!--Zero or more repetitions:-->
<params>
<!--Optional:-->
<name>object_ref</name>
<!--Optional:-->
<value>OR:wt.query.template.ReportTemplate:148161</value>
</params>
<!--Zero or more repetitions:-->
</ws:ExecuteTask>
</soapenv:Body>
</soapenv:Envelope>
3. Check if you see something abnormal in the SOAP response : can be an error, or an attribute that contains a blob or XML, special characters ...
Hello Steve, Thanks for your help here. I followed the exact steps you mentioned above and I did not notice any error. While I do the same on Thing-Service, the error repeats
.By the way thanks for detailed steps.
