Sage 200 Events

Cloud Elements supports events via polling or webhooks depending on the API provider. For more information about our Events framework, see Events Overview.

Supported Events and Resources

Cloud Elements supports polling events for Sage 200. After receiving an event, Cloud Elements standardizes the payload and sends an event to the configured callback URL of your authenticated element instance.

You can set up polling for the events resource. You can also copy the events configuration to poll other resources. See Configure Polling Through API for more information.

Note: Unless configured for a specific time zone, polling occurs in UTC.

Configure Polling Through the UI

To configure polling through the UI, follow the same steps to authenticate an element instance, and then turn on events. Select the resources to poll, and then click Create Instance. For more information, see Authenticate an Element Instance with Events (UI) or the element-specific authentication topic.

Configure Polling Through API

Use the /instances endpoint to authenticate with Sage 200 and create an element instance with polling enabled.

Note: The endpoint returns an element instance token and id upon successful completion. Retain the token and id for all subsequent requests involving this element instance.

To authenticate an element instance with polling:

  1. Construct a JSON body as shown below (see Parameters):

    {
      "element": {
        "key": "sage200"
      },
      "configuration": {
        "oauth.api.secret": "",
        "oauth.api.key": "",
        "subscription.key": "",
        "signing.key": "",
        "company.name": "",
        "event.notification.enabled": true,
        "event.notification.callback.url": "https://console.cloud-elements.com",
        "event.notification.basic.username": "CompanyName123",
        "event.notification.basic.password": "P@$$word",
        "event.poller.refresh_interval": "15",
        "event.poller.configuration": {
          "customers": {
            "url": "/hubs/finance/customers?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
            "idField": "id",
            "datesConfiguration": {
              "updatedDateField": "updated_at",
              "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "updatedDateTimezone": "GMT",
              "createdDateField": "created_at",
              "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "createdDateTimezone": "GMT"
            }
          },
          "payments": {
            "url": "/hubs/finance/payments?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
            "idField": "id",
            "datesConfiguration": {
              "updatedDateField": "updated_at",
              "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "updatedDateTimezone": "GMT",
              "createdDateField": "created_at",
              "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "createdDateTimezone": "GMT"
            }
          },
          "invoices": {
            "url": "/hubs/finance/invoices?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
            "idField": "id",
            "datesConfiguration": {
              "updatedDateField": "updated_at",
              "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "updatedDateTimezone": "GMT",
              "createdDateField": "created_at",
              "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "createdDateTimezone": "GMT"
            }
          },
          "products": {
            "url": "/hubs/finance/products?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
            "idField": "id",
            "datesConfiguration": {
              "updatedDateField": "updated_at",
              "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "updatedDateTimezone": "GMT",
              "createdDateField": "created_at",
              "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "createdDateTimezone": "GMT"
            }
          },
          "transactions": {
            "url": "/hubs/finance/customers?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
            "idField": "id",
            "datesConfiguration": {
              "updatedDateField": "updated_at",
              "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "updatedDateTimezone": "GMT",
              "createdDateField": "created_at",
              "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "createdDateTimezone": "GMT"
            }
          },
          "warehouse-holdings": {
            "url": "/hubs/finance/warehouse-holdings?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
            "idField": "id",
            "datesConfiguration": {
              "updatedDateField": "updated_at",
              "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "updatedDateTimezone": "GMT",
              "createdDateField": "created_at",
              "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "createdDateTimezone": "GMT"
            }
          },
          "warehouses": {
            "url": "/hubs/finance/warehouses?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
            "idField": "id",
            "datesConfiguration": {
              "updatedDateField": "updated_at",
              "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "updatedDateTimezone": "GMT",
              "createdDateField": "created_at",
              "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'",
              "createdDateTimezone": "GMT"
            }
          }
        }
      },
      "tags": [
        ""
      ],
      "name": ""
    }
  2. Call the following, including the JSON body you constructed in the previous step:

    POST /instances
    
    Note: Make sure that you include the User and Organization keys in the header. For more information, see Authorization Headers, Organization Secret, and User Secret.
  3. Locate the token and id in the response and save them for all future requests using the element instance.

Example JSON with Polling

instance JSON with polling events enabled:

