JSLT Help: Combine 2 nodes from JSON Input

[naggupta]

I'm trying to get a list of all stock items along with their corresponding product details. Can anyone help me with this?

Here’s the sample input I'm working with:

{
"products": [
{ "productId": "A1", "price": 10, "category": "Fruit", "brand": "FreshCo" },
{ "productId": "B2", "price": 20, "category": "Veg", "brand": "GreenFarm" }
],
"stock": [
{ "store": { "storeId": "S1" }, "productId": "A1", "available": 5 },
{ "store": { "storeId": "S2" }, "productId": "B2", "available": 8 }
]
}
And here’s the JSLT code I’ve written so far:

let lookupProduct = function(productId)
[for (.products)
if (.productId == $productId)
{
"price": .price,
"category": .category,
"brand": .brand
}]

[
for (.stock)
let product = lookupProduct(.productId)
{
"storeId": .store.storeId,
"productId": .productId,
"available": .available,
"price": $product[0].price,
"category": $product[0].category,
"brand": $product[0].brand
}
]

Would appreciate any help. Thanks in advance!

[larsga]

I'm not sure exactly what you want to achieve, but one way to approach this is to first do something like:

let products = { for (.products) .productId : . }

Now you can use get-key($products, "A1") to look up any product you want.

(For later, if you want to create a function, you declare them like this.)

With this in hand your existing top for loop should be pretty easy to adapt.