How would I disable the limit of 25 entries for ODATA REST endpoints for windchill?
ex. <server>/Windchill/servlet/odata/v3/DocMgmt/Documents ---- only returns 25 entries
@pa2t I am not sure what you mean by "disable ODATA return limit of 25 entries".
Assuming what you want is increasing the limit of entities return, try below:
Prefer : odata.maxpagesize=<no of entities up to 200>
For example: adding below the header will increase the entities return count from 25 to 150
Prefer : odata.maxpagesize=150
Currently, the maximum root entities retrievable is 200.
@amarsingh , is there a way to configure this on the OData connector itself (that is on TWX side)?
I know a way by adding a custom header. There is an post already about Thingworx swagger connector but the same should be applicable for Thingworx OData Connector.
FYI, there is also a Windchill knowledge article that touches on this:
Yes, this is the original article that explains that REST request headers should be modified to include the parameter:
"Prefer" + "odata.maxpagesize=100"
But it does not explain how to perform that at OData connector level.
I have created a short document on this here https://community.ptc.com/t5/ThingWorx-Developers/Adding-a-Custom-header-in-Thingworx-Connector/td-p.... Let me know if you still face difficulties
Thank you very much @amarsingh !
I will test that soon, but I'm pretty sure it's the best solution, especially to automate the parameter for route services (the ones created just by using API maps).