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:

If you need instructions on creating a scenario, see Create a scenario in Adobe Workfront Fusion.

For information about modules, see Modules in Adobe Workfront Fusion.

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

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

Adobe Workfront plan*
Pro or higher
Adobe Workfront license*
Plan, Work
Adobe Workfront Fusion license**

Current license requirement: No Workfront Fusion license requirement.

Or

Legacy license requirement: Workfront Fusion for Work Automation and Integration

Product

Current product requirement: If you have the Select or Prime Adobe Workfront plan, your organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described in this article. Workfront Fusion is included in the Ultimate Workfront plan.

Or

Legacy product requirement: Your organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described in this article.

To find out what plan, license type, or access you have, contact your Workfront administrator.

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
v46.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.

Salesforce modules and their fields

Triggers

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.

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.

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.

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>

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>

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 in Adobe Workfront Fusion.

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.

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:

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.

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>

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.

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.
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
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43