Hi,
I have a flow that exports NetSuite Sales Orders along with Item line and import to a 3Pl connected via http connector. I have used the "Group Rows" in Export step.
Below is mapping
In the mapping preview the item lines are mapped correctly but in the Import only the first item line is included.
I have done similar flow in the past and it worked for multiple items. What could be the reason for this behavior?
Thank You
@aishwaryamj it may just be preview showing 1 even though during run it would have all. Where is the last screenshot from? Are you using mapper 1.0 or are you using transformation 1.0 on the export?
I am using Mapper 1.0 not transformation. I have one sales order record with 2 item lines in the Export , Group Rows is checked and get the 2 items mapped in the preview. But when post the data to destination only 1st item line is included in the array.
This is my export data.
{
"page_of_records": [
{
"rows": [
{
"id": "18389286",
"recordType": "salesorder",
"Date": "07 MAY, 2024",
"OrderNumber": "US76700",
"CustomerName": "Lowe's Parent : Lowe's RDC",
"PoNumber": "test#007",
"requestedShipDate": "07 MAY, 2024",
"Item": "FSB-094791",
"Line ID": "1",
"Quantity": "2",
"WarehouseCode": "25",
"RequestedCarrierCode": "ZZZZ",
"WarehouseInstructions": "this is test order",
"Company Name": "Lowe's RDC",
"Addressee": "Lowe's",
"Shipping Attention": "",
"Street1": "2782 York Road",
"Street2": "",
"City": "Pleasant View",
"State": "TN",
"Zip": "37146",
"Country": "United States",
"Phone": "",
"Email": "",
"BillingAddressee": "Lowe's",
"BillingAttention": "",
"billingStreet1": "2782 York Road",
"BillingAddress2": "",
"BillingCity": "Pleasant View",
"BillingState": "TN",
"BillingZip": "37146",
"BillingCountryCode": "US",
"BillingPhone": "",
"ShippingCarrier": "FedEx/USPS/More",
"Serial/Lot Number": "",
"CustomerInternalid": "168473",
"Shipdate": "2024-05-07",
"dataURI": "xxxxxxxxxxx"
},
{
"id": "18389286",
"recordType": "salesorder",
"Date": "07 MAY, 2024",
"OrderNumber": "US76700",
"CustomerName": "Lowe's Parent : Lowe's RDC",
"PoNumber": "test#007",
"requestedShipDate": "07 MAY, 2024",
"Item": "FSA-009139",
"Line ID": "2",
"Quantity": "3",
"WarehouseCode": "25",
"RequestedCarrierCode": "ZZZZ",
"WarehouseInstructions": "this is test order",
"Company Name": "Lowe's RDC",
"Addressee": "Lowe's",
"Shipping Attention": "",
"Street1": "2782 York Road",
"Street2": "",
"City": "Pleasant View",
"State": "TN",
"Zip": "37146",
"Country": "United States",
"Phone": "",
"Email": "",
"BillingAddressee": "Lowe's",
"BillingAttention": "",
"billingStreet1": "2782 York Road",
"BillingAddress2": "",
"BillingCity": "Pleasant View",
"BillingState": "TN",
"BillingZip": "37146",
"BillingCountryCode": "US",
"BillingPhone": "",
"ShippingCarrier": "FedEx/USPS/More",
"Serial/Lot Number": "",
"CustomerInternalid": "168473",
"Shipdate": "2024-05-07",
"dataURI": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
}
]
}
]
}
Last screenshot is from debug logs of import step. Here is how it looks like
{
"orderReference": "US76700",
"warehouse": {
"code": "25"
},
"customer": {
"code": "2311680"
},
"receiver": {
"address1": "2782 York Road",
"address2": "",
"suburb": "Pleasant View",
"state": "TN",
"name": "Lowe's",
"postCode": "37146",
"country": "United States",
"phone": "",
"code": "168473"
},
"deliveryInstructions": "this is test order",
"requiredDate": "2024-05-07",
"customerOrderReference": "test#007",
"carrierReference": "ZZZZ",
"orderLines": [
{
"lineNo": "1",
"units": "2",
"product": {
"code": "FSB-094791"
}
}
]
}
Mapping is working in preview but not when running the flow.
No, the Use First Row is not checked in my mapping.
@aishwaryamj I would submit a support ticket then. I'm not able to reproduce and it's working correctly with my similar setup.
Hi @tylerlamparter,
Issue is resolved now. Thank you for the help.
