NetSuite Import 2.0 Error

Integrator.io
, ,
1

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
5301043caa20740200000001-b45dfc0714f24ae4b58f8f97a545b0b8.png1187×559 65.1 KB

2

@tomsantiago Can you help me on this issue.

3

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

4

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

5

Hi @dineshshah,

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

6

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

7
{
"_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"
}