DEVELOPER CENTER
Hi,
Trying to develop a BI report based on the 'Schedule Comparison' report already in Simpro. Any information on where the planned versus actual job time is located would be appreciated. We are using a thrid party API to access the tables, we think we are missing a number of tables with the information.
Thanks
Schedule Comparison
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.
Re: Schedule Comparison
Hi,Msharp wrote: ↑Wed Oct 18, 2023 8:10 am Hi,
Trying to develop a BI report based on the 'Schedule Comparison' report already in Simpro. Any information on where the planned versus actual job time is located would be appreciated. We are using a thrid party API to access the tables, we think we are missing a number of tables with the information.
Thanks
I am trying to obtain the same information. Any help would be greatly appreciated.
Thanks
GT
Re: Schedule Comparison
Hi GTacs,
Unfortunately I do not know how this report is compiled or getting data as it's not available through the Rest API.
You can try to contact our Simpro helpdesk who are familiar with Simpro premium and might have some overview over the BI functionality.
See contact details here:
https://helpdesk.simprogroup.com/
Regards
Unfortunately I do not know how this report is compiled or getting data as it's not available through the Rest API.
You can try to contact our Simpro helpdesk who are familiar with Simpro premium and might have some overview over the BI functionality.
See contact details here:
https://helpdesk.simprogroup.com/
Regards
Sindre
API Developer | Simpro Software Group
API Developer | Simpro Software Group
Re: Schedule Comparison
Hi GTacs and Msharp,
I just want to follow up on your posts regarding information about job time as there might have been a misunderstanding that you were after BI reporting data and not API data.
If you want job times from a work order you can find it here in the cost centre work order endpoint:
https://developer.simprogroup.com/apido ... 9050a003bf
Also, if there is other info you need from the API please provide an example and screen shot of where this data is in Simpro and we will do our best to help you get the same data in the API.
Regards
I just want to follow up on your posts regarding information about job time as there might have been a misunderstanding that you were after BI reporting data and not API data.
If you want job times from a work order you can find it here in the cost centre work order endpoint:
https://developer.simprogroup.com/apido ... 9050a003bf
Also, if there is other info you need from the API please provide an example and screen shot of where this data is in Simpro and we will do our best to help you get the same data in the API.
Regards
Sindre
API Developer | Simpro Software Group
API Developer | Simpro Software Group
Re: Schedule Comparison
Hi Matthew,
This data is not currently available in our API. The schedules and work orders only contain the actual times and not planned.
I have moved your post to the feature request channel so it can be evaluated for future development.
Please note that we can not give a time estimate for new features but follow our release notes for new functionality added to the API.
Regards
This data is not currently available in our API. The schedules and work orders only contain the actual times and not planned.
I have moved your post to the feature request channel so it can be evaluated for future development.
Please note that we can not give a time estimate for new features but follow our release notes for new functionality added to the API.
Regards
Sindre
API Developer | Simpro Software Group
API Developer | Simpro Software Group