The
sfObject type is used to describe a record of a SalesForce file. The characteristics of this type of variable can be defined and changed using different WLanguage properties.
This type of variable is used by the following types of variables:
Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see
Declaring a variable.
// Connect to Salesforce
Cnt is sfConnection
Cnt.Login = "balthazar@gmail.com"
Cnt.Password = "qwerty" + "XXB12VCZ54"
IF SFConnect(Cnt) = False THEN
Error("The connection failed")
RETURN
END
ResQuery is sfExecuteQueryResult
ResQuery = SFExecuteQuery(Cnt, "SELECT Date__c,Miles_c,Contact__c FROM Mileage__c")
ARecord is sfObject
FOR EACH ARecord OF ResQuery.Object
Trace("---- Type: " + ARecord.ObjectType + " | ID: " + ARecord.ID)
Trace(ARecord.Date__c + " / " + ARecord.Miles__c + " / " + ...
ARecord.Contact__c)
END
Remarks
Properties specific to sfObject variables
The following properties can be used to handle a record of a Salesforce file:
| | |
| Name | Type used | Effect |
|---|
| ID | Character string | Identifier of the record. |
| NullItem | Character string | List of record items with no value. The different items are separated by CR characters (Carriage Return). |
| ObjectType | Character string | Name of the file to which the record belongs. 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 name of the file followed by 2 underscore characters then by the letter "c". For example: "MyAccount__c". |
| <Item name> | Type of item | Allows you to access any file item directly via its name.
Remark: The name of the item must correspond to the name defined in the Salesforce interface as the "API name". For a custom file, this name corresponds to the name of the item followed by 2 underscore characters then by the letter "c". For example: "OpenDate__c". |
Functions that handle the sfObject type
| |
| SFAdd | Creates a record in a file of a Salesforce database. |
| SFModify | Modifies the records of a file defined in Salesforce. |
| SFRead | Retrieves the Salesforce records from their identifiers. |