# You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist

**URL:** <https://connective.celigo.com/t/you-have-attempted-an-invalid-sublist-or-line-item-operation-you-are-either-trying-to-access-a-field-on-a-non-existent-line-or-you-are-trying-to-add-or-remove-lines-from-a-static-sublist/778>\
**Category:** Integrator.io\
**Tags:** data-loader, error-handling, json, netsuite\
**Created:** [May 5, 2022, 10:35am UTC](https://connective.celigo.com/t/you-have-attempted-an-invalid-sublist-or-line-item-operation-you-are-either-trying-to-access-a-field-on-a-non-existent-line-or-you-are-trying-to-add-or-remove-lines-from-a-static-sublist/778 "2022-05-05T10:35:53Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rhysgottwald](https://avatars.discourse-cdn.com/v4/letter/r/7993a0/32.png) [@rhysgottwald](https://connective.celigo.com/u/rhysgottwald)\
**Post date:** [May 5, 2022, 10:35am UTC](https://connective.celigo.com/t/you-have-attempted-an-invalid-sublist-or-line-item-operation-you-are-either-trying-to-access-a-field-on-a-non-existent-line-or-you-are-trying-to-add-or-remove-lines-from-a-static-sublist/778/1 "2022-05-05T10:35:53Z")

</div>

I am trying to import an Assembly Build in to NetSuite From a JSON file via the data loader. I have followed the instructions at [https://docs.celigo.com/hc/en-us/articles/360016510891-Configure-and-map-NetSuite-subrecords#tutorial-b](https://docs.celigo.com/hc/en-us/articles/360016510891-Configure-and-map-NetSuite-subrecords#tutorial-b) and mapped the fields accordingly

But I keep getting the error

"Failed to create, update/transform record because You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist. Tip: Please make sure that all the line items that you're trying to use exist on the record."  
  
I assume that this is because I am "technically" adding a component line to the work which I use to link and add the Component details.

So my question is, how do I add component details to and assembly with out adding a component line

---

<div class="post-metadata">

**Author:** ![anithaabraham](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/anithaabraham/32/6964_2.png) [@anithaabraham](https://connective.celigo.com/u/anithaabraham)\
**Post date:** [May 5, 2022, 5:26pm UTC](https://connective.celigo.com/t/you-have-attempted-an-invalid-sublist-or-line-item-operation-you-are-either-trying-to-access-a-field-on-a-non-existent-line-or-you-are-trying-to-add-or-remove-lines-from-a-static-sublist/778/2 "2022-05-05T17:26:31Z")

</div>

Rhys,

It looks like you're working with our Support team on this, which is great since they can look into your error. I'll also follow that ticket and check with some others internally to share any additional insights here.

In the meantime, you could check out this [post](https://connective.celigo.com/t/customer-payments-import/1217) which has the same error.

Thanks!

---

<div class="post-metadata">

**Author:** ![sachingoud87](https://avatars.discourse-cdn.com/v4/letter/s/a587f6/32.png) [@sachingoud87](https://connective.celigo.com/u/sachingoud87)\
**Post date:** [May 10, 2022, 9:36am UTC](https://connective.celigo.com/t/you-have-attempted-an-invalid-sublist-or-line-item-operation-you-are-either-trying-to-access-a-field-on-a-non-existent-line-or-you-are-trying-to-add-or-remove-lines-from-a-static-sublist/778/3 "2022-05-10T09:36:47Z")

</div>

Hi Rhys,

I've attached an example import configuration's screenshots to create an assembly build from assembly item. Please go through it and try similar for your import and do let us know if you need more help.

Sample export data in JSON:

```
    { "item_name": "AMCM Assembly", "subsidiary_name": "Honeycomb Holdings Inc.", "quantity": "3", "location_name": "Hyderabad", "inventorydetail": { "inv_detail": [{ "serialLotNumber": "1", "quantity": "1" }, { "serialLotNumber": "2", "quantity": "1" }, { "serialLotNumber": "3", "quantity": "1" }] }, "components": [{ "item_name": "Arctic Monkeys Coffee Mug", "item_id": "6941", "quantity": "9", "inv_detail": [ { "bin_name": "420", "quantity": "4" }, { "bin_name": "69", "quantity": "5" }] } ] }
```

Subrecord path configuration for inventory detail subrecord (body level subrecord)

 ![5301043caa20740200000001-084158f2eba04a119fa4ef4a96951c02.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/344fba37e5ebf4f136a5d86437991752a553ba29.png)

Subrecord path configuration for inventory detail subrecord (line item subrecord):

 ![5301043caa20740200000001-55ba5179c8174b0eb12b106e97fc2112.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/f/f0a685af8cc868ff7326f9d224d34d731da853f2.png)

Main mappings:

NOTE: **component[\*].item** should be manually typed

 ![5301043caa20740200000001-69a246a291dc495bbe125aed4bead8a3.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/a/ae551cba1e4ddc54bdfa76c0b6407bbf67c6b292.png)

Click the gear icon beside **component[\*].item** and check the box as shown below:

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

 

Subrecord mappings for body level subrecord field:

 ![5301043caa20740200000001-34c68fd51f6648759a9e7de99dfea763.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/324a171cd674bd376615b58284c3e57b87030aa0.png)

Subrecord mappings for line level subrecord field:

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

---

<div class="post-metadata">

**Author:** ![rhysgottwald](https://avatars.discourse-cdn.com/v4/letter/r/7993a0/32.png) [@rhysgottwald](https://connective.celigo.com/u/rhysgottwald)\
**Post date:** [May 12, 2022, 7:53am UTC](https://connective.celigo.com/t/you-have-attempted-an-invalid-sublist-or-line-item-operation-you-are-either-trying-to-access-a-field-on-a-non-existent-line-or-you-are-trying-to-add-or-remove-lines-from-a-static-sublist/778/4 "2022-05-12T07:53:00Z")

</div>

Thank you @sachingoud87

This worked for me, just one typo **component[\*].item** should be **components[\*].item**

---

<div class="post-metadata">

**Author:** ![sachingoud87](https://avatars.discourse-cdn.com/v4/letter/s/a587f6/32.png) [@sachingoud87](https://connective.celigo.com/u/sachingoud87)\
**Post date:** [May 12, 2022, 1:57pm UTC](https://connective.celigo.com/t/you-have-attempted-an-invalid-sublist-or-line-item-operation-you-are-either-trying-to-access-a-field-on-a-non-existent-line-or-you-are-trying-to-add-or-remove-lines-from-a-static-sublist/778/5 "2022-05-12T13:57:49Z")

</div>

Hi Rhys, glad to hear that you're able to get it to work.

May I know what error were you facing with **component[\*].item,** because I'm fairly certain that it is not a typo.

---

<div class="post-metadata">

**Author:** ![rhysgottwald](https://avatars.discourse-cdn.com/v4/letter/r/7993a0/32.png) [@rhysgottwald](https://connective.celigo.com/u/rhysgottwald)\
**Post date:** [May 13, 2022, 5:51am UTC](https://connective.celigo.com/t/you-have-attempted-an-invalid-sublist-or-line-item-operation-you-are-either-trying-to-access-a-field-on-a-non-existent-line-or-you-are-trying-to-add-or-remove-lines-from-a-static-sublist/778/6 "2022-05-13T05:51:39Z")

</div>

HI Godishela,

I just noticed that it was referred to as **Components : Inventory Details** in the sub record mapping so I changed it from **component[\*].item** to **components[\*].item**. I don't think I actually tried it as **component**
