Hi there,
We have a situation on a customer account where a record (ID=1589347) has dropped off the Schedule list endpoint, but is available when we query it by ID.
Example List:
GET https://{customer}.simprocloud.com/api/v1.0/companies/47/schedules/?orderby=DateModified&pageSize=100&page=1&columns=ID%2CDateModified
Result: 200 OK. Schedule ID 1589347 is not listed on any pages
Example Detail:
GET https://{customer}.simprocloud.com/api/v1.0/companies/47/schedules/1589347
Result: 200 OK. Schedule information is shown.
Is this expected? Customer is reporting that the schedule isn't deleted (which I can't confirm by hand). Is there some status which would cause the record to be skipped by the list endpoint? Is it actually deleted but the detail endpoint isn't filtering correctly?
Gavin.
Schedule missing from list endpoint, but available by ID
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.
-
gavinhodge
- Posts: 28
- Joined: Mon Apr 27, 2020 1:27 am
-
gavinhodge
- Posts: 28
- Joined: Mon Apr 27, 2020 1:27 am
Re: Schedule missing from list endpoint, but available by ID
Hi Simpro team, it has been more than a week.
What needs to happen next? More information required? Escalation from customer to their account manager?
Gavin.
What needs to happen next? More information required? Escalation from customer to their account manager?
Gavin.
-
SimproAPITeam
- Posts: 831
- Joined: Wed May 01, 2024 2:31 am
Re: Schedule missing from list endpoint, but available by ID
Hi Gavin,
Apologies for the delay in getting back to you on this.
We've looked into the discrepancy you reported with Schedule ID 1589347. The most likely explanation is that this schedule spans midnight (i.e. it runs from one day into the next). When a schedule crosses midnight, simPRO records it as two linked entries — the hours from the second portion are rolled up into the original schedule for reporting purposes, so that second entry is intentionally excluded from list views to avoid double-counting. It's still a valid, active record though, which is why it returns correctly when queried directly by ID.
Could you confirm whether schedule 1589347 is the "second half" of a shift that crosses midnight? If so, this is expected behaviour rather than a fault, and no action is needed.
If it turns out that isn't the case, please raise it via our helpdesk so it can be investigated further:
https://helpdesk.simprogroup.com/
Thanks again for your patience, and sorry for the wait on this one.
Regards
Apologies for the delay in getting back to you on this.
We've looked into the discrepancy you reported with Schedule ID 1589347. The most likely explanation is that this schedule spans midnight (i.e. it runs from one day into the next). When a schedule crosses midnight, simPRO records it as two linked entries — the hours from the second portion are rolled up into the original schedule for reporting purposes, so that second entry is intentionally excluded from list views to avoid double-counting. It's still a valid, active record though, which is why it returns correctly when queried directly by ID.
Could you confirm whether schedule 1589347 is the "second half" of a shift that crosses midnight? If so, this is expected behaviour rather than a fault, and no action is needed.
If it turns out that isn't the case, please raise it via our helpdesk so it can be investigated further:
https://helpdesk.simprogroup.com/
Thanks again for your patience, and sorry for the wait on this one.
Regards
Simpro API Team | Simpro Software Group
DEVELOPER CENTER