Home Nodes Sage 300 People

Sage 300 People

A Flowgear node that connects directly to your Sage 300 People environment. It handles authentication, builds URLs from easy-to-use samples, and sends requests. You get ready-to-run operations (Employees, JobTitles, Document/Content, and more) that follow Sage’s standard header → line → validate → process pattern.

Revision History

1.0.0.0 Initial release

Properties

Connection

Type: Connection Input
The Connection Property, which defines your Sage 300 People credentials for authentication.

HostName
Type: String Input
The DNS name of your Sage 300 People server (no scheme). The API is self-hosted and must be exposed over SSL.

ApiPort
Type: String Input
HTTPS port exposed by your Sage 300 People API (for many environments, this is 9443).

ApiKey
Type: Secret Input
The API key created in Sage 300 People. The key maps to a Sage 300 People user and that user’s security groups determine what the API can do.

AccessToken
Type: Secret Output
Set automatically by the node after a token request. Used as a bearer token when available.

CookieHeader
Type: Secret Output
Set automatically by the node after a token request. Contains all session cookies (e.g. PeopleEssUser, XSRF-TOKEN) concatenated for reuse in all subsequent calls, so that requests remain authenticated.

ReturnFailureResponses
Type: Secret Input
A checkbox to give you control over the handling of error messages. Set it if you want exceptions to not be thrown, and the Response to be set to the failed raw response.

OperationId

Type: String Input
Selected operation identifier from the built-in node samples. Set this automatically by choosing a sample.

Description

Type: String Static
Summary of the selected operation, populated when you select a sample.

Request

Type: JSON Input
Raw JSON request body for the operation. For multipart uploads (Document/Content line), this is the model text.

Response

Type: JSON Output
Raw JSON returned by the API after invoke.

Using the Node

1. Retrieve your Sage 300 People API Key

Your node authenticates using an API key that is linked to a Sage 300 People user. Ask your Sage administrator to:

  1. Create an API key in Sage 300 People and link it to a user account with the right security groups.
  2. Enable the "Authenticate Using Key Only" setting.
  3. Confirm the API is exposed over HTTPS and reachable from Flowgear or your registered DropPoint (valid SSL certificate required).

2. Create the Connection

  1. In the Flowgear Console, click Connections.
  2. Add a new Connection of type Sage 300 People.
  3. Enter your HostName, ApiPort, and ApiKey.
  4. Save your Connection.

3. Test your Connection

  1. Click Test.
  2. Flowgear will attempt a test API call to a generic Sage 300 People endpoint to ensure your credentials are valid.
  • This is also where the AccessToken and CookieHeader is fetched.

If the test is successful (✓), your credentials are valid.
If it fails (✗), the test will return an error message, and you may need to re-authorise the Connection. If this problem persists, please contact support for assistance.

Remarks

A typical Sage 300 People workflow, for most create/update tasks, follow this sequence:

  • Get a token: This is handled internally by the node for you.
  • Create a header.
  • Add line data to that header.
  • Validate the header/lines.
  • Process the header.

The "Content Create - Line" Sample

This is a unique sample, specifically for adding lines (i.e. files) to a Document/Content header, in that it uses formdata for its Request body. This is multipart:

  • Enter your model as JSON into the Request.
  • Pass in your file data (output from a File Read) into the file0 key.

See Also