Count number of element returned by OData request

Forum|Forum|8 months ago
July 30, 2025
2 replies
531 views

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)

Other Web Services

Fadel

23-Emerald I

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

Buiꓘa

F

FM_13835117

Author

6-Contributor

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

R

rajeshd105

12-Amethyst

Hi,

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

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=true

F

FM_13835117

Author

6-Contributor

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