Salesforce modules

In an Adobe Workfront Fusion scenario, you can automate workflows that use Salesforce, as well as connect it to to multiple third-party applications and services.

For a video introduction to the Salesforce connector, see:

For instructions on creating a scenario, see the articles under Create scenarios: article index.

For information about modules, see the articles under Modules: article index.

NOTE
  • Not all editions of Salesforce have API access. For details, see the information about Salesforce editions with API access on the Salesforce Community site.
  • For information on specific errors returned from the Salesforce API, see the Salesforce API docs. You can also check the status of the Salesforce API for any possible service outages.

Access requirements

Expand to view access requirements for the functionality in this article.

You must have the following access to use the functionality in this article:

table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header
Adobe Workfront package Any
Adobe Workfront license

New: Standard

Or

Current: Work or higher

Adobe Workfront Fusion license**

Current: No Workfront Fusion license requirement.

Or

Legacy: Workfront Fusion for Work Automation and Integration

Product

New:

  • Select or Prime Workfront package: Your organization must purchase Adobe Workfront Fusion.
  • Ultimate Workfront package: Workfront Fusion is included.

Or

Current: Your organization must purchase Adobe Workfront Fusion.

For more detail about the information in this table, see Access requirements in documentation.

For information on Adobe Workfront Fusion licenses, see Adobe Workfront Fusion licenses.

Prerequisites

To use Salesforce modules, you must have a Salesforce account.

Salesforce API information

The Salesforce connector uses the following:

Base URL
{{connection.instanceUrl}}
API version
v62.0
API tag
v1.15.14

About searching for Salesforce objects

When searching for objects, you can either enter individual search words or create a more complex query using wild cards and operators:

  • Use the asterisk wild card (*) as a substitute for zero or more characters. For example, a search for Ca* finds items that start with Ca
  • Use a question mark wild card (?) as a substitute for a single character. For example, a search for Jo?n finds items with the term John or Joan but not Jon
  • Use the quotation marks operator (" ") to find an exact phrase match. For example: “Monday meeting”

For more information about search possibilities, see the Salesforce developer documentation about SOQL and SOSL.

Create a connection to Salesforce

To create a connection for your Salesforce modules:

  1. In any Salesforce module, click Add next to the Connection box.

  2. Fill in the following fields:

    table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 layout-auto html-authored no-header
    Connection name Enter a name for the new connection.
    Environment Select whether are connecting to a production or non-production environment.
    Type Select whether you are connecting to a service account or a personal account.
    Client ID Enter your Salesforce Client ID.
    Client Secret Enter your Salesforce Client secret.
    Sandbox Enable this option if this is a Sandbox environment.
    API Version Enter the version of the Salesforce API that you want to use. The default version is 62.0.
  3. Click Continue to save the connection and return to the module.

Salesforce modules and their fields

Triggers

Watch a field

This trigger module starts a scenario when a field is updated in Salesforce.

Connection
For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions.
Record Type
Select the type of record that contains the field you want the module to watch. You must choose a record type that has Field History turned on in Salesforce setup. For more information, see Field History Tracking in the Salesforce documentation.
Field
Select the fields that you want the module to watch for changes.
Limit
Enter or map the maximum number of fields you want the module to return during each scenario execution cycle.

Watch for Records

This trigger module executes a scenario when a record in an object is created or updated. The module returns all standard fields associated with the record or records, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.

When you are configuring this module, the following fields display.

Connection
For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions.
Type
Select the type of Salesforce record that you want the module to watch.
Record Fields
Select the fields that you want the module to watch. Available fields depend on the type of record.
Maximal count of records
Enter or map the maximum number of records you want the module to return during each scenario execution cycle.
Watch
Determine whether you want the scenario to watch only new records of the type you selected, or new records of the type you selected and all other changes to records of that type.

Watch Outbound Messages

This trigger module executes a scenario when someone sends a message. The module returns all standard fields associated with the record or records, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.

