Approach Question

Bill's Avatar

Bill

26 Oct, 2018 05:30 PM

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?

  1. Support Staff 1 Posted by Seth B on 28 Oct, 2018 08:32 PM

    Seth B's Avatar

    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.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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