Pulling data from Project WebApp using Sharepoint send HTTP request not returning all rows

Like (0) Share

Report

Posted on 14 Jan 2020 15:14:53 by MWaSa

Hi,

I am trying to pull tasks from Project Online (WebApp) using the SharePoint Send HTTP.

I am only getting 301 rows returned. Is there a way to bypass this limit.

_api/ProjectData/Tasks/?$Select=TaskId,TaskName,TaskDuration,TaskPercentCompleted,TaskStartDate,TaskFinishDate &$filter=ProjectId eq guid'xxxxx' and Filter eq 'y' &$top=5000

Thanks

All responses (4)

Answers (1)

mabloq 2 on 26 May 2023 at 03:57:26

Like (0)

Report

Re: Pulling data from Project WebApp using Sharepoint send HTTP request not returning all rows

Are you getting the same 300 records over and over again?
Community Power Pla... on 10 Jun 2021 at 14:46:42

Like (0)

Report

Re: Pulling data from Project WebApp using Sharepoint send HTTP request not returning all rows

Hey @mws
Could you please let me know how you have set up the loop? I am facing the same issue.
Verified answer

MWaSa 10 on 05 Feb 2020 at 13:27:36

Like (0)

Report

Re: Pulling data from Project WebApp using Sharepoint send HTTP request not returning all rows

Got it working by setting up a loop as the api only returns 300 records.
manuelstgomes 6,625 on 05 Feb 2020 at 09:38:46

Like (1)

Report

Re: Pulling data from Project WebApp using Sharepoint send HTTP request not returning all rows

HI @mws

Try using the native Project actions. This will make things a lot easier, and you don't need to muck around with HTTP requests.

Please let me know if you need help achieving this.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel