Retrieve history of a Document

[EG_10925009]

Hello,

I want to retrieve maturity history and Lifecycle History of a document. How can I do this ? I did not found any endpoints in OData rest API.

[avillanueva]

Are you only looking to retrieve this via REST Api? This might need to move to Customization board. There are many ways to get this data via standard reporting if that is what you need.

[EG_10925009]

Hello, thank you for answer.  I wanna retrieve maturity history and Lifecycle History of a document via just OData rest API. I dont know about custumization board. what should ı do ? 

[HelesicPetr]

Hi @EG_10925009 

You need to use an template report RestApi to call the report inside the Windchill.

In the Windchill you need to create report template that return what you need.

ExecuteReportTemplate

Viewing the output of Report Template execution

InvokeIETask with report parameter

CS378132 - Input Parameter not provided in Query Builder Report

Windchill Reporting Resource

PetrH

[EG_10925009]

If I do this, will the endpoint I want be added to the odata rest api

[HelesicPetr]

Hi @EG_10925009 

You can use rest api to run any report template in the Windchill so yes the endpoint has already exists there..

You just need to create a report that retrieves the information you need in the Windchill

/Windchill/servlet/odata/Reporting/ReportTemplates('OR:wt.query.template.ReportTemplate:334133')/PTC.Reporting.ExecuteReportTemplate

check Windchill odata documentation

/Windchill/netmarkets/html/wrs/doc.html

PetrH

[EG_10925009]

Thansk for answers. that's probably the solution. My company did a lot Report and   I can see that in odata rest api but all endpoints return 500 error. Other basic domains and enpoints is working bu just doesnt work report endpoints of my company. How do I fix this ? 

[HelesicPetr]

Hi @EG_10925009 

Who knows, It is just documentation the restapi works or contact a support to solve it.

btw use the IETask end point instead of the report one.

PetrH

[HelesicPetr]

Hi @EG_10925009 

There is something wrong in the code that something is null and I guess it is a specific version bug.

In windchill 12.1.2.0 the report documentation page works. 

btw the RestAPI works even though the documentation page can not loaded 

here is an example from the documentation

curl example for you

curl -X 'POST' \
  'http://windchillServerXY:80/Windchill/servlet/odata/v1/Reporting/ReportTemplates('\''OR%3Awt.query.template.ReportTemplate%3A334133'\'')/PTC.Reporting.ExecuteReportTemplate?%24count=false' \
  -H 'accept: application/json' \
  -H 'CSRF_NONCE: CSFRNONCESTRING' \
  -H 'Content-Type: application/json' \
  -d '{
  "Criteria": [
    {
      "Operator": "",
      "Value": [
        ""
      ],
      "Column": ""
    }
  ]
}'

PetrH