I'm trying to get the assigned work per user per day from the API. The image shows a table from Clarizen's Project->Project Planning page Resources table. This is basically what I need, but for all project instead of one.
I've been looking at WorkItem, Timesheet and WorkByDay but while I get results I can't get the results shown in the table above even after specifying specific User and Project, so I must be getting something else.
This is the query that I thought would be right but it returns only one result which is not one of the dates in the table:
WHERE ResourceLink IN (
SELECT id FROM ResourceLink
WHERE Resource IN (
SELECT id FROM User
WHERE Name = 'NAME'
What would I need to query to get the green box's data?