This module requires some extra setup:

  1. Go to the Salesforce setup page.

    To access the setup page, locate and click the button labeled “Setup” in the upper-right hand corner of the Salesforce account. From the Salesforce setup page, locate the “Quick Find / Search” bar on the left hand side. Search for “Workflow Rules.”

  2. Click Workflow Rules.

  3. On the the Workflow Rules page that appears, click New Rule and select the object type the rule will apply to (such as “Opportunity” if you are monitoring updates to Opportunity records).

  4. Click Next.

  5. Set a rule name, evaluation criteria, and rule criteria, then click Save and Next.

  6. Click Done.

  7. From the newly created Workflow rule, click Edit

  8. From the Add Workflow Action drop-down list, select New Outbound Message.

  9. Specify name, description, Endpoint URL, and fields you want to include in the new outbound message, then click Save.

    The Endpoint URL field contains the URL provided on the Salesforce Outbound Message in Workfront Fusion.

  10. Configure a scenario beginning with the Outbound Message event.

  11. Click the </> icon in the bottom right and copy the provided URL.

  12. Return to the Workflow Rules page, locate the newly created rule, then click Activate.

When you are configuring this module, the following fields display.

Webhook

Select the webhook that you want to use to watch outgoing messages. To add a webhook, click Add and enter the webhook's name and connection.

For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions

Record Type
Select the type of Salesforce record that you want the module to watch for outgoing messages.
Fields
Select the fields that you want the module to watch for outgoing messages. Available fields depend on the type of record.

Actions

Create a Record

This action module creates a new record in an object.

The module allows you to select which of the object’s fields are available in the module. This reduces the number of fields you must scroll through when setting up the module.

The module returns the ID of the record and any associated fields, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.

When you are configuring this module, the following fields display.

Connection
For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions.
Record Type
Select the type of Salesforce record that you want the module to create. Fields become available based on the type of record selected in the Record Type field. These fields are based on the Salesforce API.
Select fields to map

Select the fields that you want the module to configure when creating the new record. Required fields are at the top of the list.

The fields you select open below this field. You can now enter values into these fields.

Custom API Call

This action module lets you make a custom authenticated call to the Salesforce API. This way, you can create a data flow automation that can’t be accomplished by the other Salesforce modules.

The module returns the following:

  • Status Code (number): This indicates the success or failure of your HTTP request. These are standard codes that you can look up on the internet.

  • Headers (object): A more detailed context for the response/status code that doesn’t relate to the output body. Not all headers that appear in a response header are response headers, so some might not be useful to you.

    The response headers depend on the HTTP request you chose when configuring the module.

  • Body (object): Depending on the HTTP request you chose when configuring the module, you may receive some data back. That data, such as the data from a GET request, is contained in this object.

When you are configuring this module, the following fields display.

Select the HTTP request method you need to configure the API call. For more information, see HTTP request methods.

Connection
For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions.
URL

Enter a path relative to <Instance URL>/services/data/v46.0/.

For the list of available endpoints, refer to the Salesforce REST API Developer Guide.

Method
Headers
Add the headers of the request in the form of a standard JSON object. For example, {"Content-type":"application/json"}. Workfront Fusion adds the authorization headers for you.
Query String
Add the query for the API call in the form of a standard JSON object. For example: {"name":"something-urgent"}
Body

Add the body content for the API call in the form of a standard JSON object.

Note:

When using conditional statements such as if in your JSON, put the quotation marks outside of the conditional statement.

Delete a Record

This action module deletes an existing record in an object.

You specify the ID of the record.

The module returns the ID of the record and any associated fields, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.

When you are configuring this module, the following fields display.

Connection
For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions.
Record Type
Select the type of Salesforce record that you want the module to delete.
ID

Enter or map the unique Salesforce ID of the record that you want the module to delete.

To get the ID, open the Salesforce object in your browser and copy the text at the end of the URL after the last forward slash (/). For example: https://eu5.salesforce.com/<object ID>

Download Attachment/Document

This action module downloads a document or attachment from a record.

You specify the ID of the record and the type of download you want.

The module returns the ID of the attachment or document and any associated fields, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.

When you are configuring this module, the following fields display.

Connection
For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions.
Type of Download

Specify the type of file that you want to download from Salesforce.

  • Attachment
  • Document
  • ContentDocument (This is a document that has been uploaded to a library in Saleforce CRM Content or Salesforce Files.)

ID /

Attachment ID /

ContentDocument ID

Enter or map the unique Salesforce ID of the record that you want the module to download.

To get the ID, open the Salesforce object in your browser and copy the text at the end of the URL after the last forward slash (/). For example: https://eu5.salesforce.com/<object ID>

Read a Record

This action module reads data from a single object in Salesforce.

You specify the ID of the record.

The module returns the ID of the record and any associated fields, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.

When you are configuring this module, the following fields display.

