Prevent integration triggering when loading customer data via CSV or MSSQL endpoint into NetSuite.
We run a quarterly NCOA ( Nation Change of Address ) update on our Customer Addresses.
We also have customer integration running 24/7 to another product.
I do not want to overwhelm those integrations while doing the data import to NetSuite. >100K records.
I extract all active US customer address data, send for processing.
When I get the file back, I want to import the address corrections and set a last NCOA processed date to the exported date even on records that did not change.
I do not want to have this import flag/trigger a sync to our other systems.
I can already bulk update these without triggering integration very quickly.
This does not need to happen via CSV import, I could stage the data in MSSQL.
I am doing this already for other endpoints.
The data loaded will fall into 2 groups.
The first is anyone that moved will have the updated address or if the data was correctable, it will standardize to USPS standards. Main Street will be Main St etc.
I will load the fixed address data, update a field with Mailable Address=True and add a processed date.
The second group are records that do not conform to USPS mailing standards.
Invalid street name or number etc.
For this group I want to update the processed date, and set Mailable Address=False.
This prevents waisted mailing and we comply to standards!
It also can alert us to gathering updated information if we communicate with the customer.
I predetermine the groups in staging and do 2 data load steps.
In SQL, I would do a MERGE and the modified on fields can be updated without changing the modified date.
Also, if the address processed date is prior to the last modified date, I do not want to load the data as it has changed since I sent the data for processing.
This is within 24 hours, so that is minimal.
I am looking for the equivalent to "Celigo Update" for Sales Force Accounts and Contacts.
Thanks!
-
Hi Gene Levasseur, thank you for your insights. I will share this information with our Product Management team. I request that you also raise this enhancement request and future enhancement requests using the Product portal section on integrator.io.
Please let us know if you are facing any issues with uploading your enhancement requests using this feature in integrator.io.
0
Please sign in to leave a comment.
Comments
1 comment