# Salesforce In step

**URL:** <https://community.synatic.com/t/salesforce-in-step/137>\
**Category:** Connections\
**Tags:** salesforce, helper-functions\
**Created:** [November 17, 2021, 3:36pm UTC](https://community.synatic.com/t/salesforce-in-step/137 "2021-11-17T15:36:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![navessa](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.synatic.com/navessa/32/58_2.png) [@navessa](https://community.synatic.com/u/navessa)\
**Post date:** [November 17, 2021, 3:36pm UTC](https://community.synatic.com/t/salesforce-in-step/137/1 "2021-11-17T15:36:21Z")

</div>

The Salesforce In step is used as a source step if you want to put an array/ list of data in a field on Salesforce.

To create a connection to Salesforce, you **must** have an account on Salesforce first.

To create a connection to Salesforce in this step, click on the plus icon that is next to the word “Connection” that is highlighted below.

![image](https://canada1.discourse-cdn.com/flex032/uploads/synatic/original/1X/ce566655dbea36e44206cc5e5a7652dd589201fb.png)

Then type a connection name, choose a connection type and fill in the credentials to get authorization based on the connection type you chose as shown below.

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/synatic/original/1X/d7cd64ac80f6321432892982df85ed45f93b4f6f.png)

In the **Command** field, type in a query using Salesforce Object Query Language (SOQL) to create the array/ list and customize what data you want to go in it.

In the **In** field that is highlighted in the below image at the bottom, you can put the **array/ list field name** which will have the list of values in it or you can **manually type in an array/ list** of values that you want to be pushed into the created list/ field on Salesforce.

In the **Size** field, you can change the size of the In statement to batch.  
In the **Limit** field, you can change the maximum number of records to fetch.

Illustrated below is an example of how to use the In parameter to query Salesforce by a list of fields (array)

The below image shows how the data looks before passed to the SalesForce In step

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/synatic/original/2X/7/742d65e82958422023d44c7e08e06267db1c5690.png)

SalesForce In-step configuration

`SELECT FIELDS(ALL) FROM Account WHERE Id IN ({#inList})`

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/synatic/original/2X/6/6305305ee8bbf38e59c253eb656841180a8666b9.png)