The objects available within our connector are accessible from the "cdata.sage200" module. In order to use the module's objects directly, the module must first be imported as below:
import cdata.sage200 as mod
From there, the connect() method can be called from the connector object to establish a connection using an appropriate connection string, such as the below:
Important connection properties
Schema Determines which Sage 200 edition you are connecting to. Specify either StandardUK or ProfessionalUK.
SubscriptionKey provides access to the APIs on Sage 200 that are used to establish a connection. You will first need to log into the Sage 200 API website and subscribe to the API edition that matches your account. You can do so here: https://developer.columbus.sage.com/docs/services/api/uk
Afterwards, the subscription key may be found in your profile after logging into Sage 200.
PrerequisiteYou must ensure that your account is registered for Sage API access. You can easily do this by following this link: https://www.sage200onlineservices.com/register
Authenticating to Sage 200
Sage 200 uses the OAuth authentication standard. See OAuth 認証の使用 for an authentication guide.