|
|
|
|
|
|
|
|
|
|
SFModify (Function) In french: SFModifie Modifies the records of a file defined in Salesforce. This file can be a preset Salesforce file or a custom file.
Cnx is sfConnection
Cnx..Login = "balthazar@gmail.com"
Cnx..Password = "azerty" + "XXB12VCZ54"
IF SFConnect(Cnx) = False THEN
Error("La connexion a échoué")
RETURN
END
tabObjets is array of sfObject
ResRequête is sfExecuteQueryResult
sTexteRequête is string = "SELECT RecordTypeId, Beneficiaire__c, "...
"ID, Indice_de_mobiliot__c FROM BCM__c WHERE NAME='" + sRecherche + "'"
ResRequête = SFExecuteQuery(Cnx, sTexteRequête)
UnEnregistrement is sfObject
FOR EACH UnEnregistrement OF ResRequête.Objet
UnEnregistrement.Indice_de_mobiliot__c = "698"
Add(tabObjets, UnEnregistrement)
END
tabRes is array of sfSaveResult
tabRes = SFModify(Cnx, tabObjets)
FOR EACH res OF tabRes
Trace("Succès = "+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: | | | sfCreateIfNotFound | The record is automatically created if it does not exist. In previous versions, this constant was called sfCreationIfNotFound. |
<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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|