Pulling serial number into NetSuite Amazon Order Flow

Integration Apps
,
1

Hi All, we recently started getting serial number data in our FBA order flow. I am trying to map it to a custom field on the SO but when trying to set the mapping, the serial number field does not appear on the source record data, but we are getting it in the live order data.When I type Serial in the source field to map all i get is the serial required field as shown below. How can i map the field to he map to NetSuite? Below is the JSON of an order from the FBA order field.

image

"BuyerInfo": {},
"ItemTax": {
"CurrencyCode": "USD",
"Amount": "xx.xx"
},
"QuantityShipped": 1,
"SerialNumbers": [
"Serial No.=F9FD60MYMF3Q"
],

2

Hi Antonio,

Thank you for reaching out.

Could you please let me know if you've already tried refreshing the Source Record Fields by clicking the refresh icon next to it?

If not, could you please give that a try and let me know whether the Serial Number field appears afterward?

image
image1284×115 6.83 KB

3

Hi Aaron, I did click the refresh and that field still did not appear, i still only see the SerialNumberRequiered field.

Thank you,

Antonio

4

Hi Antonio,

Thank you for your update.

Per checking in the sample JSON you shared, since SerialNumbers is nested inside the OrderItem array, please try to type the path manually in the source field box rather than selecting from a dropdown.

Try typing this directly into the source field:

OrderItem[*].SerialNumbers[0]

If the mapper doesn't accept bracket notation for the array index, switch to the Handlebars Expression mapping type and use:

{{OrderItem.0.SerialNumbers.0}}

Please let me know what would be of the result.

5

Hi Aaron, thanks for your help, the Bracket notation did work, I imported an order manually in sandbox to confirm and the field did populate correctly.

Thank you again