AnsweredAssumed Answered

How to update a NetSuite record after reading it based on values from MySQL DB table?

Question asked by pkumar on Apr 9, 2017
Latest reply on Apr 11, 2017 by Srinivas Chandrakanth Vangari

Hi All,

I am fairly new to Dell Boomi so my question might probably be very simple to answer.


I am trying to create a process where I need to read a database table and for each record I need to look into NetSuite and update just one field in the NetSuite record. I tried to do the UPSERT but it requires the complete record for Upserting. Unfortunately, I do not have all the fields in my database table.


So probably I need to read the NetSuite records as well for the records found in database table. Combine the fields and then update the relevant record in NetSuite. 


I was just wondering if someone can help me out how shall I design my process to work that out.