Workato Trigger Behavior with Null Salesforce Date Fields

[San]

In my recipe, I’m using a trigger condition to pick new or updated Contracts from Salesforce where:

contract_end_date.to_date > yesterday

If one of the records has a blank or null Contract End Date, how does the Salesforce connector behave? Will it still evaluate and process the remaining records that meet the trigger condition, or will the empty date cause the entire batch to fail? 

[rajeshjanapati]

Hi @San,

Here’s how the Salesforce connector will behave in this scenario:

1. A null Contract_End_Date will not break the batch.
   Workato evaluates the trigger condition for each record individually. 
   If Contract_End_Date is null, it simply doesn’t meet the condition of Contract_End_Date.to_date > yesterday, so Workato skips that record.
   The remaining records that match the condition will be processed normally.

2. If you also want to pick up records where the Contract_End_Date is blank, you can update your condition to include null values in WHERE clause:

   Contract_End_Date > YESTERDAY OR Contract_End_Date = null

This way, your recipe will fetch both records with recent end dates and those with an empty end date field.

Feel free to share more details if you need help refining the logic!

Thanks & Regards,

J Rajesh Kumar.

[San]

Thank you for the reply, I am also expecting to skip that record and process remaining records that match the condition. But instead I see a below error at recipe and stopped processing any records.

Thank You

San

 

[rajeshjanapati]

Will you please share the screenshot of the Trigger configuration with WHERE condition.

Thanks,

J Rajesh Kumar.

[San]

Weird, above I have attached the screenshot but now I am getting don't have permission to upload the screenshot.

Below is my trigger condition:

New/updated Contract in Salesforce
IF Contract End DateStep 1.to_date() greater than now.to_date() - 1.days
AND Send to BCStep 1 is true
AND StatusStep 1 does not equal Draft
AND Last Modified By IDStep 1 does not equal Workato_userProperties
AND StatusStep 1 does not equal In Approval Process