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

[rhysgottwald]

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

[anithaabraham]

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 which has the same error.

Thanks!

[sachingoud (Sachin Goud Godishela)]

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)

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

Main mappings:

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

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

Subrecord mappings for body level subrecord field:

Subrecord mappings for line level subrecord field:

[rhysgottwald]

Thank you @sachingoud

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

[sachingoud (Sachin Goud Godishela)]

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.

[rhysgottwald]

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