Forum Discussion
GuusHendrickx
Feb 06, 2025Copper Contributor
Getting Project Server data using REST APIs in ADF
Hello, I have created a pipeline that copies Project Server data from REST APIs to a JSON Datalake and then to my SQL Server database (SSMS). I was inspired by the following blog: https://techcommu...
Paul_Mather
Feb 07, 2025MVP
Hello GuusHendrickx ,
Here are the default page sizes for the Project Online OData feeds - see the "Limits for ProjectData queries" table: https://learn.microsoft.com/en-us/previous-versions/office/project-odata/jj163015(v=office.15)
Here is a post that might help you with Azure ADF pagination: https://learn.microsoft.com/en-us/answers/questions/236150/how-to-perform-pagination-in-azure-data-factory-us
Paul
- GuusHendrickxFeb 10, 2025Copper Contributor
Hello Paul,
Thank you for the links!
My problem was solved with the use of an Until loop in ADF.
Kind regards,Guus