Multiple Lookup based on list of Items

Integrator.io
,
1

Hi all,
I need assistant on how to do a look up step on my array "line_items" for each item.
I need to be able to pull serial lot from Netsuite base on each item sku.

Input:

{
  "exportId": 101010101,
  "order_number": "10",
  "line_items": [
    {
      "sku": "Sku1",
      "quantity": 1
    },
    {
      "sku": "Sku2",
      "quantity": 1
    }
  ],
  "shippingInfo": {
    "tracking_number": "101010101",
    "carrier": "shippo__usps",
    "tracking_url": "https://tools.usps.com/go/TrackConfirmAction_input?strOrigTrackNum=101010101",
    "created_date": "2023-04-19T22:23:25"
  }
}


Output should be:

{
"shipheroShipmentId": 101010101,
"order_number": "10",
"line_items": [
{
"sku": "Sku1",
"quantity": 1,
"serialLot" : "Lot123"
},
{
"sku": "Sku2",
"quantity": 1,
"serialLot" : "Lot456"
}
],
"shippingInfo": {
"tracking_number": "101010101",
"carrier": "shippo__usps",
"tracking_url": "https://tools.usps.com/go/TrackConfirmAction_input?strOrigTrackNum=101010101",
"created_date": "2023-04-19T22:23:25"
}
}

2

Adding slack channel link that goes very in depth discussing this issue: https://netsuiteprofessionals.slack.com/archives/CFG7DNCM9/p1682015369032499.