Page 1 of 1

Pushing timesheets into SimPro

Posted: Tue Apr 11, 2023 3:56 am
by mytimesheets
We have two clients using simPro in New Zealand.

They would both like us to push weekly timesheets data for employees from our Payroll/Timesheet app.

They would like them to appear in jobs as employee times/costs.

As far as I can tell, we are not looking for the schedule endpoints. We need the times to be applied to the job as approved costs.

Can you tell us which endpoint we should be using

Our data consists of:

- employee id
- entry date
- job id
- job cost center id
- start time and finish time (or total hours as a decimal number if required)
- we can pass a rate code if that is required

These are all confirmed/approved entries. We have a weekly process where we export to their selected payroll system (Xero via their API). We want to also send to simPro via the API.

Thanks
Raymond

Re: Pushing timesheets into SimPro

Posted: Tue Apr 11, 2023 4:15 am
by mytimesheets
Just to clarify, I have read this post already viewtopic.php?f=2&t=1699&p=4287&hilit=timesheets#p4287

Re: Pushing timesheets into SimPro

Posted: Tue Apr 11, 2023 4:26 am
by Sindre
Hi Raymond,
This sound very much like the Job Cost Centers Schedule.
https://developer.simprogroup.com/apido ... 71d4b48ce2

Code: Select all

/api/v1.0/companies/{companyID}/jobs/{jobID}/sections/{sectionID}/costCenters/{costCenterID}/schedules/
Here you can create a schedule with the information you have such as employee ID, date, rate code and start/stop time directly in a job/cost centre.

Code: Select all

{
"Notes": "string",
"IsLocked": true,
"Staff": 0,
"Date": "2021-04-22",
"Blocks": [
{
"StartTime": "08:00",
"EndTime": "16:00",
"ScheduleRate": 0
}
]
}

Alternatively, see if you can create a work order for the employee. And then update it with a PATCH request where you can add a Block with start/stop time and the Schedule Rate. Here you can also set is as approved. The creation and update must be done in two different transactions as described in the documentation.

Post:

Code: Select all

/api/v1.0/companies/{companyID}/jobs/{jobID}/sections/{sectionID}/costCenters/{costCenterID}/workOrders/
https://developer.simprogroup.com/apido ... ac6228923c

Patch:

Code: Select all

/api/v1.0/companies/{companyID}/jobs/{jobID}/sections/{sectionID}/costCenters/{costCenterID}/workOrders/{workOrderID}
https://developer.simprogroup.com/apido ... f4ff6a4284

I hope some of this can be of use.

Regards

Re: Pushing timesheets into SimPro

Posted: Tue Apr 11, 2023 6:35 am
by mytimesheets
Thanks. I will do some reading and see how the companies are doing it manually as well.