topic Re: Using REST API to get a list of all WTParts in Windchill

Using REST API to get a list of all WTParts

PhilK — Wed, 23 Feb 2022 23:19:14 GMT

Is there a way to use the rest api to get a list of all wtparts and their attributes?

Re: Using REST API to get a list of all WTParts

rhart — Mon, 28 Feb 2022 15:08:07 GMT

You can get parts and their attributes but there does seem to be a limit for how many parts in a single query.

I can get 140,000 parts with query for a part Numbers containing 'M', but if I make the criteria and broader I get an error, so suspecting the limit is 200,000.

https://<mywindchillhost>/Windchill/servlet/odata/v5/ProdMgmt/Parts?$filter=contains(Number%2C'M')&$count=false

Re: Using REST API to get a list of all WTParts

ldutoit — Tue, 14 Mar 2023 09:31:43 GMT

Hi,

Yes this is a silly problem that we're also struggling with.

So ther requirement is to give Windchill a list of part number and then it needs to bring properties back of all the WTparts that was listed

Tried it via a saved Search Query endpoints supplying part number via KeyWord parameter but for some reasons it omits some parts in the response so doing it via SavedSearch End Point does not work correct. If I run the exact save query in Windchill Front end I get correct list:

https://<Wchillhost>/Windchill/servlet/odata/v4/SavedSearch/SavedQueries('OR%3Awt.query.SavedQuery%3A1294983587')/PTC.SavedSearch.ExecuteSavedSearch(Keyword='BN064295%3BBN064517_01%3BBN067254%3BBN067255%3BBN067521%3BBN067521-01%3BBN067521-02%3BBN067521-04%3BBN067521-04001%3BBN067794%3BBN067796%3BBN067797%3BBN067797-01%3BBN067797-02%3BBN067797-03%3BBN067797-04%3BBN067799%3BBN067799-01%3BBN067831%3BBN067833%3BBN067837%3BBN067840%3BBN067842%3BBN067848')

Is it possible to get WTParts out of Windchill with Rest API specifiying the list of WT parts?

Re: Using REST API to get a list of all WTParts

rleir — Tue, 14 Mar 2023 17:45:18 GMT

You can use a QB parameter and pass in a part number, then QB can report the attributes that you need. Use a python script to call this QB report repeatedly, once per part.

The python script is not difficult, but I don't have time at the moment to give the details.

Re: Using REST API to get a list of all WTParts

ldutoit — Wed, 15 Mar 2023 07:02:28 GMT

Re: Using REST API to get a list of all WTParts

rleir — Wed, 15 Mar 2023 09:58:12 GMT

Something like this to run a QB report:

# returns TSV or XML or XSL text static_p = ('servlet/WindchillAuthGW/wt.enterprise.URLProcessor/' 'URLTemplateAction?' 'Item+Name=Foo-T%2A&' 'format=formatCustom&' 'xsl2=&' 'SET_QUERY_LIMIT=20000&') if format == 'XML': format_xsl = 'identity.xsl' elif format == 'TSV': format_xsl = 'tsvFormat.xsl' sURL = self.wc_url + static_p sURL += ('xsl1=templates/reports/' + format_xsl + '&' + 'oid=OR%3Awt.query.template.ReportTemplate%3A' + str(report_ID) + '&' + parm_txt + 'action=ExecuteReport') return self.send_to_Windchill(sURL, expect_JSON=False)

parm_txt = 'PartNumber=' + p_number + '&'

I find the TSV format more useful. cheers -- R

Re: Using REST API to get a list of all WTParts

ldutoit — Fri, 17 Mar 2023 10:38:58 GMT

Thank you very much!! I will try it