I map from a NetSuite XML format to Database.
My XML has the following structure for address:
I only want to map to my database the address where the defaultShipping flag is set to true. So I have a scripted map function that checks whether the flag is true, then the country etc gets mapped. In case the country or addr1 is empty, I have added default values in my target profile, because those fields are mandatory in my database.
However, what happens now is that Boomi creates two lines of data: one with the shipping address and one with the default values.
That's not what I want and I also get an error from the database, because of duplicate keys.
Who can help me, so that I only get one set of data with the Shipping address?