Create a source connection and dataflow for SugarCRM Accounts & Contacts using the Flow Service API

Last update: April 2, 2025

CREATED FOR:

  • Developer

The following tutorial walks you through the steps to create a SugarCRM Accounts & Contacts source connection and create a dataflow to bring SugarCRM accounts and contacts data to Adobe Experience Platform using the Flow Service API.

Getting started

This guide requires a working understanding of the following components of Experience Platform:

  • Sources: Experience Platform allows data to be ingested from various sources while providing you with the ability to structure, label, and enhance incoming data using Experience Platform services.
  • Sandboxes: Experience Platform provides virtual sandboxes which partition a single Experience Platform instance into separate virtual environments to help develop and evolve digital experience applications.

The following sections provide additional information that you will need to know in order to successfully connect to SugarCRM using the Flow Service API.

Gather required credentials

In order to connect SugarCRM Accounts & Contacts to Experience Platform, you must provide values for the following connection properties:

CredentialDescriptionExample
hostThe SugarCRM API endpoint the source connects to.developer.salesfusion.com
usernameYour SugarCRM developer account username.abc.def@example.com@sugarmarketdemo000.com
passwordYour SugarCRM developer account password.123456789

Connect SugarCRM Accounts & Contacts to Experience Platform using the Flow Service API

The following outlines the steps you need to make in order to authenticate your SugarCRM source, create a source connection, and create a dataflow to bring your accounts and contacts data to Experience Platform.

Create a base connection

A base connection retains information between your source and Experience Platform, including your source’s authentication credentials, the current state of the connection, and your unique base connection ID. The base connection ID allows you to explore and navigate files from within your source and identify the specific items that you want to ingest, including information regarding their data types and formats.

To create a base connection ID, make a POST request to the /connections endpoint while providing your SugarCRM Accounts & Contacts authentication credentials as part of the request body.

API format

POST /connections

Request

The following request creates a base connection for SugarCRM Accounts & Contacts:

curl -X POST \
  'https://platform.adobe.io/data/foundation/flowservice/connections' \
  -H 'Authorization: Bearer {ACCESS_TOKEN}' \
  -H 'x-api-key: {API_KEY}' \
  -H 'x-gw-ims-org-id: {ORG_ID}' \
  -H 'x-sandbox-name: {SANDBOX_NAME}' \
  -H 'Content-Type: application/json' \
  -d '{
      "name": "SugarCRM Accounts & Contacts base connection",
      "description": "Create a live inbound connection to your SugarCRM Accounts & Contacts instance, to ingest both historic and scheduled data into Experience Platform",
      "connectionSpec": {
          "id": "59a4b493-a615-40f9-bd38-f823d0909a2b",
          "version": "1.0"
      },
      "auth": {
          "specName": "OAuth2 Refresh Code",
          "params": {
              "host": "developer.salesfusion.com",
              "username": "{SUGARCRM_DEVELOPER_ACCOUNT_USERNAME}",
              "password": "{SUGARCRM_DEVELOPER_ACCOUNT_PASSWORD}"
          }
      }
  }'
PropertyDescription
nameThe name of your base connection. Ensure that the name of your base connection is descriptive as you can use this to look up information on your base connection.
descriptionAn optional value that you can include to provide more information on your base connection.
connectionSpec.idThe connection specification ID of your source. This ID can be retrieved after your source is registered and approved through the Flow Service API.
auth.specNameThe authentication type that you are using to authenticate your source to Experience Platform.
auth.params.hostThe SugarCRM API host: developer.salesfusion.com
auth.params.usernameYour SugarCRM developer account username.
auth.params.passwordYour SugarCRM developer account password.

Response

A successful response returns the newly created base connection, including its unique connection identifier (id). This ID is required to explore your source’s file structure and contents in the next step.

{
     "id": "f5421911-6f6c-41c7-aafa-5d9d2ce51535",
     "etag": "\"4d08164f-0000-0200-0000-6368b7bf0000\""
}