This is what I had posted a while back about it:
CIM Cloud's API (Most use their eCommerce site but this link is about their API to the Hub) Data Hubs & API | cimcloud.com
Sage Data Exchange - by MBA is a great way to get JSON or XML from Sage 100 to integrate to other systems.
InSync is more of a Sync tool but they are used a lot for eCommerce sites Integrate Your Website (roi-consulting.com)
The Office 365 is really cool but is limited. They are developing for it so I would expect it to continue to expand as time goes on. It shows very well. It does require a dive into the Microsoft eco system of online apps.
Sage eBusiness Web Services is a module that can provide some limited access through an API. I do not believe they are doing any development work on it. No changes are expected. Here is a link to a website about Web Services, All for Sage e-Business Manager - e-Business Web Services (4ebm.com). This is part of Sages eBusiness Module which is a built in eCommerce Site. (Great, out of the box, module to get up and running with eCommerce) eBusiness hasn't been changed in many years and the eCommerce has a late 1990's look to it. It can be customized and developers do make changes to it.
Using BOI limits you to be on the local machine but does give you a lot of access to what you need.
Sage also has SDATA for Sage 100. It is not really being developed and is still in version 1 for Sage 100.
Visual Integrator can be used for Import/export of Files.
ODBC can be used to query (read only) data from Sage 100
Each option has it positive and negative sides. Some are built in (BOI, SData, ODBC), some are additional modules ( and others are 3rd party. Some of the options may also have an annual maintenance or subscription cost to it. Some will require more of an understanding of Sage 100 to make it all work (BOI, ODBC, Visual Integrator)
------------------------------
Todd Martin
MBA Business Software (https://www.mbabsi.com)
------------------------------
Original Message:
Sent: 03-03-2022 14:43
From: Kevin Moyes
Subject: Sage API Questions - how do you respond to this?
On-premise API: yes, that is the BOI.
Web API: no, not without custom programming or 3rd party software (with a few options)... unless SData or the eBusinessWebServices features are sufficient.
There are a few postings on Sage City for this subject, since it is asked often there.
------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------