

SalesforceBulk Connector Reference

The following operations allow you to work with the Salesforce SOAP Connector. Click an operation name to see parameter details and samples on how to use it.

---

Initialize the connector

To use the Salesforce SOAP connector, add the <salesforcerest.init> element in your configuration before carrying out any other Salesforce SOAP operations.

salesforcebulk.init

The salesforcerest.init operation initializes the connector to interact with the Salesforce SOAP API. See the related API documentation for more information.

Parameter Name	Description	Required
username	The username to access the Salesforce account.	Yes
password	The password provided here is a concatenation of the user password and the security token provided by Salesforce.	Yes
loginUrl	The login URL to access the Salesforce account.	Yes
blocking	Indicates whether the connector needs to perform blocking invocations to Salesforce. (Supported in ESB 4.9.0 and later.)	Yes

Sample configuration

<salesforce.init>
    <loginUrl>{$ctx:loginUrl}</loginUrl>
    <username>{$ctx:username}</username>
    <password>{$ctx:password}</password>
    <blocking>{$ctx:blocking}</blocking>
 </salesforce.init>

Sample request

<salesforce.init>
    <username>MyUsername</username>
    <password>MyPassword</password>
    <loginUrl>https://login.salesforce.com/services/Soap/u/42.0</loginUrl>
    <blocking>false</blocking>
</salesforce.init>

---

Working with emails

emails

The salesforcebulk.emails method creates and sends an email using Salesforce based on the properties that you specify. See the related API documentation for more information.

Parameter Name	Description	Required
sendEmail	XML representation of the email.	Yes

Sample configuration

