topic Re: How to get latest revision of a document using Rest API ? in Windchill

How to get latest revision of a document using Rest API ?

shindemayur — Wed, 30 Jan 2019 14:57:10 GMT

Hello,

I am using Windchill 11.1 M010.

I want to get latest revision of a document using Rest API.

I tried to use filter,

$filter : latestiteration eq '1',

but, this gives "Invalid expression".

Is there any way to get the latest revision of a document through Rest API?

Re: How to get latest revision of a document using Rest API ?

mneumann — Thu, 27 Dec 2018 10:28:08 GMT

I got this tip from one of my Windchill colleagues...

Can you try with

"Latest": true

instead of latestiteration : 1?

Re: How to get latest revision of a document using Rest API ?

shindemayur — Thu, 27 Dec 2018 11:59:47 GMT

Thanks,

but,

This also doesn't work. It says "Latest" is Invalid property

Re: How to get latest revision of a document using Rest API ?

mneumann — Thu, 27 Dec 2018 15:22:07 GMT

Could you please post the complete request here?

Including any headers for Post, that contain any additional parameters.

This might help in seeing if there's anything off in the request itself.

Re: How to get latest revision of a document using Rest API ?

shindemayur — Fri, 28 Dec 2018 07:27:53 GMT

Hello,

below I am sharing my Javascript code. In this code, I am passing typeID, and properties (attributes), also in a $filter I am setting criteria, so there I want to set a filter to fetch only latest version documents.

var params = {
type: 'GET',
url: me.getRestUrl() + "/structure/objects",
queryParams: {
'$select': properties,

'$filter': "endswith(number ,'"+number+"') and state eq 'Released' ",

'navigationCriteria': navigationCriteria,
'typeId': selectedTypeId,

}
};
// result: JSON
var jsonResult = me.processJSONRequest(params);

I tried with,

$filter : "latestIteration eq '1'",

but this displays all the version of a document. eg. A.1 and B.1 and B.2

I only want to fetch the latest i.e B.2

Re: How to get latest revision of a document using Rest API ?

shindemayur — Mon, 31 Dec 2018 04:34:58 GMT

@mneumann did you got my question?

Re: How to get latest revision of a document using Rest API ?

mneumann — Wed, 02 Jan 2019 06:55:40 GMT

@shindemayur

yes, but unfortunately I can't help you here.

Someone from the Windchill Customization team might - you might have to open a Support Case for this one.

Re: How to get latest revision of a document using Rest API ?

shindemayur — Wed, 02 Jan 2019 12:45:25 GMT

ok, Thank you.

Re: How to get latest revision of a document using Rest API ?

aschultheiss — Tue, 04 Jun 2019 17:00:21 GMT

Hi shindemayur,

have you already a solution for this issue?

Re: How to get latest revision of a document using Rest API ?

amarsingh — Fri, 07 Jun 2019 09:59:52 GMT

This will give what you are looking for

GET <windchill_server>:<port>/Windchill/servlet/odata/DocMgmt/Documents?$expand=Revisions

Re: How to get latest revision of a document using Rest API ?

Inno — Mon, 17 Jun 2019 05:41:32 GMT

hello Team,

Can you explain me how to use restful web service of windchill.

please let me know that initializing process to call restful web service of windchill.

Thank you in advance.

Re: How to get latest revision of a document using Rest API ?

amarsingh — Mon, 17 Jun 2019 06:10:37 GMT

Try the REST Call/URL here in a browser or your favorite rest client like postman.

Re: How to get latest revision of a document using Rest API ?

Inno — Mon, 17 Jun 2019 09:16:25 GMT

Thanks amarsingh for help.

just beginner for windchill software.so please help me some few question for it.

1. <windchill_server>:<Port> : which server name write in it?

please can you explain me in deepth.?

Thank you in advance

GET <windchill_server>:<port>/Windchill/servlet/odata/DocMgmt/Documents?$expand=Revisions

Re: How to get latest revision of a document using Rest API ?

amarsingh — Mon, 17 Jun 2019 09:26:02 GMT

Assuming you have access to a windchill server and that windchill is accessed as:

http://windchill.yourdomain.com:80/Windchill

you can access the below REST call with this URL

http://windchill.yourdomain.com:80/Windchill/servlet/odata/DocMgmt/Documents?$expand=Revisions

As the above REST call is a GET call you can try the above URL in a browser and you will get the response in xml format.

You want to try non GET operations like POST, DELETE, PATCH, etc, with more control over your REST request, use a REST client like Postman. With tools like Postman, you can get the REST response in JSON also by adding header

Content-Type: application/json

Re: How to get latest revision of a document using Rest API ?

Inno — Mon, 17 Jun 2019 09:38:59 GMT

Thank you so much for quick answer.

just asking question because i m bignner for it

However i don't know how to access server of windchill.so please let me know briefly.

i have created trial account on winchill website.but i can't found any domain .

so please can you explain me initiate process for get server of ' http://windchill.yourdomain.com:80 ' .

http://windchill.yourdomain.com:80/Windchill

thank you in advance

Re: How to get latest revision of a document using Rest API ?

Inno — Tue, 18 Jun 2019 03:57:32 GMT

Hello amarsingh

Can you provide direction for how to install on PTC cloud and where do i get windchill software for restful api ?

Thank you in advance