Cross Join of Project Server odata REST query

Asked Jun 04 '18 at 14:16

Active Jun 04 '18 at 14:16

Viewed 254 times

I am trying to be efficient in my _api/projectdata rest query and get specific results from timesheet actuals. However, in someones great wisdom they didn't provide something as simple as the projectId in the properties. So I came up with the following not sure whether the cross join is supported but it doesn't puke. The issue is my results contain data that should be filtered. Is this format possible?

/epm/pma/_api/ProjectData/TimesheetLineActualDataSet?$select=ResourceName,ActualWorkBillable,TimeByDay&$crossjoin(TimesheetLine,TimesheetLineActualDataSet)&$apply=filter(TimesheetLine/ProjectId eq 'd8ba8b7e-3308-471c-a884-48f2116c803f' and TimesheetLine/TimesheetLineId eq TimesheetLineActualDataSet/TimesheetLineId and TimesheetLineActualDataSet/ActualWorkBillable > 0 and TimeByDay gt datetime'2017-10-01')

asked Jun 04 '18 at 14:16

Beruken

please disregard the > in the filter as it should be gt. Same issue. – Beruken Jun 04 '18 at 14:32
Did you try adding a $select parameter to the query string? – John Palmer Sep 20 '18 at 20:58

Cross Join of Project Server odata REST query

0 Answers0