Target Destination Filter
A target destination filter is optional. It relies on a source specific syntax for filtering out records from your target. The filter can reference execution parameters.
Source | Definition |
Salesforce | For Salesforece syntax is the SOQL where clause (without the where expression) |
Dynamics | For Dynamics syntax is the OData $filter clause (without the $filter=expression) |
Cinchy | For Cinchy syntax is the CSQL where clause (without the where expression) |
SqlServer | For SqlServer the syntax is the T-SQL where clause (without the where expression) |
There can only be one <Filter> for each source or target. To specify more than one condition, use AND/OR to allow logical combination of multiple expressions.
Filter Examples
Example 1: Filtering only target records where the Assignee is Null.
Example 2: Filtering only target records where the Override ID is not Null.
Example 3: Filtering only target records from a specific source.
Last updated