Solved

Increase records returned from project oData query

Posted on 2014-09-10
2
403 Views
Last Modified: 2014-09-14
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
Comment
Question by:lee_murphy
2 Comments
 
LVL 12

Accepted Solution

by:
thausla earned 500 total points
ID: 40316757
Hi,

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

No points, please!

Thomas
0
 

Author Closing Comment

by:lee_murphy
ID: 40322169
All my questions are easy when you know how :) Thank you very much!
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
A simple overview of the possibilities of using technology for project management.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question