Skip to main content
L
lspears1-Visitor
1-Visitor
August 30, 2021
Question

Retrieving Windchill report data to use in Thingworx

  • August 30, 2021
  • 1 reply
  • 1407 views

So I'm trying to figure out how I can pull the data from an existing windchill report into Thingworx. I already have a service that pulls data from a saved search in Windchill and the line looks like this:

 

oid: "wt.query.SavedQuery:880242649", // Saved Query

 

Would I be able to change this to pull data from a report template instead?

 

Any help is much appreciated, thanks!

1 reply

S
slangleyCommunity Manager
Support
September 15, 2021

Hi @lspears

 

I checked with another team on this and was advised that this sounds like a customization.  It may be possible to use the Odata connector to create a custom service that would invoke the IE (Info*Engine) Windchill endpoint. You would then need an I*E task to prepare the data in the desired format, and the call to the IE endpoint could execute or retrieve the results of the task.

 

The Odata connector comes with Navigate but depending on the version of ThingWorx you're running, it may come with other products as well.

 

Regards.

 

--Sharon

L
lspears1-VisitorAuthor
1-Visitor
September 17, 2021

Thanks for the reply. I have made some progress using the Windchill rest service InvokeIETask with the task of "com/ptc/windchill/enterprise/report/ExecuteReportTemplate.xml"
The problem I am running into now is I can't figure out what value to put for "report_ref"

lspears_0-1631885991335.png

 

Terms & ConditionsAccessibility statement