Summary
Resolution
When using the 200 API with Sage ID authentication and an externally facing web server, remove these settings before following the article steps.
You'll need to open Sage 200 System Administration, select API, Select Edit, deselect Enable API setting. This removes the current API access.
TLS / Sage ID changes - setup using Microsoft Entra ID (Azure Active Directory) Tunnelling is possible for Sage 200 Professional Summer 2018 RM, 2020 R1 and above.
To set up the Native API Tunnel with the same Microsoft 365 tenant used in a test environment, you'll need to disable the Native API. Go here for further steps. Come back to this article when you need to reinstall the App Proxy Installer.
Prerequisites for using the Sage 200 Native API
Before setting up the Sage 200 Native API, you must first ensure you have a supported Microsoft 365 licence.
To check you have a supported Microsoft 365 licence, see Sage 200 – Which version of Microsoft 365 is compatible for use with the Sage 200 API and how to check before onboarding.
If you've purchased a Microsoft 365 licence from Sage, you'll have received a "getting started" email. To onboard this licence, follow the steps in the email.
Add an existing Microsoft 365 licence to your Sage registration
- To confirm you have a supported licence, see Sage 200 – Which version of Microsoft 365 is compatible for use with the Sage 200 API and how to check before onboarding.
- Email Business Partner Sales via [email protected] and ask for an existing Microsoft 365 registration to be applied to your customers account. Check the Sage 200 API registration is on your licence
You'll be taken to the Sage Business Centre once you've accepted the Microsoft agreement and the Sage Business Centre application permissions. This will confirm that the on boarding has been successful and you can now continue to install the Sage 200 Native API application.
Only users who have Global Administrator rights can perform some activities involving Microsoft Entra ID (formerly Azure Active Directory).
For further details, see this Microsoft article Who has permission to add applications to my Microsoft Entra instance?.
Connect Sage 200 to your Microsoft 365 account
When you've activated your Microsoft 365 license and registered it with Sage, you'll now need to install the Microsoft Azure Active Directory Proxy Connector on your Sage 200 server.
This sets up a connection to your Sage 200 server using Microsoft Entra ID (Azure Active Directory) authentication, to allow you to "tunnel" in and out of your network securely.
The Microsoft Azure Active Directory Proxy Connector requires Microsoft Windows 8.1, Windows Server 2012 R2, or later versions of Windows.
- For 202R R1 download the Entra Private Network Connector Installer.
- For 2025 R2 download the Entra Private Network Connector Installer.
- For 2025 R1 download the Entra Private Network Connector Installer.
- For 2024 R2 download the Entra Private Network Connector Installer.
- For 2024 R1 download the Azure Application Proxy Installer.
- For 2023 R2 or below download the Azure Application Proxy Installer.
- Extract the contents of the downloaded zip file.
- Run the AppProxyInstaller.exe.
-
Select Install and Configure.

-
This starts the Microsoft Entra Private Network Connector installer.
Select Install.

- Sign into your Microsoft Entra account.
- Select Close when the Microsoft Entra Private Network Connector setup is complete.
- Sign into your Microsoft Azure account again.
- The installer is populated with information to create your enterprise applications within Microsoft Entra ID (Azure Active Directory).
Set up the Native API
- Go to entra.microsoft.com/, sign in using the email address used to install the Azure Application Proxy Installer.
- Select Identity > Applications > Enterprise applications.
- Select New application.
- Select Add an on-premises application.
- Enter the details for the on-premises application.
- Name: Copy and paste the Native Name from the Microsoft Azure Active Directory Proxy Connector installer.
- Internal Url: Copy and paste the Native Internal Url from the Microsoft Azure Active Directory Proxy Connector installer.
- Set Pre Authentication to Passthrough.
- Select Create to create the application.
After creating the on-premises application, you'll see a notification.
In this instance your Business Partner will have to contact Technical Support to enable your API registration with the following information:
- The site name.
- The site URL.
- The email address used during the setup.
If you have issues finding any of these, contact Sage 200 technical support first. (The site name and site url are found in Sage System Administration on the API tab.)
Once enabled, you'll receive an email confirming this, and you can then proceed to the next step.
To set up the connection with a different administrator account, use Reconfigure to change the Microsoft 365 account the application is associated with.
To give a user access to the Sage 200 API, they'll require a valid Sage ID. The currently logged in user will also have Azure AD ticked and the Azure ID entered automatically in the API tab in System Administration.
- Open System Administration.
- Select the Users list.
- Right-click the user and select Properties.
- Select the API tab.
- Enable Sage ID, enter the user's Sage ID email address (used for authentication when using the API).
- Confirm the Sage ID created in step 4 can log in successfully to the my.sage.co.uk web page - accept the MySage terms and conditions before proceeding.
Test the API has been successfully configured
Once you’ve set the API up and installed the Native API proxy installer, you can test to see whether the API successfully returns any information.
We have an API Test tool for you to use to confirm whether you can successfully return sites. To download and use this tool, see Sage 200 - API Test Tool.
Now that the API is enabled successfully, you may wish to look at further documentation:
- API endpoint documentation: Sage API.
- How to make an API request using Postman: Using Postman with the Sage 200 RESTful API.
- How to set up Power BI to connect to your data: Set up Power BI.
- How to set up Power Automate: Set up Microsoft Power Automate with Sage 200.
- Common Queries and Frequently Asked Questions: Sage 200 API - Common Queries and Frequently Asked Questions.
Upgrade your licence
Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.
