New Netsuite connector - Merge Not Working
The Netsuite connector now has a feature to 'Merge' (UPSERT) records from a saved search and you get to identify the primary key of the record (to check if it exists).
Since there was no information I could find about the 'Remove Duplicate' records feature (ie: What does Domo check to figure out what is a duplicate?). For example, I had a bad cost on an invoice, I fixed it and since I changed it (last modified date) it was going to be uploaded again. Is that going to replace the "bad" invoice in Domo?
So I had throught the 'Merge' was going to save the day by updating the bad record with the new "fixed" one (with the same unique key field).
Bzzzt ... Wrong Answer.
I changed my connector to use 'Merge' (vs Replace or Append) and if failed. No error message other than 'It failed.. try again' (Of course I did that... a few times).
Hey Domo, do you read these forums, any insite on this.
(btw: New to Domo but not new to Data Whse and ETL / SQL concepts)
- 10.7K All Categories
- 13 Getting Started in the Community
- 38 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board