Skip to main content
P
pa2t1-Visitor
1-Visitor
June 4, 2019
Question

How to disable ODATA return limit of 25 entries

  • June 4, 2019
  • 2 replies
  • 5275 views

Hi All,

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

 

 

Thanks,

Patrick 

2 replies

A
amarsingh12-Amethyst
12-Amethyst
June 6, 2019

@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:

Specify header

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.

S
ssauvage-214-Alexandrite
14-Alexandrite
January 30, 2020

Hi.

@amarsingh , is there a way to configure this on the OData connector itself (that is on TWX side)?

Thanks!

A
amarsingh12-Amethyst
12-Amethyst
February 4, 2020

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.

 

Link to the article: https://community.ptc.com/t5/ThingWorx-Developers/Custom-headers-for-swagger-connector/td-p/538759

M
MichaelChatel5-Regular Member
5-Regular Member
February 4, 2020

FYI, there is also a Windchill knowledge article that touches on this:

 

https://www.ptc.com/en/support/article?n=CS294238

 

 

S
ssauvage-214-Alexandrite
14-Alexandrite
February 4, 2020

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.

    A
    amarsingh12-Amethyst
    12-Amethyst
    February 4, 2020

    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/647507. Let me know if you still face difficulties

      Terms & ConditionsCookie settingsAccessibility statement