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

Answered

Rhys Gottwald

• May 05, 2022 10:35

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

0

• 

  Anitha Abraham Community moderator Principal Technical Writer

  • May 05, 2022 17:26

  

  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!

  0
• 

  Sachin Goud Godishela Software Engineer

  • May 10, 2022 09:36

  

  

  

  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:

  

   

  0
• 

  Rhys Gottwald

  • May 12, 2022 07:53

  

  

  Thank you Sachin Goud Godishela

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

  0
• 

  Sachin Goud Godishela Software Engineer

  • May 12, 2022 14:04
  • Edited

  

  

  

  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.

  0
• 

  Rhys Gottwald

  • May 13, 2022 05:51

  

  

  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

  0

Please sign in to leave a comment.