Multiple Lookup based on list of Items
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"
}
}
0
Comments
Adding slack channel link that goes very in depth discussing this issue: https://netsuiteprofessionals.slack.com/archives/CFG7DNCM9/p1682015369032499.
Please sign in to leave a comment.