Timesheets API to pull clocked hours

[tmeier]

We want to use the timesheet API (/api/v1.0/companies/{companyID}/employees/{employeeID}/timesheets/) to pull the clock on / clock off time stamps - see attached. However what I get are the jobs and activities only; i.e. in the attached I get the 4 timestamps for the scheduled time but the API documentation doesn't seem to be allowing anything other than

"Activity,Job,Lead,Quote"
"Includes=Job,Quote"
Set the type of schedule required.

How I get the clocked hours for an individual timesheet?

Timesheet Example.png (30.63 KiB) Viewed 51875 times

[SimproAPITeam]

Hi,
On the time sheet endpoint you get a href link which gives you the specific schedule. This will give you time blocks for that schedule.

You can also get these actual time blocks on the work order endpoints. See examples here:
https://developer.simprogroup.com/apido ... ork-Orders

Regards

[AdrianL]

Hi,

We ahve run into a a similar issue, where we need access to the CLOCK ON?CLOCK OFF time directly. not the schedulled time.

the closest we've been able to get through BI reporting is the start of an activity (ie: start travelling) however this time is still inconcistant with the CLOCK ON/OFF time.

Is there a way we can get the actual CLOCK times?

[SimproAPITeam]

Hi there,

So when the user updates the times (through mobile app or desktop) there are a few ways to access this through the API depending on the use case.

The best way for this use case is the high level job work orders endpoint with the Approved=true filter and show the 'blocks' used like so

{{BASE_URL}}/0/jobWorkOrders/?columns=ID,Blocks&Approved=true

User can search for all the fields listed in the response (ID, Employee.ID) and theres more about this in our documentation here:
https://developer.simprogroup.com/apido ... ork-Orders



Below is a stripped down response body and this is gotten from the detail view URL
{{BASE_URL}}/0/jobWorkOrders/{jobWorkOrderID}
{
  "Blocks": [
    {
      "Hrs": 8,
      "StartTime": "08:00",
      "ISO8601StartTime": "2018-05-21T19:53:39+10:00",
      "EndTime": "16:00",
      "ISO8601EndTime": "2018-05-21T19:53:39+10:00",
      "ScheduleRate": {
        "ID": 12345,
        "Name": "Overtime"
      }
    }
  ],
  "ScheduledHrs": 8,
  "ScheduledStartTime": "08:00",
  "ISO8601ScheduledStartTime": "2018-05-21T19:53:39+10:00",
  "ScheduledEndTime": "16:00",
  "ISO8601ScheduledEndTime": "2018-05-21T19:53:39+10:00",
  "DateModified": "2018-05-21T19:53:39+10:00",
}

Within those blocks, the StartTime and EndTime are the times that are set by the user in the application and get updated when the user updates them (say when the clock in or out), the scheduled fields are the ones that are set initially but aren't the actual times.

There's a bunch of ways to see these block values so if you're curious can see the following pages on our documentation site

https://developer.simprogroup.com/apido ... cc8c41e061 (Schedules)

and there's also the other tabs on the work orders page
https://developer.simprogroup.com/apido ... 44cc5478bd

Hope this helps,