type is used to describe a connection to the Salesforce platform and to manage user authentication. The characteristics of this type of variable can be defined and changed using different WLanguage properties.
is used to check the validity of connection information.
: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable
// Connect to Salesforce
Cnt is sfConnection
Cnt.Login = "email@example.com"
Cnt.Password = "qwerty" + "XXB12VCZ54"
Cnt.LoginServerURL = "https://login.salesforce.com/services/Soap/u/42.0"
IF SFConnect(Cnt) = False THEN
Error("The connection failed")
Properties specific to sfConnection variables
The following properties can be used to handle a Salesforce connection:
|Property name||Type used||Effect|
|SessionInfo||sfSessionInfo||Data about the current session. This property is filled after authentication.|
This property is read-only.
- True if the "Sandbox" mode is enabled (connection to the test server)
- False otherwise.
|Password||Character string||Connection password. A security token supplied by Salesforce must be added to this password.|
|LoginServerURL||Character string||URL of the server to use. This property is optional. If this property is specified, it is used for the authentication.|
Functions that handle the sfConnection type
|SFAdd||Creates a record in a file of a Salesforce database.|
|SFConnect||Allows you to authenticate yourself beside a Salesforce platform.|
|SFConvertLead||Converts the leads.|
|SFDelete||Deletes records from a Salesforce database.|
- the Salesforce platform.
- the current Salesforce session.
|SFEmptyRecycleBin||Clears the specified records from the Salesforce recycle bin.|
|SFExecuteProcess||Requests the execution of a specific process.|
|SFExecuteQuery||Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database.|
|SFForwardQuery||Continues to run a SOQL query (Salesforce Object Query Language) on the records of a Salesforce database.|
|SFMerge||Merges the Salesforce records (also called Salesforce objects).|
|SFModify||Modifies the records of a file defined in Salesforce.|
|SFRead||Retrieves the Salesforce records from their identifiers.|
|SFSearch||Performs a search among the records found in a Salesforce database.|
|SFSeekDeleted||Seeks and retrieves the records (Salesforce objects) deleted during the specified period.|
|SFSeekModified||Seeks and retrieves the records (Salesforce objects) modified during the specified period.|
|SFUndelete||Restores previously deleted Salesforce records.|