Count number of element returned by OData request

[FM_13835117]

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)

[Fadel]

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

[FM_13835117]

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

[rajeshd105]

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

[FM_13835117]

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

[FM_13835117]

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

[FM_13835117]

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

Fred