ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Communication / Salesforce functions
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
Modifies the records of a file defined in Salesforce. This file can be a preset Salesforce file or a custom file.
Example
// Connect to Salesforce
Cnt is sfConnection
Cnt.Login = "vince@gmail.com"
Cnt.Password = "qwerty" + "XXB12VCZ54"
IF SFConnect(Cnt) = False THEN
Error("The connection failed")
RETURN
END
 
arrObjects is array of sfObject
ResQuery is sfExecuteQueryResult
sQueryText is string = "SELECT RecordTypeId, Recipient__c, "...
"ID, Subscript_of_mobiliot__c FROM BCM__c WHERE NAME='" + sSearch + "'"
 
ResQuery = SFExecuteQuery(Cnt, sQueryText)
 
ARecord is sfObject
FOR EACH ARecord OF ResQuery.Object
ARecord.Subscript_of_mobiliot__c = "698" // Modification
Add(arrObjects, ARecord)
END
 
arrRes is array of sfSaveResult
arrRes = SFModify(Cnt, arrObjects)
FOR EACH res OF arrRes
Trace("Success = "+res..Success)
END
Syntax

Modifying the existing records Hide the details

<Result> = SFModify(<Salesforce connection> , <Records to modify>)
<Result>: Array variable
Array of sfSaveResult variables containing the result data, especially the identifiers of the objects actually modified.
<Salesforce connection>: sfConnection variable
Name of the variable of type sfConnection to be used.
<Records to modify>: Array variable
Array of sfObject variables corresponding to the Salesforce records to modify. This array can contain up to 200 elements.

Modifying the existing records or creating records Hide the details

<Result> = SFModify(<Salesforce connection> , <Records to modify or create> , <Mode> , <External identifier>)
<Result>: Array variable
Array of sfSaveResult variables containing the result data, especially the identifiers of the objects actually modified.
<Salesforce connection>: sfConnection variable
Name of the variable of type sfConnection to be used.
<Records to modify or create>: Array variable
Array of sfObject variables corresponding to the Salesforce records to modify or create. This array can contain up to 200 elements.
<Mode>: Integer
Modification mode used:
sfCreationIfNotFoundThe record is automatically created if it does not exist.
<External identifier>: Character string
For a custom file, name of the item defined as unique item identifier from an external system.
  • This item is also used to identify the record to modify.
  • This item and its value are found in the sfObject object to modify.
    • The record will be automatically created if the value does not exist.
    • The record is updated if the value exists once.
    • An error is returned if the value exists several times.
Remarks
Component: wd290ggl.dll
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help