Check out the pull/get from excel option. 

www.youtube.com/watch

Sorry the link was removed. Try this. https://bit.ly/2RXz3zJ

Interesting, so there is not like a restful API that you can use to request information? That is what I was trying to find. I'll have to work with what is provided. Thank you for taking the time to respond. 

Hey JC. I'm not sure if Sage100 has a built in API. ...I have been looking for the same thing.

ODBC is the most common way to get info from Sage 100 from within a domain/network.

There is a very outdated component called SData which has not been updated for several years now and i believe it is being phased out or at least not going to receive any future updates.

This year, Sage did announce that they have been partnering with Microsoft and PowerApps to release a Connector that can be used by Microsoft's platform which is as close to a restful API that i have seen however there have been licensing issues that still need to be worked out. Last i heard, Microsoft made Sage's Connector a premium one which will likely hurt its early adoption rate.

I got to experiment with it for a little bit and it looks promising but i believe the license issues need to be worked out before Sage releases it to the general public.

The other approach is to use the Business Object Interface (BOI) to pull data from Sage 100 but this requires execution within a network/domain that can access the Sage 100 server installation. You can find documentation on the objects here under "Object Reference"

http://help-sage100.na.sage.com/2019/FLOR/

eBWS might also be an option, but it has limited functions.

https://cdn.na.sage.com/docs/en/customer/100erp/2019/open/WebServices.pdf

There isn't a restful API. The closest that it comes it the Business Object Interface (BOI).

Take a look at this https://wiki.mbabsi.com/doku.php/enhancements/sage100/modules/cs100e-sde

Seems kinda crazy to me that a company this large wouldn't support some kind of restful api. This way of interacting with the sage data just seems outdated. If they want people to be able to build applications around their platform they should at least consider it. 

Sage 100 is not a new product.  They are working on improvements / modernization, but what is available today is functional and feature rich (with a learning curve).