Hello,I am trying to create a pipeline that checks if we've missed any entries being pulled down from Salesforce. The Account Name field comes down as the key field from Salesforce into the QuickBase entry.
Basically, I want to look through all the Account Names in Salesforce and compare them to all of the Account Names in QuickBase. If the Account Name isn't found in QuickBase, I want it to create a new entry.
Any suggestions on how to make this pipeline would be appreciated!
So to confirm the Account Name is the key field in Quickbase? Or at least unique? You don't necessarily have to check, you could just query for all your SF accounts and load them all into Quickbase each day. If the Account already exists then it will import but nothing will change so no harm done, if it doesn't exist then it will simply import with the others.
*SIGH* Yes! You are right. That didn't even cross my mind. I don't know why I thought it would make duplicates. Thank you!