Well, i tried turning on the Null Safe and Pass Through options. But some pipelines kept throwing this error on the Error Pipeline. Despite throwing this error, the error pipeline is kind of working, it saves an error log and creates a ticket, as intended, but the error log is an empty JSON, with only the empty brackets. Seems like no error info is being sent to the error pipeline.
@rmedeiros Is it possible to share your error pipeline ? you can remove your endpoint details before sharing.
Than I go back to my original statement. This expression will do the job:
Date.parse($Last_Updated) > Date.now().minusHours(48)
I wasn’t able to fetch any records with this criteria but that doesn’t mean this is not the solution. It is indeed and thank you @bojanvelevski for your help on this one.
Reason behind no records to be fetched was there were actually no records those were updated in the last 48 hours, I tweaked my criteria to 7 Days and found some for testing purposes and I can confirm that this worked.
Also, with Date.parse, the date format is consistent so not to worry about EST and UTC.
Something new I learned today was
Date.now().minusDays(7)
This above function helped me test the functionality for the last 7 days.
Thanks again @bojanvelevski , signing off from this thread now!
Sure @bojanvelevski, I will test it out and keep you posted.
For now, I’m not seeing any data in my filter snap, may be there is no record that suffice the condition but I will manually change the data from the source system and test if this works.
As always, appreciate your help on this one too.
Moreover, the Timezone of Last_Updated is UTC as I haven’t changed it to any other timezone, may be that is creating a hurdle?
Use JSON Splitter
@SandeepVemula … I tried a JSON splitter but it doesn’t appear to work…
Here’s my attached pipeline
SFTestReadMulti_2018_06_19.slp (9.1 KB)
Use Head Snap
