Is there any Open API for Sage 500

Hi, 

I need to know if there are open APIs to integrate my web applications with sage 500 ?

similar to the one available for Sage Business cloud accounting here : https://developer.sage.com/api/accounting/api/

Regards,

Neetish 

  • Are you perhaps looking for information on Sage 50? That's a different product. From your last post, it seems you're looking to integrate your AP add-on product but Sage 500 is an ERP package and there are very few financials-only customers. Although AP supports non-inventory and miscellaneous item purchases, the majority of the functionality integrates heavily overall with the ERP distribution model so there are multiple types and features of vouchers. Some of these are supported in available import APIs and some - like those that support purchase receipts - are not. The APIs are generally available in the back-end only with documentation available with the SDK. The only back-end DBMS supported is SQL Server and the front-end is developed in .Net and VB6. If you do have an installation of Sage 500 and don't want to use the DI front-end, search the database for the API stored procedures associated with the Stg (staging tables) you require. Review the DI\Samples spreadsheets or DI\Mapping XML files and/or the Data Import help in your Sage 500 client installation to support front-end mapping to the back-end import schema. The back-end code is open source and a decent SQL developer can interpret the staging, validation and import requirements to call the different APIs directly but explanations of the data elements is generally available only in the metadata contained in the data dictionary and/or from the front-end that organizes the metadata from the data dictionary.

  • in reply to Contefication

    Ok, i thought that there was a slight misunderstanding in the previous post hence i asked about API's which can helps us ( as product developers) to integrate our clients sage 500 users in sending invoices directly from our SaaS base software into their sage 500, like we have done for sage cloud 

    Does this mean that this as a one time integration for all sage 500 customers or it can only be done individually for each installation? 

  • in reply to Neetish Tewari

    You can build an import feature or integration but you're working in a different environment with a more complex processing model compared to Sage Cloud. Without a reference copy of the Sage 500 product or the Sage 500 SDK, you would need to work with a current developer to build what you want. The APIs are available in the application code, or possibly available via a third-party developer but there are no APIs available to the general public and there is no documentation on the APIs available from Sage outside of the SDK,

  • in reply to Neetish Tewari

    In addition to what Contefication stated and what I surmised from your post, you are looking for web APIs specifically to build your integration around.  If that is the case, sorry to disappoint you but Sage never created these types of APIs for Sage 500.  You could create your own, but as Contefication pointed out you would need to be familiar with Sage 500 and how its current APIs work.

    You may want to see if any of the third party developers for Sage 500 have already created web APIs that you could purchase, or engage one of them to build them for you.