Approach Question
I'm trying to build a report that effectively shows hours worked per person per day with details on each line item of project / task. In looking over the documentation and what is returned from the API I'm having a hard time figuring out how I would piece all of that together.
I'm basically trying to build company wide timesheet breakdown similar to the individual timesheet breakdown in the standard cashboard interface.
I'm able to query time entries and get data tied back to individuals but I'm not seeing anything directly related to the project other than the line_item_id. Is there a way to query the project name by the line_item_id or will I need to pull out all line items and projects into seperate arrays and match them?
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
Support Staff 1 Posted by Seth B on 28 Oct, 2018 08:32 PM
Hey Bill, apologies on the delay in getting back to you. There’s no way throug hthe API to query project name by line_item_id, so you’ll have to query both and then match project_id with the project name that way.