Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In this article

Table of Contents
maxLevel2
absoluteUrltrue

Overview

...

You can use this account type to access the following Snaps in the Salesforce Snap Pack:

...

connect Salesforce Snaps with data sources that use Salesforce Dynamic account.

Multiexcerpt include macro
nameSecrets_Management_Dynamic_Accounts
templateData[]
pageS3 Dynamic Account
addpanelfalse

Prerequisites

None.

Limitations

None.

...

None.

Account Settings

Image Added

Field NameField TypeDescription

Label*

Default ValueNone
Example:
Salesforce Dynamic Account

String

Specify the name for the account instance.


Access token*

Default Value:

 None]Access token*

 N/A
Example:

Salesforce Dynamic Account

FMJ9810LK21

String/Expression

Specify the access token for Salesforce.com.


Instance URL*

Default Value: N/A
Example

: FMJ9810LK21Instance URL*String

:https://login.salesforce.com

String/Expression

Specify the instance URL to be used to access Salesforce.com.

Default Value: N/A

Examplehttps://login.salesforce.com


Using a Dynamic Token in a Dynamic Account

To use a Dynamic Token from Salesforce with a dynamic account, you will need to create:

  1. A Pipeline to perform the desired Salesforce actions.
  2. A triggered task to call that pipeline.
  3. A REST Get Pipeline to query for the token information.
  4. A Salesforce Dynamic Account with values supplied by Pipeline parameters. You must use Pipeline parameters since accounts get initialized before Snaps.
Note

You need to create a new connected app in Salesforce. For details, see the Creating a new Connected App post in SnapLogic Community.

Also see Setting up OAuth2 authorization in Salesforce

Salesforce Pipeline

For this pipeline, define two Create a Salesforce Pipeline (with any Salesforce Snaps) using the following Pipeline parameters:

  • accessToken
  • instanceURL

You will supply values for them in the triggered task. The necessary Salesforce Dynamic Account will be created later, so bypass that for now.

...

Create a triggered task for the Salesforce Pipeline. Supply the instance_url and access_token values the instance_url and access_token values received from the grant_type POST to the Pipeline parameters.

...

Create a REST Get pipeline that calls the Salesforce triggered task with the query parameters such as:

Salesforce Dynamic Account

Back in In the Salesforce Pipeline, create a Salesforce Dynamic Account within the Salesforce Snap used.

...

The Snap reads records from the Account object, and retrieves values for the 10 output fields (Output field limit) starting from the 3rd field (OutputfieldOutput field offset). Additionally, we are passing the values dynamically with the expressions enabled. The Pipeline parameters to be passed dynamically are set for the Access token and the Instance URL fields. 

...

Image Modified

The Key and Value parameters are assigned using the Edit Pipeline property on the designer.

...

For this

...

Pipeline, define the

...

following parameters:

  • accessToken
  • instance

Image Modified

The Salesforce Read Snap reads the records from the object, Account, to the extent of 10 records starting from the 3rd record (by defining the properties- Output field limit and Output field offset with the values 10 and 3 respectively).

Image Modified

Create a dynamic account and toggle (enable) the expressions for Access Token and Instance URL properties in order to pass the values dynamically. 
Set Access token to _accessToken and Instance URL to _instance_url. Note that the values are to be passed manually and are not suggestible. 

Image Modified

Successful execution of the Pipeline displays the

...

tables in the output.