DEVELOPER CENTER
Hi
I would like to connect a Business Intelligence product (Sage Intelligence Reporting) to simPRO for read-only data access via the API.
My intent was to utilise the REST ODBC driver provided by C-Data which has OAUTH capabilities.
What steps will I need to take to be granted access?
Thanks in advance.
Colin
Business Intelligence
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.
-
colinspooner
- Posts: 1
- Joined: Tue Mar 02, 2021 2:55 am
-
Tiago Valente
- Posts: 89
- Joined: Wed Sep 25, 2019 4:30 am
Re: Business Intelligence
I'll go through the steps where I created my company's API:
1) Register an access key through Simpro's website. You need this to authenticate with SIMPRO
2) use your local company's proxy username and password (your company might block access through their local proxy) - contact your local IT admin
3) Do a simple API call like below: YourCompanyWebsiteToSimpro.com/api/v1.0/companies/'+ str(CompanyID) + '/jobs/'
If your company is setup like mine, you'll need to access the individual company IDs to access the end points for jobs.
4) Transform the API call data using a JSON parser. I used Python but you can use Javascript or any other programming language really.
When you say you're using a business intelligence product, I'm not sure SIMPRO is setup to accept a bolt on solution. You might need an API developer to complete this. That's the steps I did above.
If you're not technical or know anyone in your company who is - you can reach out to SIMPRO's partners, I contacted Syncezy when I was trying to figure this stuff out. But ended up cracking the coding myself and didn't need them.
1) Register an access key through Simpro's website. You need this to authenticate with SIMPRO
2) use your local company's proxy username and password (your company might block access through their local proxy) - contact your local IT admin
3) Do a simple API call like below: YourCompanyWebsiteToSimpro.com/api/v1.0/companies/'+ str(CompanyID) + '/jobs/'
If your company is setup like mine, you'll need to access the individual company IDs to access the end points for jobs.
4) Transform the API call data using a JSON parser. I used Python but you can use Javascript or any other programming language really.
When you say you're using a business intelligence product, I'm not sure SIMPRO is setup to accept a bolt on solution. You might need an API developer to complete this. That's the steps I did above.
If you're not technical or know anyone in your company who is - you can reach out to SIMPRO's partners, I contacted Syncezy when I was trying to figure this stuff out. But ended up cracking the coding myself and didn't need them.