{
  "element":{
    "key":"sage200"
  },
  "configuration": {
    "oauth.api.secret": "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
    "oauth.api.key": "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
    "subscription.key": "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
    "signing.key": "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",
    "company.name": "Cloud-Elements Demodata",
    "event.notification.enabled": true,
    "event.notification.callback.url": "https://console.cloud-elements.com",
    "event.notification.basic.username": "CompanyName123",
    "event.notification.basic.password": "P@$$w0rd",
    "event.poller.refresh_interval": "15",
    "event.poller.configuration":{
      "customers":{
        "url":"/hubs/finance/customers?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
        "idField":"id",
        "datesConfiguration":{
          "updatedDateField":"updated_at",
          "updatedDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "updatedDateTimezone":"GMT",
          "createdDateField":"created_at",
          "createdDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "createdDateTimezone":"GMT"
            }
        },

      "payments":{
        "url":"/hubs/finance/payments?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
        "idField":"id",
        "datesConfiguration":{
          "updatedDateField":"updated_at",
          "updatedDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "updatedDateTimezone":"GMT",
          "createdDateField":"created_at",
          "createdDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "createdDateTimezone":"GMT"
            }
        },

        "invoices":{
        "url":"/hubs/finance/invoices?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
        "idField":"id",
        "datesConfiguration":{
          "updatedDateField":"updated_at",
          "updatedDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "updatedDateTimezone":"GMT",
          "createdDateField":"created_at",
          "createdDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "createdDateTimezone":"GMT"
            }
        },

        "products":{
        "url":"/hubs/finance/products?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
        "idField":"id",
        "datesConfiguration":{
          "updatedDateField":"updated_at",
          "updatedDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "updatedDateTimezone":"GMT",
          "createdDateField":"created_at",
          "createdDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "createdDateTimezone":"GMT"
            }
        },

        "transactions":{
        "url":"/hubs/finance/customers?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
        "idField":"id",
        "datesConfiguration":{
          "updatedDateField":"updated_at",
          "updatedDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "updatedDateTimezone":"GMT",
          "createdDateField":"created_at",
          "createdDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "createdDateTimezone":"GMT"
            }
        },

        "warehouse-holdings":{
        "url":"/hubs/finance/warehouse-holdings?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
        "idField":"id",
        "datesConfiguration":{
          "updatedDateField":"updated_at",
          "updatedDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "updatedDateTimezone":"GMT",
          "createdDateField":"created_at",
          "createdDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "createdDateTimezone":"GMT"
            }
        },

        "warehouses":{
        "url":"/hubs/finance/warehouses?where=date_time_updated>='${date:yyyy-MM-dd'T'HH:mm:ss}'",
        "idField":"id",
        "datesConfiguration":{
          "updatedDateField":"updated_at",
          "updatedDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "updatedDateTimezone":"GMT",
          "createdDateField":"created_at",
          "createdDateFormat":"yyyy-MM-dd'T'HH:mm:ss'Z'",
          "createdDateTimezone":"GMT"
            }
        }
      }
      },
  "tags":[
    "API_Polling_Sage200"
  ],
  "name":"myCoolInstance"
}

Parameters

API parameters not shown in Cloud Elements are in code formatting.

ParameterDescriptionData Type
'key'The element key.
sage200
string
Name
name
The name for the element instance created during authentication.string
Events Enabled
event.notification.enabled
Optional. Identifies that events are enabled for the element instance.
Default: false.
boolean
Event Notification Callback URL
event.notification.callback.url
The URL where you want Cloud Elements to send the events.string
Event poller refresh interval (mins)
event.poller.refresh_interval
A number in minutes to identify how often the poller should check for changes.number
Configure Polling
event.poller.configuration
Optional*. Configuration parameters for polling.JSON object
<resource name> (e.g., accounts, contacts, or lists)The polling configuration of the resource.JSON object
<resource name>URL
url
The url to query for updates to the resource.String
<resource name>ID Field
idField
The field in the resource that is used to uniquely identify it.String
<resource name>Advanced Filtering
datesConfiguration
Configuration parameters for dates in pollingJSON Object
<resource name>Updated Date Field
updatedDateField
The field that identifies an updated object.String
<resource name>Updated Date Format
updatedDateFormat
The date format of the field that identifies an updated object.String
<resource name>Created Date Field
createdDateField
The field that identifies a created object.String
<resource name>Created Date Format
createdDateFormat
The date format of the field that identifies a created object.String
tagsOptional. User-defined tags to further identify the instance.string