Hi All -
We are replacing a tool with Boomi and I'm replicating existing processes in it. I'm wondering if there is an example doing exactly what I'm trying to do. I'm sure this is a pretty standard process.
I need to:
pull data from Salesforce connector by a createdate param
iterate through each record
check whether it exists already in the SQL database
If yes, do nothing
If no, insert into the destination database.
Pretty basic right? I have my connectors set up but I'm stuck on how to have the createdate param be dynamic based on the last time it ran and then the for each...I haven't gotten very far.