# Only first element included in Import data Array

**URL:** <https://connective.celigo.com/t/only-first-element-included-in-import-data-array/142>\
**Category:** Integrator.io\
**Tags:** 3pl-central, http, export, import, netsuite\
**Created:** [May 7, 2024, 9:16am UTC](https://connective.celigo.com/t/only-first-element-included-in-import-data-array/142 "2024-05-07T09:16:16Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![aishwaryamj](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@aishwaryamj](https://connective.celigo.com/u/aishwaryamj)\
**Post date:** [May 7, 2024, 9:16am UTC](https://connective.celigo.com/t/only-first-element-included-in-import-data-array/142/1 "2024-05-07T09:16:16Z")

</div>

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

 ![5301043caa20740200000001-765909133b8f4e098789662dc6a27284.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/6fe92f3327e4ac11861682437ed9c277cd43f981.png)

In the mapping preview the item lines are mapped correctly but in the Import only the first item line is included.

 ![5301043caa20740200000001-f02c4dd02e2f4ebd8be477587b304814.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/3337f02f15cf613b148f5481aaae77db0e4973b4.png)

 ![5301043caa20740200000001-975bede8dc5444119be1a74e9d449f8c.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/9/96fe165036fa515014245526cc05899781ab56d1.png)

I have done similar flow in the past and it worked for multiple items. What could be the reason for this behavior?

Thank You

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [May 7, 2024, 1:44pm UTC](https://connective.celigo.com/t/only-first-element-included-in-import-data-array/142/2 "2024-05-07T13:44:20Z")

</div>

@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?

---

<div class="post-metadata">

**Author:** ![aishwaryamj](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@aishwaryamj](https://connective.celigo.com/u/aishwaryamj)\
**Post date:** [May 7, 2024, 2:06pm UTC](https://connective.celigo.com/t/only-first-element-included-in-import-data-array/142/3 "2024-05-07T14:06:15Z")

</div>

@tylerlamparter

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.

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [May 7, 2024, 2:16pm UTC](https://connective.celigo.com/t/only-first-element-included-in-import-data-array/142/4 "2024-05-07T14:16:06Z")

</div>

@aishwaryamj do you have this checked by chance?

 ![5301043caa20740200000001-5d4fd5e1f93747518eef00a8b9775776.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/20b935c4cb97c05cadd7cd9332d98f513dd79833.png)

---

<div class="post-metadata">

**Author:** ![aishwaryamj](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@aishwaryamj](https://connective.celigo.com/u/aishwaryamj)\
**Post date:** [May 7, 2024, 3:46pm UTC](https://connective.celigo.com/t/only-first-element-included-in-import-data-array/142/5 "2024-05-07T15:46:32Z")

</div>

@tylerlamparter

No, the Use First Row is not checked in my mapping.

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [May 10, 2024, 1:31am UTC](https://connective.celigo.com/t/only-first-element-included-in-import-data-array/142/6 "2024-05-10T01:31:14Z")

</div>

@aishwaryamj I would submit a support ticket then. I'm not able to reproduce and it's working correctly with my similar setup.

---

<div class="post-metadata">

**Author:** ![aishwaryamj](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@aishwaryamj](https://connective.celigo.com/u/aishwaryamj)\
**Post date:** [May 10, 2024, 8:40am UTC](https://connective.celigo.com/t/only-first-element-included-in-import-data-array/142/7 "2024-05-10T08:40:48Z")

</div>

Hi @tylerlamparter,

Issue is resolved now. Thank you for the help.
