Forum Discussion

samuelrz's avatar
samuelrz
New Contributor
2 years ago

Salesforce Read - Where Clause Syntax

I am reading a csv file from S3, and I need to perform a validation to see if the record exists, and was created within 90 days, from the Opportunity object. If it meets the below criteria, then I ne...
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
2 years ago

samuelrz 

You can go with Salesforce SOQL or Salesforce Read Snap, using both snaps you can apply multiple conditions in the WHERE clause. 

"AccountId =  '" + $AccountId + "' 
AND Product_Need__c = '" + $Product_Need__c + "'
AND CreatedDate = LAST_N_DAYS:90"

In your case, I will go with following approach: 

  • Read CSV file
  • Read all Opportunities from Salesforce created within 90 days
  • Match records from CSV file and Salesforce using Join Snap