<salesforce.sendEmail>
    <sendEmail xmlns:sfdc="sfdc">{//sfdc:emailWrapper}</sendEmail>
</salesforce.sendEmail>

Sample request

Given below is a sample request that can be handled by the sendEmail operation.

<payloadFactory>
   <format>
     <sfdc:emailWrapper xmlns:sfdc="sfdc">
     <sfdc:messages type="urn:SingleEmailMessage">
        <sfdc:bccSender>true</sfdc:bccSender>
        <sfdc:emailPriority>High</sfdc:emailPriority>
        <sfdc:replyTo>123@gmail.com</sfdc:replyTo>
        <sfdc:saveAsActivity>false</sfdc:saveAsActivity>
        <sfdc:senderDisplayName>wso2</sfdc:senderDisplayName>
        <sfdc:subject>test</sfdc:subject>
        <sfdc:useSignature>false</sfdc:useSignature>
       <sfdc:targetObjectId>00390000001PBFn</sfdc:targetObjectId>
       <sfdc:plainTextBody>Hello, this is a holiday greeting!</sfdc:plainTextBody>    
     </sfdc:messages>
      </sfdc:emailWrapper>
    </format>
    <args/>
</payloadFactory>

<salesforce.sendEmail>
    <sendEmail xmlns:sfdc="sfdc">{//sfdc:emailWrapper}</sendEmail>
</salesforce.sendEmail>

sendEmailMessage

The salesforcebulk.sendEmailMessage method sends emails that have already been drafted in Salesforce. See the related API documentation for more information.

Parameter Name	Description	Required
sendEmailMessage	XML representation of the email IDs to send.	Yes

Sample configuration

<salesforce.sendEmailMessage config-ref="connectorConfig">
    <sendEmailMessage xmlns:sfdc="sfdc">{//sfdc:emails}</sendEmailMessage>
</salesforce.sendEmailMessage>

Sample request

Given below is a sample request that can be handled by the sendEmailMessage operation.

<payloadFactory>
    <format>
        <sfdc:emails xmlns:sfdc="sfdc">
            <sfdc:Ids>0019000000aaMkK</sfdc:Ids>
            <sfdc:Ids>0019000000bbMkK</sfdc:Ids>
        </sfdc:emails>
    </format>
    <args/>
</payloadFactory>

<salesforce.sendEmailMessage config-ref="connectorConfig">
    <sendEmailMessage xmlns:sfdc="sfdc">{//sfdc:emails}</sendEmailMessage>
</salesforce.sendEmailMessage>

---

Working with records

salesforcebulk.create

The salesforcerest.create operation creates one or more record with the Salesforce SOAP API. See the related API documentation for more information.

Parameter Name	Description	Required
allOrNone	Whether to rollback changes if an object fails (see Common Parameters).	Yes
allowFieldTruncate	Whether to truncate strings that exceed the field length (see Common Parameters).	Yes
sobjects	XML representation of the records to add.	Yes

Sample configuration

<salesforce.create configKey="MySFConfig">
    <allOrNone>0</allOrNone>
    <allowFieldTruncate>0</allowFieldTruncate>
    <sobjects xmlns:sfdc="sfdc">{//sfdc:sObjects}</sobjects>
</salesforce.create>

Sample request

Given below is a sample request that can be handled by the create operation.

salesforcebulk.update

The salesforcerest.update operation updates one or more existing records with the Salesforce SOAP API. See the related API documentation for more information.

Parameter Name	Description	Required
allOrNone	Whether to rollback changes if an object fails (see Common Parameters).	Yes
allowFieldTruncate	Whether to truncate strings that exceed the field length (see Common Parameters).	Yes
sobjects	XML representation of the records to add.	Yes

Sample configuration

<salesforce.update configKey="MySFConfig">
    <allOrNone>0</allOrNone>
    <allowFieldTruncate>0</allowFieldTruncate>
    <sobjects xmlns:sfdc="sfdc">{//sfdc:sObjects}</sobjects>
</salesforce.update>

Sample request

Given below is a sample request that can be handled by the create operation.

salesforcebulk.upsert

The salesforcerest.upsert operation update existing records and insert new records in a single operation, with the Salesforce SOAP API. See the related API documentation for more information.

Parameter Name	Description	Required
allOrNone	Whether to rollback changes if an object fails (see Common Parameters).	Yes
allowFieldTruncate	Whether to truncate strings that exceed the field length (see Common Parameters).	Yes
externalId	The field containing the record ID, that is used by Salesforce to determine whether to update an existing record or create a new one. This is done by matching the ID to the record IDs in Salesforce. By default, the field is assumed to be named "Id".	Yes
sObjects	XML representation of the records to update and insert. When inserting a new record, you do not specify sfdc:Id.	Yes

Sample configuration

<salesforce.upsert configKey="MySFConfig">
    <allOrNone>0</allOrNone>
    <allowFieldTruncate>0</allowFieldTruncate>
    <externalId>Id</externalId>
    <sobjects xmlns:sfdc="sfdc">{//sfdc:sObjects}</sobjects>
</salesforce.upsert>

Sample request

Set the externalId field : If you need to give any existing externalId field of sObject to externalId then the payload should be with that externalId field and value as follows in sample.

Sample to set ExternalId field and value

<payloadFactory>
    <format>
        <sfdc:sObjects xmlns:sfdc="sfdc" type="Account">
          <sfdc:sObject>
             <sfdc:sample__c>{any value}</sfdc:sample__c>
             <sfdc:Name>newname001</sfdc:Name>
          </sfdc:sObject>
       </sfdc:sObjects>
    </format>
    <args/>
</payloadFactory>

<salesforce.upsert>
    <allOrNone>0</allOrNone>
    <allowFieldTruncate>0</allowFieldTruncate>
    <externalId>sample__c</externalId>
    <sobjects xmlns:sfdc="sfdc">{//sfdc:sObjects}</sobjects>
</salesforce.upsert>

Given below is a sample request that can be handled by the create operation.

salesforcebulk.search

The salesforcerest.search operation searchs for records, use salesforce.search and specify the search string. If you already know the record IDs, use retrieve instead. See the related API documentation for more information.

Parameter Name	Description	Required
searchString	The SQL query to use to search for records.	Yes

Sample configuration

salesforcebulk.query

The salesforcerest.query operation retrieve data from an object, use salesforce.query with the Salesforce SOAP API. See the related API documentation for more information.

Parameter Name	Description	Required
batchSize	The number of records to return. If more records are available than the batch size, you can use the queryMore operation to get additional results.	Yes
queryString	The SQL query to use to search for records.	Yes

Sample configuration

Note : If you want your search results to include deleted records that are available in the Recycle Bin, use salesforce.queryAll in place of salesforce.query.

<salesforce.query configKey="MySFConfig">
    <batchSize>200</batchSize>
    <queryString>select id,name from Account</queryString>
</salesforce.query>

Sample request

Following is a sample configuration to query records. It also illustrates the use of queryMore operation to get additional results:

salesforcebulk.retrieve

The salesforcerest.retrieve operation IDs of the records you want to retrieve with the Salesforce SOAP API. If you do not know the record IDs, use query instead. See the related API documentation for more information.

Parameter Name	Description	Required
fieldList	A comma-separated list of the fields you want to retrieve from the records.	Yes
objectType	The object type of the records.	Yes
sobjects	XML representation of the records to retrieve.	Yes

Sample configuration

<salesforce.retrieve configKey="MySFConfig">
    <fieldList>id,name</fieldList>
    <objectType>Account</objectType>
    <objectIDS xmlns:sfdc="sfdc">{//sfdc:sObjects}</objectIDS>
</salesforce.retrieve>

Sample request

Given below is a sample request that can be handled by the retrieve operation.

salesforcebulk.delete

The salesforcerest.delete operation delete one or more records. If you do not know the record IDs, use query instead. See the related API documentation for more information.

Parameter Name	Description	Required
allOrNone	Whether to rollback changes if an object fails (see Common Parameters).	Yes
sobjects	XML representation of the records to delete, as shown in the following example.	Yes

Sample configuration

<salesforce.delete configKey="MySFConfig">
   <allOrNone>0</allOrNone>
   <sobjects xmlns:sfdc="sfdc">{//sfdc:sObjects}</sobjects>
</salesforce.delete>

Sample request

Given below is a sample request that can be handled by the retrieve operation.

salesforcebulk.undelete

The salesforcerest.undelete operation restore records that were previously deleted. See the related API documentation for more information.

Parameter Name	Description	Required
allOrNone	Whether to rollback changes if an object fails (see Common Parameters).	Yes
sobjects	XML representation of the records to delete, as shown in the following example.	Yes

Sample configuration

<salesforce.undelete configKey="MySFConfig">
    <allOrNone>0</allOrNone>
    <sobjects xmlns:sfdc="sfdc">{//sfdc:sObjects}</sobjects>
</salesforce.undelete>

Sample request

Given below is a sample request that can be handled by the undelete operation.

salesforcebulk.getDeleted

The salesforcerest.getDeleted operation retrieve the list of records that were previously deleted. See the related API documentation for more information.

Parameter Name	Description	Required
sObjectType	sObjectType from which we need to retrieve deleted records	Yes
startDate	start date and time for deleted records lookup	Yes
endDate	end date and time for deleted records lookup	Yes

Sample configuration

<salesforce.getDeleted configKey="MySFConfig">
    <sObjectType>{$ctx:sObjectType}</sObjectType>
    <startDate>{$ctx:startDate}</startDate>
    <endDate>{$ctx:endDate}</endDate>
</salesforce.getDeleted>

Sample request

Given below is a sample request that can be handled by the getDeleted operation.

salesforcebulk.getUpdated

The salesforcerest.getUpdated operation retrieve the list of records that were previously updated. See the related API documentation for more information.

Parameter Name	Description	Required
sObjectType	sObjectType from which we need to retrieve deleted records	Yes
startDate	start date and time for deleted records lookup	Yes
endDate	end date and time for deleted records lookup	Yes

Sample configuration

<salesforce.getUpdated configKey="MySFConfig">
    <sObjectType>{$ctx:sObjectType}</sObjectType>
    <startDate>{$ctx:startDate}</startDate>
    <endDate>{$ctx:endDate}</endDate>
</salesforce.getUpdated>

Sample request

Given below is a sample request that can be handled by the getUpdated operation.

salesforcebulk.findDuplicates

The salesforcerest.findDuplicates operation retrieve the list of records that are duplicate entries. See the related API documentation for more information.

Parameter Name	Description	Required
sobjects	sObjectType from which we need to retrieve duplicate records	Yes

Sample configuration

<salesforce.findDuplicates configKey="MySFConfig">
    <sobjects xmlns:ns="wso2.connector.salesforce">{//ns:sObjects}</sobjects>
</salesforce.findDuplicates>

Sample request

Given below is a sample request that can be handled by the findDuplicates operation.

salesforcebulk.findDuplicatesByIds

The salesforcerest.findDuplicatesByIds operation retrieves the list of records that are duplicate entries by using ids. See the related API documentation for more information.

Parameter Name	Description	Required
ids	ids for which duplicate records need to be found	Yes

Sample configuration

<salesforce.findDuplicatesByIds configKey="MySFConfig">
    <ids xmlns:ns="wso2.connector.salesforce">{//ns:ids}</ids>
</salesforce.findDuplicatesByIds>

Sample request

Given below is a sample request that can be handled by the findDuplicatesByIds operation.

salesforcebulk.merge

The salesforcerest.merge operation merge records into one master record. See the related API documentation for more information.

Parameter Name	Description	Required
mergerequests	The merge requests according to the format defined in to Salesforce docs (See Related Salesforce documentation section)	Yes

Sample configuration

<salesforce.merge configKey="MySFConfig">
    <mergerequests xmlns:ns="wso2.connector.salesforce">{//ns:requests}</mergerequests>
</salesforce.merge>

Sample request

Given below is a sample request that can be handled by the merge operation.

salesforcebulk.convertLead

The salesforcerest.convertLead operation convert a lead into an account. See the related API documentation for more information.

Parameter Name	Description	Required
leadconvertrequests	The lead convert requests according to the format defined in to Salesforce docs (See Related Salesforce documentation section)	Yes

Sample configuration

<salesforce.convertLead configKey="MySFConfig">
     <leadconvertrequests xmlns:ns="wso2.connector.salesforce">{//ns:leadconvertrequests}</leadconvertrequests>
</salesforce.convertLead>

Sample request

Given below is a sample request that can be handled by the merge operation.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
                  xmlns:urn="wso2.connector.salesforce">
    <soapenv:Header/>
    <soapenv:Body>
        <urn:loginUrl>https://login.salesforce.com/services/Soap/u/48.0</urn:loginUrl>
        <urn:username>XXXXXXXXXX</urn:username>
        <urn:password>XXXXXXXXXX</urn:password>
        <urn:blocking>false</urn:blocking>
        <urn:leadconvertrequests>
            <urn:leadConverts>
                <urn:accountId>0012x000005mqKuAAI</urn:accountId>
                <urn:leadId>00Q2x00000AH981EAD</urn:leadId>
                <urn:convertedStatus>Closed - Converted</urn:convertedStatus>
            </urn:leadConverts>
        </urn:leadconvertrequests>
    </soapenv:Body>
</soapenv:Envelope> 

---

Working with Recycle Bin

salesforcebulk.emptyRecycleBin

The Recycle Bin allows you to view and restore recently deleted records for a maximum of 15 days before they are permanently deleted. To purge records from the Recycle Bin so that they cannot be restored, use salesforce.emptyRecycleBin and specify the following properties. See the related API documentation for more information.

Parameter Name	Description	Required
allOrNone	Whether to rollback changes if an object fails (see Common Parameters).	Yes
sobjects	XML representation of the records to add.	Yes

Sample configuration

<salesforce.emptyRecycleBin config-ref="connectorConfig">
    <allOrNone>0</allOrNone>
    <sobjects xmlns:sfdc="sfdc">{//sfdc:sObjects}</sobjects>
</salesforce.emptyRecycleBin>

Sample request

Given below is a sample request that can be handled by the emptyRecycleBin operation.

<payloadFactory>
   <format>
      <sfdc:sObjects xmlns:sfdc="sfdc">
         <sfdc:Ids>0019000000aaMkZ</sfdc:Ids>
         <sfdc:Ids>0019000000aaMkP</sfdc:Ids>
      </sfdc:sObjects>
   </format>
   <args/>
</payloadFactory>

<salesforce.emptyRecycleBin>
    <allOrNone>0</allOrNone>
    <sobjects xmlns:sfdc="sfdc">{//sfdc:sObjects}</sobjects>
</salesforce.emptyRecycleBin>

---

Working with sObjects

salesforcebulk.describeGlobal

The salesforcerest.describeGlobal operation retrieve a list of objects that are available in the system. See the related API documentation for more information.

Sample configuration

salesforcebulk.describeSobject

The salesforcerest.describeSobject operation retrieve metadata (such as name, label, and fields, including the field properties) for a specific object type. See the related API documentation for more information.

Parameter Name	Description	Required
sobject	The object type of where you want to retrieve the metadata.	Yes

Sample configuration

salesforcebulk.describeSobjects

The salesforcerest.describeSobjects operation retrieve metadata (such as name, label, and fields, including the field properties) for multiple object types returned as an array. See the related API documentation for more information.

Parameter Name	Description	Required
sobjects	An XML representation of the object types of where you want to retrieve the metadata.	Yes

Sample configuration

<salesforce.describeSobjects configKey="MySFConfig">
    <sobjects xmlns:sfdc="sfdc">{//sfdc:sObjects}</sobjects>
</salesforce.describeSobjects>

Sample request

Given below is a sample request that can be handled by the describeSobjects operation.

<payloadFactory>
    <format>
        <sfdc:sObjects xmlns:sfdc="sfdc">
            <sfdc:sObjectType>Account</sfdc:sObjectType>
            <sfdc:sObjectType>Contact</sfdc:sObjectType>
         </sfdc:sObjects>
     </format>
     <args/>
 </payloadFactory>

<salesforce.describeSobjects configKey="MySFConfig">
    <sobjects xmlns:sfdc="sfdc">{//sfdc:sObjects}</sobjects>
</salesforce.describeSobjects> 

---

Working with User

salesforcebulk.emptyRecycleBin

To retrieve information about the user who is currently logged in, use salesforce.getUserInfo. The information provided includes the name, ID, and contact information of the user. See, the Salesforce documentation for details of the information that is returned using this operation. If you want to get additional information about the user that is not returned by this operation, use retrieve operation on the User object providing the ID returned from getUserInfo. See the related API documentation for more information.

Sample configuration

<salesforce.getUserInfo configKey="MySFConfig"/>

salesforcebulk.setPassword

The salesforcerest.setPassword operation change the user password by specifying the password. See the related API documentation for more information.

Parameter Name	Description	Required
userId	The user's Salesforce ID.	Yes
password	If using setPassword, the new password to assign to the user.	Yes

Sample configuration

setPassword

<salesforce.setPassword configKey="MySFConfig">
    <userId>0056F000009wCJgQAM</userId>
    <password>abc123</password>
</salesforce.setPassword>

resetPassword

<salesforce.resetPassword configKey="MySFConfig">
    <userId>0056F000009wCJgQAM</userId>
</salesforce.resetPassword>    

---

Working with Utility

salesforcebulk.getServerTimestamp

The salesforcerest.getServerTimestamp operation retrieve the timestamp of the server. See the related API documentation for more information.

Sample configuration

<salesforce.getServerTimestamp configKey="MySFConfig"/>

Sample request

Given below is a sample request that can be handled by the emptyRecycleBin operation.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
                  xmlns:urn="wso2.connector.salesforce">
    <soapenv:Header/>
    <soapenv:Body>
        <urn:loginUrl>https://login.salesforce.com/services/Soap/u/30.0</urn:loginUrl>
        <urn:username>XXXXXXXXXX</urn:username>
        <urn:password>XXXXXXXXXX</urn:password>
        <urn:blocking>false</urn:blocking>
    </soapenv:Body>
</soapenv:Envelope> 

Top