Read Lookup and Non-Lookup custom field value using odata service project server

Read Lookup and Non-Lookup custom field value using odata service project server

Reporting data in Project Server can be read by multiple ways.Business Intelligence include a data connection in Project Web App for OData reporting.In this article, I am going to create a simple console application to create OData connection and use of OData service using Linq Query.

  1. Open visual studio and create console application.
  2. Add ProjectData service service reference to providing below address “http://ServerName/PWAName/_api/ProjectData/”

 

 

Add service reference in OData

 

You can read lookup type and non-lookup type custom field value using this code

You can read task and resource assigned on task using below code.Only you can see your own task because you are running this code using your credential.