Salesforce.Net Reader

Reading from Salesforce

First version available: 2.1.0

Using the Salesforce.Net Reader plugin, it is possible to use SOQL queries to retrieve information, leveraging the plain Salesforce SOAP API directly from the plugin.

In order to extract data from Salesforce, use the following source syntax:

<Source config="[path to config file]">soql.net://[SOQL query]</Source>

Salesforce Reader Configuration

The configuration of the Salesforce.Net Reader (and Salesforce.Net Writer) is stored in a separate XML configuration file.

The documentation on that can be found on the Salesforce Configuration File page. This configuration file is the same for both the Salesforce Reader and the Salesforce.Net Reader (this plugin).

Using SOQL Queries

Standard Salesforce SOQL queries are supported. All fields which are to be retrieved from Salesforce must be separately defined in the query, as does obviously also the entity.

Example:

<Source config="sfdc_config.xml">soql.net://select Id, FirstName, LastName from User</Source>

This snippet will read the Salesforce Id, first name and last name from the User entity in Salesforce.

Note: Where clauses are also supported.

Please confer with the Salesforce documentation for a complete guide on how to write SOQL statements.