@jackharris if you copy the input of the test run and put it in the input of the script preview, does it work there? Can you provide script and both inputs as well if it is working in preview?
I tried using the AI Query you used and this was my result.
Code:
function preMap(options) {
return options.data.map((d) => {
let counter = 1;
d.HLS.forEach((hls) => {
hls['Hierarchical ID Number'] = counter;
counter++;
hls.HLO.forEach((hlo) => {
hlo['Hierarchical ID Number'] = counter;
hlo['Hierarchical Shipment Parent ID Number'] = hls['Hierarchical ID Number'];
counter++;
hlo.HLP.forEach((hlp) => {
hlp['Hierarchical ID Number'] = counter;
hlp['Hierarchical Shipment Parent ID Number'] = hlo['Hierarchical ID Number'];
counter++;
});
});
});
return {
data: d
};
});
}Function Input
{
"data": [
{
"ISA": {
"Interchange Date": "240212",
"Interchange Time": "1115",
"Interchange Control Number": "360585344",
"GS": {
"Date the EDI was created": "240212",
"Time": "1115",
"Group Control Number": "248",
"ST": {
"Transaction Set Purpose Code": "00",
"Shipment Identification": "2090416",
"Date": "20240117",
"Hierarchical Structure Code": "0001",
"HLS": [
{
"Hierarchical Level Code": "S",
"TD1": {
"Packaging Code": "CTN",
"Lading Quantity": "800",
"Weight Qualifier": "G",
"Weight": "32400.0",
"Unit or Basis for Measurement": "LB"
},
"TD5": {
"Routing Sequence Code": "B",
"Identification Code Qualifier": "2",
"Identification Code": "CPU",
"Transportation Method/Type Code": "H",
"Routing": "CUSTOMER PICK-UP"
},
"REF": {
"Reference Identification Qualifier": "BM",
"Reference Identification": "2090416"
},
"DTM": [
{
"Date/Time Qualifier": "02",
"Date": "20240118"
},
{
"Date/Time Qualifier": "10",
"Date": "20240117"
},
{
"Date/Time Qualifier": "52",
"Date": "20231211"
}
],
"N1": [
{
"Entity Identity Qualifier": "WH",
"Name": "Distribution Technology"
},
{
"Entity Identity Qualifier": "DE",
"Name": "MARIO CAMACHO FOODS"
},
{
"Entity Identity Qualifier": "ST",
"Name": "PROGRESSIVE FOOD SOLUTIONS LLC",
"Identification Code Qualifier": "91",
"Identification Code": "PRO8603006"
}
],
"N4": {
"City": "MARIETTA",
"State": "GA",
"Zip": "30062"
},
"HLO": [
{
"Hierarchical Level Code": "O",
"PRF": {
"Purchase Order Number": "VEGGA00000"
},
"HLP": [
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "1",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"SN1": {
"Number of Units Shipped": 1,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA"
},
"SN1": {
"Number of Units Shipped": "39",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"SN1": {
"Number of Units Shipped": 39,
"Unit or Basis for Measure Code": "CA"
}
}
]
}
]
}
]
}
]
}
}
}
}
],
"files": [
{
"fileMeta": {
"fileName": "sampleFileName",
"fileSize": 1234
}
}
],
"errors": [],
"_exportId": "65aa7365b5be9c01ee47e559",
"_connectionId": "65b93733ca96162a2573ab35",
"_flowId": "65a69c26c89f91203021cbc4",
"_integrationId": "65a6991cc89f91203021cb02",
"pageIndex": 0,
"settings": {
"integration": {},
"flowGrouping": {},
"flow": {},
"export": {},
"connection": {}
},
"testMode": true
}
Mock Output from the Export
{
"page_of_records": [
{
"record": {
"HeaderInformation": [
{
"CODE CLIENT": "MAR08"
},
{
"TRXSet": "945"
},
{
"ROUTE": "MAR08"
},
{
"COMPANY": "W1"
}
],
"ReferenceInformation": [
{
"ReportingCode": "F",
"DepositorOrderNumber": "263738",
"Date": "20240117",
"ShipmentID": "2090416",
"PurchaseOrderNumber": " VEGGA00000",
"AlternateReference1": "27864",
"LoadNumber": "",
"SpecialHandlingCode": "",
"ReasonCode": "",
"TransactionTypeCode": "",
"ActionCode": "",
"AlternateReference2": "",
"Reference1": "",
"Reference2": " 945Q/DOM",
"Reference3": "INO",
"Names": [
{
"OrganizationIDCode": "WH",
"name": "Distribution Technology"
},
{
"OrganizationIDCode": "DE",
"name": "MARIO CAMACHO FOODS"
},
{
"OrganizationIDCode": "ST",
"name": "PROGRESSIVE FOOD SOLUTIONS LLC",
"IDType": "91",
"EntityCode": "PRO8603006"
}
],
"Address1": "REDIRECT CENTER 860 P",
"Address2": "ICKENS INDUSTRIAL DRIVE",
"City": "MARIETTA",
"State": "GA",
"Zip": "30062",
"DateTimes": [
{
"DateQualifier": "02",
"date": "20240118"
},
{
"DateQualifier": "10",
"date": "20240117"
},
{
"DateQualifier": "52",
"date": "20231211"
}
],
"TransportationMethod": "H",
"SCAC": "CPU",
"Routing": "CUSTOMER PICK-UP",
"MethodofPayment": "CC"
}
],
"LineInformation": [
{
"AssignedNumber": "000001",
"SSCC18": "00007291482000252297",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP062026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260906"
},
{
"AssignedNumber": "000002",
"SSCC18": "00007291482000252303",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP062026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260906"
},
{
"AssignedNumber": "000003",
"SSCC18": "00007291482000252310",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP062026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260906"
},
{
"AssignedNumber": "000004",
"SSCC18": "00007291482000252327",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000005",
"SSCC18": "00007291482000252334",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000006",
"SSCC18": "00007291482000252341",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000007",
"SSCC18": "00007291482000252358",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000008",
"SSCC18": "00007291482000252365",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000009",
"SSCC18": "00007291482000252372",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000010",
"SSCC18": "00007291482000252389",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000011",
"SSCC18": "00007291482000252396",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000012",
"SSCC18": "00007291482000252402",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000013",
"SSCC18": "00007291482000252419",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000014",
"SSCC18": "00007291482000252426",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000015",
"SSCC18": "00007291482000252433",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000016",
"SSCC18": "00007291482000252440",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000017",
"SSCC18": "00007291482000252457",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000018",
"SSCC18": "00007291482000252464",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000019",
"SSCC18": "00007291482000252471",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "40",
"ShippedQuantity": "40",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
},
{
"AssignedNumber": "000020",
"SSCC18": "00007291482000252488",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "1",
"ShippedQuantity": "1",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP062026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260906"
},
{
"AssignedNumber": "000021",
"SSCC18": "00007291482000252488",
"Description": "RIPE SLICED REDUCED BRINE",
"OrderStatusCode": "CC",
"OrderedQuantity": "39",
"ShippedQuantity": "39",
"QuantityDifference": "0",
"UOM": "CA",
"UPC": "",
"VN": "VN",
"Item": "7365171058-CT",
"Lot": "SEP042026",
"ReferenceQualifier": "ZZ",
"ReferenceID": "1",
"ExpiryQualifer": "36",
"ExpirationDate": "20260904"
}
],
"NumberofUnitsShipped": "800",
"TotalWeight": "32400.0",
"UOM": "LB"
}
}
]
}After the transformation
{
"ISA": {
"Interchange Date": "240214",
"Interchange Time": "1141",
"Interchange Control Number": "859377344",
"GS": {
"Date the EDI was created": "240214",
"Time": "1141",
"Group Control Number": "401",
"ST": {
"Transaction Set Purpose Code": "00",
"Shipment Identification": "2090416",
"Date": "20240117",
"Hierarchical Structure Code": "0001",
"HLS": [
{
"Hierarchical Level Code": "S",
"TD1": {
"Packaging Code": "CTN",
"Lading Quantity": "800",
"Weight Qualifier": "G",
"Weight": "32400.0",
"Unit or Basis for Measurement": "LB"
},
"TD5": {
"Routing Sequence Code": "B",
"Identification Code Qualifier": "2",
"Identification Code": "CPU",
"Transportation Method/Type Code": "H",
"Routing": "CUSTOMER PICK-UP"
},
"REF": {
"Reference Identification Qualifier": "BM",
"Reference Identification": "2090416"
},
"DTM": [
{
"Date/Time Qualifier": "02",
"Date": "20240118"
},
{
"Date/Time Qualifier": "10",
"Date": "20240117"
},
{
"Date/Time Qualifier": "52",
"Date": "20231211"
}
],
"N1": [
{
"Entity Identity Qualifier": "WH",
"Name": "Distribution Technology"
},
{
"Entity Identity Qualifier": "DE",
"Name": "MARIO CAMACHO FOODS"
},
{
"Entity Identity Qualifier": "ST",
"Name": "PROGRESSIVE FOOD SOLUTIONS LLC",
"Identification Code Qualifier": "91",
"Identification Code": "PRO8603006"
}
],
"N4": {
"City": "MARIETTA",
"State": "GA",
"Zip": "30062"
},
"HLO": [
{
"Hierarchical Level Code": "O",
"PRF": {
"Purchase Order Number": "VEGGA00000",
"HLP": [
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "1",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 1,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "39",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 39,
"Unit or Basis for Measure Code": "CA"
}
}
]
}
]
}
}
]
}
]
}
}
}
}Script
function preMap(options) {
return options.data.map((d) => {
let counter = 1;
d.ISA.GS.ST.HLS.forEach((hls) => {
hls['Hierarchical ID Number'] = counter;
counter++;
hls.HLO.forEach((hlo) => {
hlo['Hierarchical ID Number'] = counter;
hlo['Hierarchical Shipment Parent ID Number'] = hls['Hierarchical ID Number'];
counter++;
hlo.PRF.HLP.forEach((hlp) => {
hlp['Hierarchical ID Number'] = counter;
hlp['Hierarchical Shipment Parent ID Number'] = hlo['Hierarchical ID Number'];
counter++;
hlp.HLI.forEach((hli) => {
hli['Hierarchical ID Number'] = counter;
hli['Hierarchicial Shipment Parent ID Number'] = hlp['Hierarchical ID Number'];
counter++;
}
)
});
});
});
return {
data: d
};
});
}Script Output in the preview
[
{
"data": {
"ISA": {
"Interchange Date": "240214",
"Interchange Time": "1142",
"Interchange Control Number": "126576774",
"GS": {
"Date the EDI was created": "240214",
"Time": "1142",
"Group Control Number": "351",
"ST": {
"Transaction Set Purpose Code": "00",
"Shipment Identification": "2090416",
"Date": "20240117",
"Hierarchical Structure Code": "0001",
"HLS": [
{
"Hierarchical Level Code": "S",
"TD1": {
"Packaging Code": "CTN",
"Lading Quantity": "800",
"Weight Qualifier": "G",
"Weight": "32400.0",
"Unit or Basis for Measurement": "LB"
},
"TD5": {
"Routing Sequence Code": "B",
"Identification Code Qualifier": "2",
"Identification Code": "CPU",
"Transportation Method/Type Code": "H",
"Routing": "CUSTOMER PICK-UP"
},
"REF": {
"Reference Identification Qualifier": "BM",
"Reference Identification": "2090416"
},
"DTM": [
{
"Date/Time Qualifier": "02",
"Date": "20240118"
},
{
"Date/Time Qualifier": "10",
"Date": "20240117"
},
{
"Date/Time Qualifier": "52",
"Date": "20231211"
}
],
"N1": [
{
"Entity Identity Qualifier": "WH",
"Name": "Distribution Technology"
},
{
"Entity Identity Qualifier": "DE",
"Name": "MARIO CAMACHO FOODS"
},
{
"Entity Identity Qualifier": "ST",
"Name": "PROGRESSIVE FOOD SOLUTIONS LLC",
"Identification Code Qualifier": "91",
"Identification Code": "PRO8603006"
}
],
"N4": {
"City": "MARIETTA",
"State": "GA",
"Zip": "30062"
},
"HLO": [
{
"Hierarchical Level Code": "O",
"PRF": {
"Purchase Order Number": "VEGGA00000",
"HLP": [
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 4,
"Hierarchicial Shipment Parent ID Number": 3
}
],
"Hierarchical ID Number": 3,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 6,
"Hierarchicial Shipment Parent ID Number": 5
}
],
"Hierarchical ID Number": 5,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 8,
"Hierarchicial Shipment Parent ID Number": 7
}
],
"Hierarchical ID Number": 7,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 10,
"Hierarchicial Shipment Parent ID Number": 9
}
],
"Hierarchical ID Number": 9,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 12,
"Hierarchicial Shipment Parent ID Number": 11
}
],
"Hierarchical ID Number": 11,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 14,
"Hierarchicial Shipment Parent ID Number": 13
}
],
"Hierarchical ID Number": 13,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 16,
"Hierarchicial Shipment Parent ID Number": 15
}
],
"Hierarchical ID Number": 15,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 18,
"Hierarchicial Shipment Parent ID Number": 17
}
],
"Hierarchical ID Number": 17,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 20,
"Hierarchicial Shipment Parent ID Number": 19
}
],
"Hierarchical ID Number": 19,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 22,
"Hierarchicial Shipment Parent ID Number": 21
}
],
"Hierarchical ID Number": 21,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 24,
"Hierarchicial Shipment Parent ID Number": 23
}
],
"Hierarchical ID Number": 23,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 26,
"Hierarchicial Shipment Parent ID Number": 25
}
],
"Hierarchical ID Number": 25,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 28,
"Hierarchicial Shipment Parent ID Number": 27
}
],
"Hierarchical ID Number": 27,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 30,
"Hierarchicial Shipment Parent ID Number": 29
}
],
"Hierarchical ID Number": 29,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 32,
"Hierarchicial Shipment Parent ID Number": 31
}
],
"Hierarchical ID Number": 31,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 34,
"Hierarchicial Shipment Parent ID Number": 33
}
],
"Hierarchical ID Number": 33,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 36,
"Hierarchicial Shipment Parent ID Number": 35
}
],
"Hierarchical ID Number": 35,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 38,
"Hierarchicial Shipment Parent ID Number": 37
}
],
"Hierarchical ID Number": 37,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 40,
"Hierarchicial Shipment Parent ID Number": 39
}
],
"Hierarchical ID Number": 39,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "1",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 1,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 42,
"Hierarchicial Shipment Parent ID Number": 41
}
],
"Hierarchical ID Number": 41,
"Hierarchical Shipment Parent ID Number": 2
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "39",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 39,
"Unit or Basis for Measure Code": "CA"
},
"Hierarchical ID Number": 44,
"Hierarchicial Shipment Parent ID Number": 43
}
],
"Hierarchical ID Number": 43,
"Hierarchical Shipment Parent ID Number": 2
}
]
},
"Hierarchical ID Number": 2,
"Hierarchical Shipment Parent ID Number": 1
}
],
"Hierarchical ID Number": 1
}
]
}
}
}
}
}
]Function Input
{
"data": [
{
"ISA": {
"Interchange Date": "240214",
"Interchange Time": "1143",
"Interchange Control Number": "987045524",
"GS": {
"Date the EDI was created": "240214",
"Time": "1143",
"Group Control Number": "689",
"ST": {
"Transaction Set Purpose Code": "00",
"Shipment Identification": "2090416",
"Date": "20240117",
"Hierarchical Structure Code": "0001",
"HLS": [
{
"Hierarchical Level Code": "S",
"TD1": {
"Packaging Code": "CTN",
"Lading Quantity": "800",
"Weight Qualifier": "G",
"Weight": "32400.0",
"Unit or Basis for Measurement": "LB"
},
"TD5": {
"Routing Sequence Code": "B",
"Identification Code Qualifier": "2",
"Identification Code": "CPU",
"Transportation Method/Type Code": "H",
"Routing": "CUSTOMER PICK-UP"
},
"REF": {
"Reference Identification Qualifier": "BM",
"Reference Identification": "2090416"
},
"DTM": [
{
"Date/Time Qualifier": "02",
"Date": "20240118"
},
{
"Date/Time Qualifier": "10",
"Date": "20240117"
},
{
"Date/Time Qualifier": "52",
"Date": "20231211"
}
],
"N1": [
{
"Entity Identity Qualifier": "WH",
"Name": "Distribution Technology"
},
{
"Entity Identity Qualifier": "DE",
"Name": "MARIO CAMACHO FOODS"
},
{
"Entity Identity Qualifier": "ST",
"Name": "PROGRESSIVE FOOD SOLUTIONS LLC",
"Identification Code Qualifier": "91",
"Identification Code": "PRO8603006"
}
],
"N4": {
"City": "MARIETTA",
"State": "GA",
"Zip": "30062"
},
"HLO": [
{
"Hierarchical Level Code": "O",
"PRF": {
"Purchase Order Number": "VEGGA00000",
"HLP": [
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "40",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 40,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "1",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260906"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP062026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 1,
"Unit or Basis for Measure Code": "CA"
}
}
]
},
{
"Hierarchical Level Code": "P",
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT"
},
"SN1": {
"Number of Units Shipped": "39",
"Unit or Basis for Measure Code": "CA"
},
"DTM": {
"Date/Time Qualifier": "36",
"Date": "20260904"
},
"HLI": [
{
"LIN": {
"Product/Service ID Qualifier": "UA",
"Product/Service ID": "7365171058-CT",
"Product/Service ID Qualifier (LIN03)": "LT",
"Product/Service ID (LIN04)": "SEP042026"
},
"Hierarchical Level Code": "I",
"SN1": {
"Number of Units Shipped": 39,
"Unit or Basis for Measure Code": "CA"
}
}
]
}
]
}
}
]
}
]
}
}
}
}
],
"errors": [],
"files": [],
"pageIndex": 0,
"_exportId": "65aa7365b5be9c01ee47e559",
"_connectionId": "65b93733ca96162a2573ab35",
"_flowId": "65a69c26c89f91203021cbc4",
"_integrationId": "65a6991cc89f91203021cb02",
"settings": {
"integration": {},
"flowGrouping": {},
"flow": {},
"export": {},
"connection": {}
},
"testMode": true
}Function Output
{
"data": [],
"errors": []
}