---
sourceDocument: Brazil Sales Customer Relationship Management
sourceDocumentLink: https://www.servicenow.com/docs/r/order-management

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Sales Customer Relationship Management

ft:clusterId :

    - omgmt

bundleId :

    - omgmt

workflow :

    - Customer and Industry


---

# Passing array variables using Salesforce external connection

# Passing array variables using Salesforce external connection {#ariaid-title1}

Release version: Brazil  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
You must use single quote strings when making a SOQL query to Salesforce.

Salesforce supports only single quote strings in a SOQL query. Therefore, the following inputs would not be recognized by Salesforce.

    let inputs = { "productsArray": '("Tablet10", "Laptop13", "Laptop15")' }

Instead, use single quotes as in the following snippet.

    let inputs = { "productsArray": "('Tablet10', 'Laptop13', 'Laptop15')" }

The following sample script pulls Salesforce IDs.

    // Array of Salesforce IDs
    const idList = ['0066e00001pGlTUAA0', '0066e00001pGlTTAA0', '0066e00001pGlTPAA0'];

    // Create a string to pass to the SOQL IN query
    // first part: "('" = opening parenthesis and single quote
    // middle part: idList.join("','") = join all the Salesforce Ids with single quote, a comma and single quote
    // last part: "')" = single quote and closing parenthesis
    const soqlIn = "('" + idList.join("','") + "')";

    // inputs to the SOQL query and calling SF connection
    const inputs = {"idList": soqlIn};
    const response = Salesforce.<yourExternalConnectionVariableName>(inputs);

**Related concepts**   

* [Using external connections with OAuth support](https://www.servicenow.com/docs/XH_swCKZ1FBaHoD9Xmnrmw "External connections allow enrichments to retrieve data from third-party systems to enhance configurations. When security requires OAuth, you can set up an OAuth handshake using client credentials to authenticate and access external APIs. This approach ensures secure data exchange for tasks such as pricing updates or attribute population during configuration.")
* [Passing data from Salesforce to CPQ fields](https://www.servicenow.com/docs/T2fgy7SWgSTTsNOjZwu2IA "Learn how to pass information from Salesforce into CPQ using the On Configuration/Reconfigure enrichment.")

