SFRead (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Possible error cases:

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

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

This function is now available for WINDEV applications in Linux.

This function is now available for iPhone/iPad applications.

New in version 20

This function is now available for WINDEV applications in Linux.

This function is now available for iPhone/iPad applications.

This function is now available for WINDEV applications in Linux.

This function is now available for iPhone/iPad applications.

Versions 24 and later

This function is now available for WEBDEV sites in Linux.

New in version 24

This function is now available for WEBDEV sites in Linux.

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

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 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.

<Salesforce file>: 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.

Component: wd260ggl.dll