Find and append new unique values to secondary table
I have an app where I run a daily upload of data (much of it duplicate due to the nature of the source), but sometimes my daily upload includes a new record that needs to be added to a secondary table...
If you have the ability, I'd use a webhook to a script that will query the table, and then do a single import based on a the combined information, thus limiting the duplicates.