Hi Soorya Parthiban what version of Sage 300 is deployed at the site you're working on, and do you know whether the Web API and Web Screens are deployed?  Newer versions of Sage 300 do have the option to deploy a REST API but its optional and not all sites do it.  It may be not be a large task to deploy the API if its not currently present, but that again will depend on the version and whether its perpetually or subscription licensed.

Aside from the REST API there is a COM API you can use by writting some middlewear in java, python, VB, etc to extract the data and transform it as needed.

Yes there are quite a few tools out there for moving data out of Sage 300 and into other systems - Google is your friend.

...and of course there is also direct-SQL integration to pull data out raw although I wouldn't generally recommend this (unless the data you need is non-financial and pretty simple).  E.g. if you just want a list of vendors, pulling them from the table APVEN can be a simple solution.  However if you want to pull transactions out of Sage 300, doing this via SQL could be very painful.

Documentation will depend. Sage does provide some documentation to get you started, and there is a Swagger UI page available for the API you can view here, but lets see what options you have for accessing Sage 300 data.  Please provide as much info about the Sage 300 site as you can.

Hi Soorya Parthiban what version of Sage 300 is deployed at the site you're working on, and do you know whether the Web API and Web Screens are deployed?  Newer versions of Sage 300 do have the option to deploy a REST API but its optional and not all sites do it.  It may be not be a large task to deploy the API if its not currently present, but that again will depend on the version and whether its perpetually or subscription licensed.

Aside from the REST API there is a COM API you can use by writting some middlewear in java, python, VB, etc to extract the data and transform it as needed.

Yes there are quite a few tools out there for moving data out of Sage 300 and into other systems - Google is your friend.

...and of course there is also direct-SQL integration to pull data out raw although I wouldn't generally recommend this (unless the data you need is non-financial and pretty simple).  E.g. if you just want a list of vendors, pulling them from the table APVEN can be a simple solution.  However if you want to pull transactions out of Sage 300, doing this via SQL could be very painful.

Documentation will depend. Sage does provide some documentation to get you started, and there is a Swagger UI page available for the API you can view here, but lets see what options you have for accessing Sage 300 data.  Please provide as much info about the Sage 300 site as you can.