SFRead (Function) In french: SFLit Retrieves the Salesforce records from their identifiers. These records can come from a preset Salesforce file or from a custom file.
// 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
Identifiers is array of strings
Add(Identifiers, "123546789")
Add(Identifiers, "987654321")
Res is array of sfObject
Res = SFRead(Cnt, "Date__c,Miles__c,Contact__c", "Mileage__c", Identifiers)
MyRecord is sfObject
FOR EACH MyRecord OF Res
Trace("---- Type: " + MyRecord..ObjetType + ...
" | ID: " + MyRecord..ID)
Trace(MyRecord..Date__c + " / " + MyRecord..Miles__c + ...
" / " + MyRecord..Contact__c)
END
Syntax
<Result> = SFRead(<Salesforce connection> , <List of items> , <Salesforce file> , <Identifiers>)
<Result>: Array variable Array of sfObject variables corresponding to the Salesforce records to retrieve. <Salesforce connection>: sfConnection variable Name of the variable of type sfConnection to be used. <List of items>: Character string List of items whose value must be retrieved. The names of the items are separated by commas. <Salesforce file>: Character string Name of the Salesforce file to read. This name must correspond to the name defined in the Salesforce interface as the "API name". For a custom file, this name corresponds to the file name followed by 2 underscore characters then by the letter "C". For example: "MyAccount__C". <Identifiers>: Array variable Array of character strings containing the Salesforce identifiers of the records to retrieve. Remarks Possible error cases: - The Internet connection is not valid.
- The authentication was not performed properly.
- The XML response of the server cannot be read.
To find out whether an error occurred, use the ErrorOccurred variable.
This page is also available for…
|
|
|
|