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.