This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Limit results to 1 record on Salesforce Lookup Snap

Go to solution
NAl
Contributor

‎08-25-2021 06:30 AM

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 like to limit that to just 1, the first returned result.

Returning more than 1 result causes the creation of additional documents and problems further downstream.

0 Kudos
1 ACCEPTED SOLUTION

Go to solution
SpiroTaleski
Valued Contributor

‎08-25-2021 04:06 PM

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:

image

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

View solution in original post

0 Kudos
6 REPLIES 6

Go to solution
SpiroTaleski
Valued Contributor

‎08-26-2021 08:06 AM

Try

"Name = '" + $client + "' AND Custom_Field__c = FALSE"

Regards,
Spiro Taleski

0 Kudos

Go to solution
NAl
Contributor
In response to SpiroTaleski

‎08-26-2021 08:43 AM

Blimey that worked. I had the quotation marks in the wrong place.
Thanks ever so much