Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 464
  • Last Modified:

Increase records returned from project oData query

Hi, currently one of our reports uses the oData api to get a list of all projects, this currently only returns 100 projects, which apparently is the default for this.  However, I've ran the PS command:

Set-SPProjectOdataConfiguration -EntitySetName Projects -PageSizeOverride 300

And when I run (Get-SPProjectOdataConfiguration).EntitySetsWithMaxPAgeSizeOverride it shows that the Projects value is now 300 (previously it wasn't showing Projects at all) but when I go to http://server/PWA/_api/ProjectData/Projects it still only returns 100 records.  I know that our reporting needs to change to accommodate the limit of 100 however until we can get that done is there another way to increase this limit? Do I have to select the PWA instance before running the above command?

Cheers
0
lee_murphy
Asked:
lee_murphy
1 Solution
 
Dr. Thomas HenkelmannDirector Consulting ServicesCommented:
Hi,

too easy to ask for points: just run an "iisreset" to restart the IIS Service.

No points, please!

Thomas
0
 
lee_murphyAuthor Commented:
All my questions are easy when you know how :) Thank you very much!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now