AnsweredAssumed Answered

Netsuite custom fields of customer address not in XML

Question asked by Sjaak Overgaauw on Jul 27, 2016
Latest reply on Aug 2, 2016 by Sjaak Overgaauw

Hi all,

I'm trying to retrieve a Netsuite "Other custom field" which has been added to a customer address. FYI: the address of a customer isn't a separate object type but belongs to the customer object itself. If you want to add custom address fields, you have to use custom fields of the type "other custom field". In Netsuite, everything works fine. However, Boomi does not show the custom fields in the XML. FYI: I'm not using the advanced search option, I know how to fix these.

 

According to the information of Lee Sobotkin, see "Custom Netsuite Fields are not properly being mapped", you have to change the XML profile the Netsuite connector generates before you will see custom fields. I think my Boomi setup is not correct. Any suggestions?

 

Netsuite setup

 

Screen Shot 2016-07-27 at 19.50.45.png

Screen Shot 2016-07-27 at 19.51.50.png

 

Boomi XML profile "type" setup

 

  • customFieldList: changed  max occurs to unbounded
  • Added Storelocatorcoordinates + 2 other fields to "Address_customFieldList_CustomFieldList"
    • Type Name = StringCustomFieldRef

 

Screen Shot 2016-07-27 at 20.02.54.png

Screen Shot 2016-07-27 at 20.03.22.png

 

Boomi XML profile "Data Elements" setup

 

This part, I'm not sure if the setup is correct. I never used identifier instances before.

 

  • Added: identifier instance for each of the 3 fields

Screen Shot 2016-07-27 at 20.04.20.png

 

Screen Shot 2016-07-27 at 20.10.35.pngScreen Shot 2016-07-27 at 20.10.48.png

Outcomes