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 = "email@example.com"
Cnt..Password = "qwerty" + "XXB12VCZ54"
IF SFConnect(Cnt) = False THEN
Error("The connection failed")
Identifiers is array of strings
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)
<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.
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
This page is also available for…