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: