Pulling data out of an element in an array

Integrator.io
,
1

Here's my data

 "LineInformation": [
      {
        "AssignedNumber": "000001",
        "itemDetail": [
          {
            "orderstatus": "CC",
            "OrderedQuantity": "112",
            "ShippedQuantity": "112",
            "QuantityDifference": "0",
            "UOM": "CA",
            "UPCCaseCode": "002110001505",
            "QualifierVN": "VN",
            "ItemNumber": "01505",
            "Lot": "L/03698P",
            "NetWgt": "840.00",
            "NetWgtQ": "N",
            "NetWgtU": "L",
            "GrsWgt": "840.0",
            "GrsWgtQ": "G",
            "GrsWgtU": "L",
            "UPC2": "",
            "QualifierPD": "",
            "InventoryLevel3": "",
            "LineChangeReasonCode": "",
            "WhseDtAdjID": "",
            "QualifierZZ": "",
            "InventoryLevel4": "",
            "ReasonCode": "",
            "ExpiryDate": "",
            "Level2": "20270830",
            "ItemDescription": "12/7.5OZ DBLQ RED USA-WILD",
            "AlternateItemDesc": "",
            "ExtendedDesc": ""
          },
          {
            "orderstatus": "CC",
            "OrderedQuantity": "243",
            "ShippedQuantity": "243",
            "QuantityDifference": "0",
            "UOM": "CA",
            "UPCCaseCode": "002110002514",
            "QualifierVN": "VN",
            "ItemNumber": "02514",
            "Lot": "2400A512",
            "NetWgt": "6439.50",
            "NetWgtQ": "N",
            "NetWgtU": "L",
            "GrsWgt": "6439.5",
            "GrsWgtQ": "G",
            "GrsWgtU": "L",
            "UPC2": "",
            "QualifierPD": "",
            "InventoryLevel3": "",
            "LineChangeReasonCode": "",
            "WhseDtAdjID": "",
            "QualifierZZ": "",
            "InventoryLevel4": "",
            "ReasonCode": "",
            "ExpiryDate": "",
            "Level2": "20280830",
            "ItemDescription": "24/14.75OZ DBLQ PINK USA-WILD",
            "AlternateItemDesc": "",
            "ExtendedDesc": ""
          }
        ]
      }
    ],

The Shipped Quantity is the number of Eaches and I'm attempting to calculate the number of Cases. The conversion factor is the part of the ItemDescription before the /.

I tried to get the substring of ItemDescription to do the math part in a separate step, but I'm having trouble getting just one value per iteration.

Can someone help me find a way to accomplish this?

2

@jackharris I usually have good success with Celigo AI on things like this. Here is what it made and here is my prompt. Just be fairly specific on the ask and see what it comes up with.

Prompt:

I need to calculate the number of cases for each item detail. To do so, I need the shipped quantity which is the number of eaches and the conversion factor is the set of numbers before the first slash in the itemdescription. Can you help out?

Code:

function preSavePage (options) {
  options.data.forEach(record => {
    record.LineInformation.forEach(line => {
      line.itemDetail.forEach(item => {
        const conversionFactor = parseInt(item.ItemDescription.split('/')[0], 10);
        const shippedQuantity = parseInt(item.ShippedQuantity, 10);
        item.NumberOfCases = shippedQuantity / conversionFactor;
      });
    });
  });

  return {
    data: options.data,
    errors: options.errors,
    abort: false,
    newErrorsAndRetryData: []
  };
}

5301043caa20740200000001-3a1a650d5aab4eb6b5888ebafebc1c94.png
5301043caa20740200000001-3a1a650d5aab4eb6b5888ebafebc1c94.png2388×1227 125 KB

3

Thank you,

I've had hit-or-miss results with the AI, but it worked out this time. Thank you for the assistance!