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.
Does the HyperSage API Support Multi-currency?
Good news! The answer is yes, our API has recently been extended to handle live transactions in whatever currencies and exchange rates you have configured in your Sage company currency settings. This feature was added at the request of one of our existing customers and has now been working perfectly in their live environment since the beginning of June 2019.
What happens when Sage 50 Cloud version 26 comes out?
The Hyperext Team are already busy developing and testing our API to work seamlessly with Sage 50 Accounts v26 as it is due to be released on general sale in early September 2019. Each of our existing customers will be lead through a managed upgrade process to ensure minimum disruption to their business as and when they are ready to upgrade. This process is covered under our ongoing support arrangements.
Hyperext is a Sage Authorised Developer Partner
This means that you can rest assured that the support we provide to users of our API is backed up by developer support direct from Sage.
The HyperSage API has endpoints for Customers, Suppliers, Products, 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.