Solved
Limit results to 1 record on Salesforce Lookup Snap
We are using a Salesforce Lookup snap to return Account record Id’s based on a bunch of conditions. At the moment, if there are duplicate records in Salesforce, SnapLogic returns more than 1 id. We’d...
Hi @NAl
You can switch from Salesforce Lookup Snap to Salesforce Read Snap where you can specify the number of rows to be returned from Salesforce, in Limit Clause field:
Also, all the conditions that you have in Lookup Snap you can put in the Where Clause field of the Salesforce Read Snap, so you will get identical results.
If you don’t want to switch the Lookup Snap, then another solution can be to Group the returned records from Salesforce, in SnapLogic(based on the duplicate columns) and then to pick the first record from each group.
Regards,
Spiro Taleski
