Retrieving Windchill report data to use in Thingworx

[lspears]

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!

[slangley]

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

[lspears]

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"