ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Communication / Salesforce functions
  • Properties specific to sfConnection variables
  • Functions that handle the sfConnection type
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
sfConnection (Type of variable)
In french: sfConnexion
The sfConnection 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.
SFConnect is used to check the validity of connection information.
Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.
Example
// Connect to Salesforce
Cnt is sfConnection
 
Cnt.Login = "balthazar@gmail.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")
END
Remarks

Properties specific to sfConnection variables

The following properties can be used to handle a Salesforce connection:
Property nameType usedEffect
SessionInfosfSessionInfoData about the current session. This property is filled after authentication.
This property is read-only.
UsernameCharacter stringUsername.
SandboxModeBoolean
  • True if the "Sandbox" mode is enabled (connection to the test server)
  • False otherwise.
PasswordCharacter stringConnection password. A security token supplied by Salesforce must be added to this password.
LoginServerURLCharacter stringURL 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

SFAddCreates a record in a file of a Salesforce database.
SFConnectAllows you to authenticate yourself beside a Salesforce platform.
SFConvertLeadConverts the leads.
SFDeleteDeletes records from a Salesforce database.
SFDisconnectDisconnects:
  • the Salesforce platform.
  • the current Salesforce session.
SFEmptyRecycleBinClears the specified records from the Salesforce recycle bin.
SFExecuteProcessRequests the execution of a specific process.
SFExecuteQueryRuns an SOQL query (Salesforce Object Query Language) on a Salesforce database.
SFForwardQueryContinues to run a SOQL query (Salesforce Object Query Language) on the records of a Salesforce database.
SFMergeMerges the Salesforce records (also called Salesforce objects).
SFModifyModifies the records of a file defined in Salesforce.
SFReadRetrieves the Salesforce records from their identifiers.
SFSearchPerforms a search among the records found in a Salesforce database.
SFSeekDeletedSeeks and retrieves the records (Salesforce objects) deleted during the specified period.
SFSeekModifiedSeeks and retrieves the records (Salesforce objects) modified during the specified period.
SFUndeleteRestores previously deleted Salesforce records.
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/26/2023

Send a report | Local help