SAP Open Connectors

SugarCRM Events

SAP Open Connectors currently supports events via polling or webhooks depending on the endpoint.

  • Polling is a mechanism where SAP Open Connectors executes the configured query every n minutes and captures the changed information.
  • Webhooks are when the provider lets SAP Open Connectors know what information has changed. Note that additional endpoint setup may be required prior to creating your connector instance.
Note: SAP Open Connectors normalizes only the objectId, objectType, and eventType event data. Event data also contains raw data, which the provider returns. The raw data varies based on the endpoint.

If you would like to see more information on our Events framework, please see Events Overview.

In order to enable polling, add these extra configurations to your instance JSON:

"event.notification.enabled": "true",
"event.notification.callback.url": "<INSERT_YOUR_APPS_CALLBACK_URL>",
"event.poller.configuration": "<SEE_BELOW>"

NOTE: The objects in the event.poller.configuration are the default configurations we support. Feel free to remove any objects that do not fit your needs.

instance JSON with polling events enabled:

{
  "element": {
    "key": "sugarcrmv2"
  },
  "configuration": {
    "oauth.api.key": "<INSERT_SUGARCRM_CONSUMER_KEY>",
    "oauth.api.secret": "<INSERT_SUGARCRM_CONSUMER_SECRET>",
    "oauth.callback.url": "https://console.cloud-elements.com/elements/jsp/home.jsp",
    "site.url": "<INSERT_SUGARCRM_UNIQUE_URL>",
    "username": "<INSERT_SUGARCRM_USERNAME>",
    "password": "<INSERT_SUGARCRM_PASSWORD>",
    "event.notification.enabled": "true",
    "event.notification.callback.url": "<INSERT_YOUR_APPS_CALLBACK_URL>",
    "event.poller.configuration": {
      "users": {
        "url": "/hubs/crm/users?where=date_modified>'${date:yyyy-MM-dd'T'HH:mm:ssXXX}'",
        "idField": "id",
        "datesConfiguration": {
          "updatedDateField": "date_modified",
          "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX",
          "createdDateField": "date_entered",
          "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX"
        }
      },
      "contacts": {
        "url": "/hubs/crm/contacts?where=date_modified>'${date:yyyy-MM-dd'T'HH:mm:ssXXX}'",
        "idField": "id",
        "datesConfiguration": {
          "updatedDateField": "date_modified",
          "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX",
          "createdDateField": "date_entered",
          "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX"
        }
      },
      "leads": {
        "url": "/hubs/crm/leads?where=date_modified>'${date:yyyy-MM-dd'T'HH:mm:ssXXX}'",
        "idField": "id",
        "datesConfiguration": {
          "updatedDateField": "date_modified",
          "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX",
          "createdDateField": "date_entered",
          "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX"
        }
      },
      "opportunities": {
        "url": "/hubs/crm/opportunities?where=date_modified>'${date:yyyy-MM-dd'T'HH:mm:ssXXX}'",
        "idField": "id",
        "datesConfiguration": {
          "updatedDateField": "date_modified",
          "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX",
          "createdDateField": "date_entered",
          "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX"
        }
      },
      "tasks": {
        "url": "/hubs/crm/tasks?where=date_modified>'${date:yyyy-MM-dd'T'HH:mm:ssXXX}'",
        "idField": "id",
        "datesConfiguration": {
          "updatedDateField": "date_modified",
          "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX",
          "createdDateField": "date_entered",
          "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX"
        }
      },
      "campaigns": {
        "url": "/hubs/crm/campaigns?where=date_modified>'${date:yyyy-MM-dd'T'HH:mm:ssXXX}'",
        "idField": "id",
        "datesConfiguration": {
          "updatedDateField": "date_modified",
          "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX",
          "createdDateField": "date_entered",
          "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX"
        }
      },
      "incidents": {
        "url": "/hubs/crm/incidents?where=date_modified>'${date:yyyy-MM-dd'T'HH:mm:ssXXX}'",
        "idField": "id",
        "datesConfiguration": {
          "updatedDateField": "date_modified",
          "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX",
          "createdDateField": "date_entered",
          "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX"
        }
      },
      "activities-emails": {
        "url": "/hubs/crm/activities-emails?where=date_modified>'${date:yyyy-MM-dd'T'HH:mm:ssXXX}'",
        "idField": "id",
        "datesConfiguration": {
          "updatedDateField": "date_modified",
          "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX",
          "createdDateField": "date_entered",
          "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX"
        }
      },
      "activities-calls": {
        "url": "/hubs/crm/activities-calls?where=date_modified>'${date:yyyy-MM-dd'T'HH:mm:ssXXX}'",
        "idField": "id",
        "datesConfiguration": {
          "updatedDateField": "date_modified",
          "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX",
          "createdDateField": "date_entered",
          "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX"
        }
      },
      "activities-events": {
        "url": "/hubs/crm/activities-events?where=date_modified>'${date:yyyy-MM-dd'T'HH:mm:ssXXX}'",
        "idField": "id",
        "datesConfiguration": {
          "updatedDateField": "date_modified",
          "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX",
          "createdDateField": "date_entered",
          "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX"
        }
      },
      "accounts": {
        "url": "/hubs/crm/accounts?where=date_modified>'${date:yyyy-MM-dd'T'HH:mm:ssXXX}'",
        "idField": "id",
        "datesConfiguration": {
          "updatedDateField": "date_modified",
          "updatedDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX",
          "createdDateField": "date_entered",
          "createdDateFormat": "yyyy-MM-dd'T'HH:mm:ssXXX"
        }
      }
    }
  },
  "tags": [
    "<INSERT_TAGS>"
  ],
  "name": "<INSERT_INSTANCE_NAME>"
}