topic Re: Count number of element returned by OData request in Windchill Customization

Count number of element returned by OData request

FM_13835117 — Wed, 30 Jul 2025 14:50:39 GMT

My count OData request does not work :

https://<url>/Windchill/servlet/odata/v5/DataAdmin/Containers('OR:wt.pdmlink.PDMLinkProduct:681234555')/Folders('OR:wt.folder.Cabinet:681234597')/Folders('OR:wt.folder.SubFolder:681267970')/Folders('OR:wt.folder.SubFolder:681267975')/FolderContents?$count
Thanks for any help.

Fred

Version: Windchill 12.1 (Product v12.1.2.0, REST Services v2.3)

Re: Count number of element returned by OData request

Fadel — Thu, 31 Jul 2025 12:36:49 GMT

Do you have duplicate objects ? can it be that you have a count for each object version ?

Re: Count number of element returned by OData request

FM_13835117 — Thu, 31 Jul 2025 15:01:25 GMT

Hello @Fadel

Thanks for your message. I don't think I have duplicated values, but I have so many values that I get this mesasge. So I would like to paginate the results using 'count', 'top' and 'skip' parameters but it doesn't work and I wonder if it is because of the version I use.
Fred

Re: Count number of element returned by OData request

rajeshd105 — Mon, 18 Aug 2025 09:56:48 GMT

Hi,

In your request URL I observed the Boolean value missing for $count, there is no issue with the version

Re: Count number of element returned by OData request

FM_13835117 — Mon, 18 Aug 2025 13:25:11 GMT

Hi @rajeshd105,

Thanks for your reply.

I've modified the request as you proposed : "$count=true", but server seems to request first all elements before to count and I get always the same error message 😞 : "The returned query result has exceeded the query limit, and only 50,000 result returned."

I also try these parameter on another request and I just have the complete result but no count value :

https://<url>/Windchill/servlet/rest/v1/contexts/wt.pdmlink.PDMLinkProduct%3A681234555/folders

https://<url>/Windchill/servlet/rest/v1/contexts/wt.pdmlink.PDMLinkProduct%3A681234555/folders?$count=true

I also tested limit attribute and nothing change, I get all values :

https://<url>/Windchill/servlet/rest/v1/contexts/wt.pdmlink.PDMLinkProduct%3A681234555/folders?$limit=2

Fred

Re: Count number of element returned by OData request

FM_13835117 — Mon, 18 Aug 2025 13:29:15 GMT

Sorry, I was confusing with the rest request. My apologise.

With ODATA request it works fine, Thanks a lot !

Do you know how to limit the number of results ?
Fred

Re: Count number of element returned by OData request

FM_13835117 — Mon, 18 Aug 2025 13:32:53 GMT

In fact, it works when the limit of 50.000 items is not reached otherwise I got the error message.

Fred