Google Sheets import is creating new rows instead of updating existing
I am using the Google Sheets Helper from the marketplace to export a saved search from NetSuite to write to a Google Sheet. It is set up to export the modified data based on the "Date Last Modified" field:
The import is configured to compare the ID fields of the data set (which is the NetSuite Internal ID):
However, when the data is inserted into the Google Sheet, it is NOT updating the existing record; it adds a new record every time:
I have not been able to figure out why this is happening. It should be updating the existing record. Any thoughts?
0
Comments
My suspicion is that the value 'ID' should be 'id' in the field 'Source record field to find existing rows *'. Can you double check the case sensitivity, and (see pic) you can click the 'Edit mock input' link to see the exact record and fields being processed.
Thanks, Scott! That seems to have done the trick, though I thought I had tried that in my many iterations of troubleshooting this. Regardless, you've got the magic touch! :)
Cheers,
Lars
FYI, I just published a new version of the marketplace template that includes new validations and error messages to make debugging this much easier.
Thanks, Scott!
Please sign in to leave a comment.