Trigger a Report using IE

Question

Version: Windchill 13.1

Use Case: Trigger an IE Task from Thingworx, where the IE Task executes a Report requiring an input parameter

Description:

Hi All

I have an IE task that executes a Report when triggered from Thingworx. I have a Report that returns all the Latest Released Version of a WTDocument, if I dont specify the WTDoc number, it will return all the versions of all available WTDocuments.

For the case without specifying the WTDoc number, I am able to trigger it from PTC IE Domain in WRS using the below Request body

{
"Params": [
{
"Value": "Doc List",
"Name": "reportName"
}
],
"Task": "com/ptc/windchill/enterprise/report/DocReport.xml"
}

Here, Task = IE Task Location

Value = Report Name

Similarly, how do I execute by specifying the Document number? I tried the below but it won't work.

{
"Params": [
{
"Value": "Doc List,
"Name": "reportName"
},
{
"Value": "D000001364",
"Name": "Number"
}
],
"Task": "com/ptc/windchill/enterprise/report/DocReport.xml"
}

Many thanks in advance for helping me fix this and also please let me know where I can find similar syntax for my future work.

rhart · Answer

Is the report you mentioned a query builder report?

You can pass a Parameter of the report to use as a criteria using a "input" in the request payload.

const payload = {
 Task: "com/ptc/windchill/enterprise/report/ExecuteReportTemplate.xml",
 Params: [
 {
 Value: "wt.query.template.ReportTemplate:1264666482",
 Name: "object_ref",
 ValueSet: []
 },
 {
 Value: "Parameter=IT Testing",
 Name: "input",
 ValueSet: []
 }
 ]
 };

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded