RESTful API for Sage 50 Accounts
One of the most common integration requirements for most businesses is that of integrating the ‘Business System’ whether that’s a Customer Relationship Management (CRM) system, an Order Processing System or an E-Commerce Website with the company Financial System.
Despite the growing crop of web-based or ‘cloud’ accounting software such as Xero, Freshbooks, Clearbooks and Kashflow; Sage 50 Accounts remains the default choice of accounting software for almost half of all small to medium enterprises in the UK.
Why we built our own RESTful API for Sage 50 Accounts
As a business that develops ‘cloud’ software systems primarily using PHP, the Hyperext team are massive fans of web based accounting software. (We actually use Xero to keep tight control of our own financials) but over the years we’ve had to solve the Sage Integration problem for many customers, so we’ve invested a lot of time and effort (and developer intelligence) in creating our own set of web services for Sage 50 Accounts, because the Sage Desktop software model just doesn’t lend itself to web API integrations.
Sage will not support your PHP integration
Sage will tell you they don’t support PHP which seems incredibly shortsighted given the millions of software systems, web apps, mobile apps and e-commerce systems that are built in PHP. We originally built our API using PHP, and we ran it successfully for a few years but it was not robust enough to handle multiple concurrent transactions, so we had to take the plunge and rebuild it in .Net using C#. This has vastly improved the connection handling performance.
The good news is that Hyperext have now developed a RESTful API for Sage 50 Accounts that will allow developers to connect securely across the Internet using standard API technologies like JSON, XML and HTTPS to Create, Read, Update and Delete records in Sage 50 Accounts in real time. The HyperSage API works with the latest Making Tax Digital (MTD) compliant versions of Sage 50 Accounts UK which includes v24.x (2018) and v25.x (2019) at the time of writing.
What about Sage 50 Cloud?
The secret about Sage 50 Cloud is that it is still the same desktop client as its predecessor Sage 50 Accounts, the only real difference is that it uses a little file system synchronisation tool, similar to Dropbox, to copy your raw Sage data files from your server to the ‘Sage Cloud’. This means you still need the HyperSage API to integrate with Sage 50 Cloud which is the aforementioned version v25.x as it happens.
The HyperSage API has endpoints for Customers, Suppliers, Sales Orders, Purchase Orders, Sales Invoices and Purchase Invoices.
If you’re a developer looking to integrate your web application with Sage 50 Accounts then please get in touch to discuss your requirements.