# NetSuite Import 2.0 Error

**URL:** <https://connective.celigo.com/t/netsuite-import-2-0-error/338>\
**Category:** Integrator.io\
**Tags:** error-handling, import, netsuite\
**Created:** [October 9, 2023, 8:53am UTC](https://connective.celigo.com/t/netsuite-import-2-0-error/338 "2023-10-09T08:53:11Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![vamshireddy](https://avatars.discourse-cdn.com/v4/letter/v/90db22/32.png) [@vamshireddy](https://connective.celigo.com/u/vamshireddy)\
**Post date:** [October 9, 2023, 8:53am UTC](https://connective.celigo.com/t/netsuite-import-2-0-error/338/1 "2023-10-09T08:53:11Z")

</div>

Received the error below I have NetSuite Import Version of 2. x, same import is working in version1.0

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.

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

---

<div class="post-metadata">

**Author:** ![vamshireddy](https://avatars.discourse-cdn.com/v4/letter/v/90db22/32.png) [@vamshireddy](https://connective.celigo.com/u/vamshireddy)\
**Post date:** [October 10, 2023, 6:00am UTC](https://connective.celigo.com/t/netsuite-import-2-0-error/338/2 "2023-10-10T06:00:24Z")

</div>

@tomsantiago Can you help me on this issue.

---

<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:** [October 10, 2023, 9:29am UTC](https://connective.celigo.com/t/netsuite-import-2-0-error/338/3 "2023-10-10T09:29:25Z")

</div>

@vamshireddy I'm moving this post to "Troubleshoot custom flows" for better visibility.

---

<div class="post-metadata">

**Author:** ![dineshshah](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@dineshshah](https://connective.celigo.com/u/dineshshah)\
**Post date:** [October 10, 2023, 11:19am UTC](https://connective.celigo.com/t/netsuite-import-2-0-error/338/4 "2023-10-10T11:19:32Z")

</div>

can you share the zip file of your flow so we can debug the issue

---

<div class="post-metadata">

**Author:** ![vamshireddy](https://avatars.discourse-cdn.com/v4/letter/v/90db22/32.png) [@vamshireddy](https://connective.celigo.com/u/vamshireddy)\
**Post date:** [October 10, 2023, 1:49pm UTC](https://connective.celigo.com/t/netsuite-import-2-0-error/338/5 "2023-10-10T13:49:33Z")

</div>

Hi @dineshshah,

I was not able to share the zip file here.Can I share the JSON data of import.

---

<div class="post-metadata">

**Author:** ![dineshshah](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@dineshshah](https://connective.celigo.com/u/dineshshah)\
**Post date:** [October 11, 2023, 5:30am UTC](https://connective.celigo.com/t/netsuite-import-2-0-error/338/6 "2023-10-11T05:30:13Z")

</div>

Yeah you can share JSON data of import and if you can share zip file on my celigo email then send it there

---

<div class="post-metadata">

**Author:** ![vamshireddy](https://avatars.discourse-cdn.com/v4/letter/v/90db22/32.png) [@vamshireddy](https://connective.celigo.com/u/vamshireddy)\
**Post date:** [October 12, 2023, 12:54pm UTC](https://connective.celigo.com/t/netsuite-import-2-0-error/338/7 "2023-10-12T12:54:45Z")

</div>

{

 "\_id": "64dc87037eadb30a82cc86d2",

 "name": "Create Item Fulfillment Records",

 "mockResponse": [

 {

 "id": "1234567890",

 "errors": [],

 "\_json": {

 "mockResponse": "replace me"

 },

 "statusCode": 200,

 "ignored": false,

 "dataURI": "",

 "\_headers": {

 "content-type": "application/json; charset=utf-8"

 }

 }

 ],

 "\_connectionId": "64d1e8a184c795585accae16",

 "distributed": true,

 "apiIdentifier": "if2ff0c919",

 "ignoreExisting": false,

 "ignoreMissing": false,

 "oneToMany": false,

 "lookups": [

 {

 "name": "so",

 "recordType": "salesorder",

 "resultField": "internalid",

 "expression": "[\"tranid\",\"is\",\"{{{order\_number}}}\"]",

 "allowFailures": false

 },

 {

 "name": "SKU\_lookup",

 "recordType": "item",

 "resultField": "internalid",

 "expression": "[\"nameinternal\",\"is\",\"{{{shipment\_detail[\*].sku\_code}}}\"]",

 "allowFailures": false

 }

 ],

 "netsuite\_da": {

 "restletVersion": "suiteapp2.0",

 "operation": "add",

 "recordType": "itemfulfillment",

 "lookups": [

 {

 "name": "so",

 "recordType": "salesorder",

 "resultField": "internalid",

 "expression": "[\"tranid\",\"is\",\"{{{order\_number}}}\"]",

 "allowFailures": false

 },

 {

 "name": "SKU\_lookup",

 "recordType": "item",

 "resultField": "internalid",

 "expression": "[\"nameinternal\",\"is\",\"{{{shipment\_detail[\*].sku\_code}}}\"]",

 "allowFailures": false

 }

 ],

 "mapping": {

 "fields": [

 {

 "generate": "celigo\_recordmode\_dynamic",

 "hardCodedValue": "true",

 "internalId": false

 },

 {

 "extract": "po\_number",

 "generate": "celigo\_nlobjTransformId",

 "discardIfEmpty": false,

 "immutable": false,

 "lookupName": "so",

 "internalId": true

 },

 {

 "generate": "shipstatus",

 "discardIfEmpty": false,

 "immutable": false,

 "hardCodedValue": "C",

 "internalId": true

 },

 {

 "generate": "celigo\_replaceAllLines\_package",

 "hardCodedValue": "true",

 "internalId": false

 }

 ],

 "lists": [

 {

 "generate": "item",

 "fields": [

 {

 "generate": "itemkey",

 "discardIfEmpty": false,

 "immutable": false,

 "lookupName": "SKU\_lookup",

 "internalId": false

 },

 {

 "generate": "quantity",

 "extract": "shipment\_detail[\*].qty\_shipped",

 "internalId": false

 },

 {

 "generate": "itemreceive",

 "hardCodedValue": "true",

 "internalId": false

 },

 {

 "generate": "isLotItem",

 "internalId": false,

 "discardIfEmpty": false,

 "immutable": false,

 "hardCodedValue": "true"

 },

 {

 "generate": "lotdetails",

 "extract": "shipment\_detail[\*].lots",

 "internalId": false

 }

 ]

 },

 {

 "generate": "package",

 "fields": [

 {

 "generate": "packagetrackingnumber",

 "extract": "tracking\_number",

 "internalId": false

 },

 {

 "generate": "packageweight",

 "hardCodedValue": "0.01",

 "internalId": false

 }

 ]

 }

 ]

 },

 "hooks": {

 "postMap": {

 "fileInternalId": "8154",

 "function": "itemLotNumbersImport"

 }

 }

 },

 "filter": {

 "type": "expression",

 "expression": {

 "rules": [

 "equals",

 [

 "string",

 [

 "extract",

 "bill\_of\_lading\_number"

 ]

 ],

 "12345678"

 ],

 "version": "1"

 },

 "rules": [

 "equals",

 [

 "string",

 [

 "extract",

 "bill\_of\_lading\_number"

 ]

 ],

 "12345678"

 ],

 "version": "1"

 },

 "adaptorType": "NetSuiteDistributedImport"

}