Connection
For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions.
Record Type
Select the type of Salesforce record that you want the module to [action].read.
Record Fields
Select the fields that you want the module to read. You must select at least one field.
ID

Enter or map the unique Salesforce ID of the record that you want the module to read.

To get the ID, open the Salesforce object in your browser and copy the text at the end of the URL after the last forward slash (/). For example: https://eu5.salesforce.com/<object ID>

INFO
Example: The following API call returns the list of all users in your Salesforce account:
  • URL: query

  • Method: GET

  • Query String:

  • Key: q

  • Value: SELECT Id, Name, CreatedDate, LastModifiedDate FROM User LIMIT 10

Matches of the search can be found in the module’s Output under Bundle > Body > records.
In our example, 6 users were returned:
Matches for the search

Update a Record

This action module edits a record in an object.

The module allows you to select which of the object’s fields are available in the module. This reduces the number of fields you must scroll through when setting up the module.

The module returns the ID of the record and any associated fields, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.

When you are configuring this module, the following fields display.

Connection
For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions.
ID
Enter or map the ID of the record that you want to update.
Record Type
Select the type of Salesforce record that you want the module to update. Fields become available based on the type of record selected in the Record Type field. These fields are based on the Salesforce API.
Select fields to map

Select the fields that you want the module to configure when creating the new record. Required fields are at the top of the list.

The fields you select open below this field. You can now enter values into these fields.

Upload Attachment/Document

This action module uploads a file and attaches it to a record you specify, or uploads a document.

The module returns the ID of the attachment or document and any associated fields, along with any custom fields and values that the connection accesses. You can map this information in subsequent modules in the scenario.

When you are configuring this module, the following fields display.

Connection
For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions.
Type of Upload
Select whether you want the module to upload an attachment or a document.
ID
Enter or map the ID of the object you want to upload an attachment to.
Folder
Select the folder containing the file you want the module to upload.
Source File
Select a source file from a previous module, or map the source file's name and data.

Upload File

This action module uploads a single file to Salesforce.

Searches

Search with Query

This search module looks for records in an object in Salesforce that match the search query you specify. You can map this information in subsequent modules in the scenario.

When you are configuring this module, the following fields display.

Connection
For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions
Source file
Select a source file from a previous module, or map the source file's name and data.
Document linking
Select whether to apply a content document link.
linkedEntityId
If using document linking, enter or map the ID of the linked object.
ShareType

If using document linking, select permissions for the file.

  • Viewer permission

    The user can view the file.

  • Collaborator permission

    The user can view and edit the file.

  • Inferred permissions

    Permissions are based on the user's permissions to the related record, such as a library.

Visibility

If using document linking, enter or map the document's visiblity.

  • AllUsers

    Available to all users with permissions

  • InternalUsers

    Available to internal users with permissions.

  • SharedUsers

    Available to users that can see the feed to which the file is posted.

Connection
For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions.
Search Type

Select the type of search you want the module to perform:

  • Simple

  • Using SOSL (Salesforce Object Search Language)

  • Using SOQL (Salesforce Object Query Language)

Type
If you selected the Simple search type, choose the type of Salesforce record that you want the module to search for.
Query / SOSL Query / SOQL Query

Enter the query that you want to search by.

For more information on SOSL, see Salesforce Object Search Language (SOSL) in the Salesforce documentation.

For more information on SOQL, see Salesforce Object Query Language (SOQL) in the Salesforce documentation.

Note: Please note that the value of the parameter RETURNING influences the output of the module. If you use LIMIT, Fusion will ignore the settings in the Maximal count of records field. If you don't set any limit, Fusion will insert the value LIMIT = Maximal count of records.

Maximal count of records
Enter or map the maximum number of records you want the module to return during each scenario execution cycle.

This action module retrieves all records meeting a given criteria.

Connection
For instructions about connecting your Salesforce account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions
Type
Select the type of object that you want to search for.
Search criteria
Select the field that you want to search by, the operator you want to use in your query, and the value that you are searching for in the field. You can connect queries by using AND or OR.
Outputs
Select the fields that you want to include in the module's output.
Result set
Select whether you want the module to return All Matching Records, or the First Matching Record only.
Maximal
Enter or map the maximum number of records you want the module to retrieve during each scenario execution cycle.
recommendation-more-help
7e1891ad-4d59-4355-88ab-a2e62ed7d1a3