Removing row in database using the upload script
Hi there - we are running an automatic script from Filemaker to update the Zoho database with our data every 5 minutes...right now I am using the
UPDATEADD flag so that I am not uploading duplicate rows and set the ZOHO_MATCHING_COLUMNS flag in the param file. We recently ran into an issue where a row/record was created in Filemaker accidentally, then removed 10 minutes later...so it uploaded into Zoho unfortunately before we caught it. We can remove those manually as needed in Zoho, but is there a way to catch those non-matching rows and remove them from zoho? Or will I need to use the TRUNCATEADD option and basically remove the full database and re-upload each time? My main question for that would be, will that then remove my custom fields/formulas as well?
Thanks for your time