NetSuite Item Fulfillment
Hi Team,
I am working with a pipeline to grab a Item Fulfillment record under one subsidiary and then transitioning that IF to a new IF in the other. It is a 1 for 1 transaction on our side, so the...
Forum Discussion
I am still seeming to have issues getting the Inventory detail in. i have added the additional mapper at the inventory Assignment level, however when I go to run it gives an error that no items are added. You will see on the EU Items mapper we get all the inventory detail on the input data but the output turns it to ‘null’, seemingly giving me the error. Is the detail mapper in the wrong spot in the pipeline? Let me know as we are so close on this!!
Truncated last line: sl.ensureArray($.get([‘tranSales:inventoryDetail’]))
Sorry, I just saw your last reply.
I think I see the problem. The inventoryDetail is not supposed to be an array. It can be null, but if it’s not, it should be an object. The object contains an array at the subpath inventoryAssignmentList.inventoryAssignment. So I think you need to handle it being null by providing a default value that adheres to that structure, using an expression like this:
sl.ensureArray($.get(‘tranSales:inventoryDetail’, {'inventoryAssignmentList': {'inventoryAssignment': []}))
I’m not certain that’s right, but give it a shot.
Patrick,
So I have tried this and I am still getting an error that it worked for 1 document not failed on 2 and others. I spoke with your team yesterday and I was advised to check the ‘Null - Safe Mode’ box to base items that return null in the code. This seem to work and I was getting a ‘empty string’ error at the create function. In attempting to research this I found that when my inventory detail reaches an array quantity, (so a quantity more than 1) then it passes the value as ‘Null’ but if the value is just 1 it works down the list and provides all the data I need. I attempted to use the sl.ensureArray([‘platformCommon:quantity’]) and I got new error that it did not like the number format on the first line of [“1.0”]. I think if we find a solution for the Array values then we will be able to create. I have provided the picture if when the values are passed as Null with the safe mode checked on the inventory detail mapper.
Quantity 1
Quantity 4
Error
Detail Error Log:
Here is the error to your code you provided.
Could not compile expression: sl.ensureArray($.get([‘tranSal … (Reason: Invalid token: ‘‘’ for expression: sl.ensureArray($.get([‘tranSal …; Resolution: Please check expression syntax)
Oops, I initially posted the expression without using a Preformatted Text block and the editor mangled my quotes. Try this:
sl.ensureArray($.get('tranSales:inventoryDetail', {'inventoryAssignmentList': {'inventoryAssignment': []}))
Patrick,
Have you seen this error before?
I did the following and got a new error $.get(‘tranSales:inventoryDetail’)
Progress!!!
No, I can’t make sense of that without more context.
The following seemed to work alot better.
sl.ensureArray($.get(‘tranSales:inventoryDetail’))
However I am getting an error that says we cannot add a ‘inventory detail to this line’. What is happening is that even if the inventory detail does not exist it is adding it to the record as ‘null’ however netsuite does not want it added in the item list at all. See output stream below. I attempted to go back to the root mapper and add a ‘if/then’ statement but it just loops. Take a look and let me know if I am on the right track or if there is another way to exclude the ‘inventory detail’ when inventory detail does not exist in the item tree.
jsonPath($, “[‘soapenv:Body’].getResponse.readResponse.record[‘tranSales:itemList’][‘tranSales:item’][].hasOwnProperty(“tranSales:inventoryDetaill”) ? sl.ensureArray(jsonPath($, "[‘soapenv:Body’].getResponse.readResponse.record[‘tranSales:itemList’][‘tranSales:item’][][‘tranSales:inventoryDetail’][‘platformCommon:inventoryAssignmentList’][‘platformCommon:inventoryAssignment’]”)) : jsonPath($, "[‘soapenv:Body’].getResponse.readResponse.record[‘tranSales:itemList’][‘tranSales:item’][*]
(Note: if I place ‘null’ as the else then it places all of them as null)
