Show Menu
TOPICS×

Create a Salesforce connector using the Flow Service API

Flow Service is used to collect and centralize customer data from various disparate sources within Adobe Experience Platform. The service provides a user interface and RESTful API from which all supported sources are connectable.
This tutorial uses the Flow Service API to walk you through the steps to connect Platform to a Salesforce account for collecting CRM data.
If you would prefer to use the user interface in Experience Platform, the Salesforce source connector UI tutorial provides step-by-step instructions for performing similar actions.

Getting started

This guide requires a working understanding of the following components of Adobe 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 Platform services.
  • Sandboxes : Experience Platform provides virtual sandboxes which partition a single 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 Platform to a Salesforce account using the Flow Service API.

Gather required credentials

In order for Flow Service to connect to Salesforce, you must provide values for the following connection properties:
Credential
Description
environmentUrl
The URL of the Salesforce source instance.
username
The username for the Salesforce user account.
password
The password for the Salesforce user account.
securityToken
The security token for the Salesforce user account.
For more information on getting started, visit this Salesforce document .

Reading sample API calls

This tutorial provides example API calls to demonstrate how to format your requests. These include paths, required headers, and properly formatted request payloads. Sample JSON returned in API responses is also provided. For information on the conventions used in documentation for sample API calls, see the section on how to read example API calls in the Experience Platform troubleshooting guide.

Gather values for required headers

In order to make calls to Platform APIs, you must first complete the authentication tutorial . Completing the authentication tutorial provides the values for each of the required headers in all Experience Platform API calls, as shown below:
  • Authorization: Bearer {ACCESS_TOKEN}
  • x-api-key: {API_KEY}
  • x-gw-ims-org-id: {IMS_ORG}
All resources in Experience Platform, including those belonging to the Flow Service, are isolated to specific virtual sandboxes. All requests to Platform APIs require a header that specifies the name of the sandbox the operation will take place in:
  • x-sandbox-name: {SANDBOX_NAME}
All requests that contain a payload (POST, PUT, PATCH) require an additional media type header:
  • Content-Type: application/json

Look up connection specifications

Before connecting Platform to a Salesforce account, you must verify that connection specifications exist for Salesforce. If connection specifications do not exist then a connection cannot be made.
Each available source has its own unique set of connection specifications for describing connector properties such as authentication requirements. You can look up connection specifications for Salesforce by performing a GET request and using query parameters.
API format
Sending a GET request without query parameters will return connection specifications for all available sources. You can include the query property=name=="salesforce" to obtain information specifically for Salesforce.
GET /connectionSpecs
GET /connectionSpecs?property=name=="salesforce"

Request
The following request retrieves the connection specifications for Salesforce.
curl -X GET \
    'https://platform.adobe.io/data/foundation/flowservice/connectionSpecs?property=name==%22salesforce%22' \
    -H 'Authorization: Bearer {ACCESS_TOKEN}' \
    -H 'x-api-key: {API_KEY}' \
    -H 'x-gw-ims-org-id: {IMS_ORG}' \
    -H 'x-sandbox-name: {SANDBOX_NAME}'

Response
A successful response returns the connection specifications for Salesforce, including its unique identifier ( id ). This ID is required in the next step to create a base connection.
{
    "items": [
        {
            "id": "cfc0fee1-7dc0-40ef-b73e-d8b134c436f5",
            "name": "salesforce",
            "providerId": "0ed90a81-07f4-4586-8190-b40eccef1c5a",
            "version": "1.0",
            "authSpec": [
                {
                    "name": "Basic Authentication",
                    "type": "Basic_Authentication",
                    "spec": {
                        "$schema": "http://json-schema.org/draft-07/schema#",
                        "type": "object",
                        "description": "defines auth params",
                        "properties": {
                            "environmentUrl": {
                                "type": "string",
                                "description": "URL of the source instance"
                            },
                            "username": {
                                "type": "string",
                                "description": "User name for the user account"
                            },
                            "password": {
                                "type": "string",
                                "description": "Password for the user account",
                                "format": "password"
                            },
                            "securityToken": {
                                "type": "string",
                                "description": "Security token for the user account",
                                "format": "password"
                            }
                        },
                        "required": [
                            "username",
                            "password",
                            "securityToken"
                        ]
                    }
                }
            ]
        }
    ]
}

Create a base connection

A base connection specifies a source and contains your credentials for that source. Only one base connection is required per Salesforce account as it can be used to create multiple source connectors to bring in different data.
Perform the following POST request to create a base connection.
API format
POST /connections

Request
curl -X POST \
    'http://platform.adobe.io/data/foundation/flowservice/connections' \
    -H 'Authorization: Bearer {ACCESS_TOKEN}' \
    -H 'x-api-key: {API_KEY}' \
    -H 'x-gw-ims-org-id: {IMS_ORG}' \
    -H 'x-sandbox-name: {SANDBOX_NAME}' \
    -H 'Content-Type: application/json' \
    -d '{
        "name": "Salesforce Base Connection",
        "description": "Base connection for Salesforce account",
        "auth": {
            "specName": "Basic Authentication",
            "params": {
                "username": "{USERNAME}",
                "password": "{PASSWORD}",
                "securityToken": "{SECURITY_TOKEN}"
            }
        },
        "connectionSpec": {
            "id": "cfc0fee1-7dc0-40ef-b73e-d8b134c436f5",
            "version": "1.0"
        }
    }'

Property
Description
auth.params.username
The username associated with your Salesforce account.
auth.params.password
The password associated with your Salesforce account.
auth.params.securityToken
The security token associated with your Salesforce account.
connectionSpec.id
The connection specification id of your Salesforce account retrieved in the previous step.
Response
A successful response contains the base connection's unique identifier ( id ). This ID is required to explore your data in the next tutorial.
{
    "id": "4cb0c374-d3bb-4557-b139-5712880adc55",
    "etag": "\"1700df7b-0000-0200-0000-5e3b424f0000\""
}

Next steps

By following this tutorial, you have created a base connection for your Salesforce account using APIs and a unique ID was obtained as part of the response body. You can use this base connection ID in the next tutorial as you learn how to explore CRM systems using the Flow Service API .