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/