To select data from a Salesforce.com table, use:

 

SFDC(SOQL=’soql_query_string’,

UserName=’username’,

Password=’password’,

[, ReadAll=’true|false’]

[, Environment=’Sandbox|Production’]

[, Retries=#]

[, RetryInterval=#]

[, RowLimit=#])

 

Where the first three arguments are required:

 

• SOQL: Takes a Salesforce.com SOQL query string.
• UserName: The Salesforce.com username.
  
  NOTE: The user must have appropriate permissions in Salesforce.com to use the Salesforce.com APIs, and also have access to the object referenced in the TableName parameter.
• Password: The password for that SFDC account.

 

Optional arguments:

 

• ReadAll: When true (default), data is returned only after all data has been read from SFDC into Connect.

This setting enhances durability, as it ensures all data can be read from SFDC before proceeding, but it reduces perceived performance, as Connect cannot present any data until SFDC has returned all of it.

When false, data is delivered as it is fetched from SFDC, but if a failure occurs during the fetch, a simple exception is returned, with no recovery or retries.

 

• Environment: Allows Connect to establish a session with either your production or sandbox SFDC endpoints.
• Retries: If ReadAll is true, the Retries parameter controls how many times the function will repeat before success or aborting. The default is 3 retries.
• RetryInterval: Specifies the number of minutes to wait for each retry.. The default is 0 minutes.
• RowLimit: Restricts the number of rows returned by a SELECT query issued to Salesforce.com.  The default value is null.
  
  This setting is useful in testing queries against large Salesforce.com objects. We recommend it when designing queries against SFDC tables with large numbers of rows.
  
  NOTE: Your query could pull hundreds of thousands, or even millions, of rows from SFDC into Xactly Connect if you don’t use valid Where expressions in the SOQL parameter. Use RowLimit to enforce an explicit ceiling.