Filtering Records

A filter can be applied to any query using an OSQL expression.

Examples

To query only Accounts which are GBP the ‘OSQL Where Statement’ would be:

CurrencyIsoCode = 'GBP'

Query elements can be joined with an AND statement:

CurrencyIsoCode = 'GBP' AND CreatedDate > 2018-02-26T10:00:00-08:00

Query elements by a referenced entity.

Account.AccountNumber = 'REL001'

Additionally, queries can be grouped:

fieldExpression1 AND (fieldExpression2 OR fieldExpression3)

A list of available fields for query will be available on the field mapping screen.

Salesforce has extensive documentation on the SOQL syntax here:

https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_sosl_intro.htm