Sage One
Sage One for Africa, Australia & Malaysia
Provides integration into Sage One Accounting via it's RESTful API (documented at https://accounting.sageone.co.za/Marketing/DeveloperProgram.aspx).
This Connector provides integration into Sage One for Africa, Australia and Malaysia. For other regions, check the Sage One Global Connector. If you do not see your region listed, please contact us.
Revision History
1.0.0.7 - Updated transaction timeout to pull through on the value set in the connection property.
1.0.0.8 - Resolved 500 (Internal Server Error) message caused by XmlDeclaration on RequestXml property.
2.0.0.2 - Implemented support for multiple transactions per request.
2.2.0.3 - Implemented support for Download actions, files are returned base64 encoded in the response.
2.2.0.5 - Refactored samples and configuration.
Properties
Connection
Type: Connection Input
The connection profile for your Sage One account.
APIVersion
Type: Dropdown
Your Sage One API version.
Username
Type: String
Your Sage One account username.
Password
Type: Password
Your Sage One account password.
CompanyID
Type: String
Your Sage One Company ID.
Action
Type: List Input
The Action Property
Module
Type: List Input
The Module Property
ParameterXml
Type: Xml Input
The ParameterXml Property
RequestXml
Type: Xml Input
The RequestXml Property
ResponseXml
Type: Xml Output
The ResponseXml Property
Remarks
Setting up the Connection
A users' username and password should be placed into the respective fields in the Sage One Connection.
Most integrations apply to a specific Sage One company and will require that the Company ID property is populated with a valid Company ID.
To obtain the Company ID via the API, use the GET Company (Company/Get)
Node Sample to obtain a list of all companies. The ResponseXml property will contain a list of all companies including the associated Company ID which can then be placed in the Connection.
OData Queries
Some calls support OData Queries. These can be added in the ParameterXml.
<Root><key Name="$filter" Value="Name eq 'Flowgear'" /><key Name="$top" Value="5" /></Root>
Rate Limiting
The Sage One API imposes a limit of 100 requests per minute. If this limit is exceeded, the Sage One connector will return this error:
Operation is not valid due to the current state of the object
See https://www.sageone.co.za/request-limit-faq/ for further information.
Example
See Sample Workflow for an example.
See Also
Sage One API - https://accounting.sageone.co.za/api/1.1.1/