# Multiple Lookup based on list of Items

**URL:** <https://connective.celigo.com/t/multiple-lookup-based-on-list-of-items/475>\
**Category:** Integrator.io\
**Tags:** lookup, netsuite\
**Created:** [April 20, 2023, 6:23pm UTC](https://connective.celigo.com/t/multiple-lookup-based-on-list-of-items/475 "2023-04-20T18:23:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![weifengyang](https://avatars.discourse-cdn.com/v4/letter/w/848f3c/32.png) [@weifengyang](https://connective.celigo.com/u/weifengyang)\
**Post date:** [April 20, 2023, 6:23pm UTC](https://connective.celigo.com/t/multiple-lookup-based-on-list-of-items/475/1 "2023-04-20T18:23:04Z")

</div>

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](https://tools.usps.com/go/TrackConfirmAction_input?strOrigTrackNum=101010101)",  
> "created\_date": "2023-04-19T22:23:25"  
> }  
> }

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [May 4, 2023, 3:17pm UTC](https://connective.celigo.com/t/multiple-lookup-based-on-list-of-items/475/2 "2023-05-04T15:17:27Z")

</div>

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