Endpoint for Timesheets as per Jobcard not Schedule ?

Wish the API had something it doesn't? Post here!
Forum rules
  • Check the documentation first. Before posting questions, please check the documentation to ensure it doesn't already cover what you need.
  • No spam. All automated messages, advertisements, and links to competitor websites will be deleted immediately.
  • Post in relevant sub-forums only. Messages posted in the wrong topic area will be removed and placed in the correct sub-forum by moderators.
  • Respect other users. No flaming or abusing fellow forum members. Users who continue to post inflammatory, abusive comments will be deleted from the forum after two warnings are issued by moderators.
  • Harassment. No threats or harassment of other users will be tolerated. Any instance of threatening or harassing behavior is grounds for deletion from the forums.
  • Adult content. No profanity or pornography is allowed. Posts containing adult material will be deleted.
  • Bandwidth. All images and signatures must be 500 x 500 pixels or smaller. Posts containing over-sized images and signatures will be removed.
  • Illegal content. No re-posting of copyrighted materials or other illegal content is allowed. Any posts containing illegal content or copyrighted materials will be deleted.
Post Reply
JohnSemmens
Posts: 5
Joined: Tue Feb 08, 2022 5:32 am

Endpoint for Timesheets as per Jobcard not Schedule ?

Post by JohnSemmens » Wed Jun 01, 2022 7:54 am

Hi Guys,
We're using the API to retrieve timesheets for a payroll system.
We are using the /employee - /timesheets GET query to retrieve timesheets for each employee:

Code: Select all

/api/v1.0/companies/2/employees/735/timesheets/?StartDate=2022-06-01&EndDate=2022-06-01
The results returned appear to be scheduled times for the employee.
Is it possible to retrieve the actual times recorded on the job card via the API ?
Best regards,
John Semmens
Sindre
Posts: 493
Joined: Wed Apr 20, 2022 4:51 am
Location: Brisbane

Re: Endpoint for Timesheets as per Jobcard not Schedule ?

Post by Sindre » Thu Jun 02, 2022 12:40 am

Hi,
I think this should help you get what you are after.

This endpoint includes the job cards for each employee.

Code: Select all

/api/v1.0/companies/{companyID}/jobWorkOrders/


You can search for a specific employee and choose to include information about the time blocks they are assigned. Try this:

Code: Select all

/api/v1.0/companies/{companyID}/jobWorkOrders/?Staff={staffID}&columns=ID,Staff,Blocks
Please see the documentation here
https://developer.simprogroup.com/apido ... 24ed48d99a
Sindre
API Developer | Simpro Software Group
JohnSemmens
Posts: 5
Joined: Tue Feb 08, 2022 5:32 am

Re: Endpoint for Timesheets as per Jobcard not Schedule ?

Post by JohnSemmens » Thu Jun 02, 2022 2:37 am

Thanks Sindre,

I've tested and reconciled the results from the query:

Code: Select all

/api/v1.0/companies/{companyID}/jobWorkOrders/?Staff={staffID}&columns=ID,Staff,Blocks
Unfortunately, it also returns Scheduled time and not Actual time worked from Job Cards.

I don't think the API has an endpoint to return what we need, so we will use a different approach.
Thanks.
Best regards,
John Semmens
Sindre
Posts: 493
Joined: Wed Apr 20, 2022 4:51 am
Location: Brisbane

Re: Endpoint for Timesheets as per Jobcard not Schedule ?

Post by Sindre » Thu Jun 02, 2022 2:59 am

Hi,
We will move this to feature request and will give you an update when it has been implemented.
Sindre
API Developer | Simpro Software Group
Post Reply