PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Possible error cases:
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
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.
Versions 20 and later
WINDEVLinux This function is now available for the WINDEV applications in Linux.
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 20
WINDEVLinux This function is now available for the WINDEV applications in Linux.
iPhone/iPad This function is now available for the iPhone/iPad applications.
WINDEVLinux This function is now available for the WINDEV applications in Linux.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Example
// Connection to Salesforce
Cnt is sfConnection
Cnt..Login = "vince@gmail.com"
Cnt..Password = "azerty" + "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> , <File Name> , <Identifiers>)
<Result>: Array variable
Array of sfObject variables corresponding to the Salesforce records to retrieve.
<Salesforce Connection>: sfConnection variable
Name of sfConnection variable to use
<List of Items>: Character string (with quotes)
List of items whose value must be retrieved. The names of the items are separated by commas.
<File Name>: Character string (with quotes)
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.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230ggl.dll
Windows Mobile wp230ggl.dll
Linux wd230ggl.so
Minimum required version
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment