Task
Each JSON product has a warehouses array. The import needs stock only from warehouse ny-main, while reserve warehouses must not fill this field.
Short answer
Open qty inside warehouses and add a condition on neighboring warehouse_id: regular expression ^ny-main$ (matches a value that is exactly ny-main).
How to do it in Eofferix
In the JSON snapshot, select
qtyinside thewarehousesarray.
The selected field belongs to one warehouse object. Open the value settings.
The animation shows opening the field settings. Add an export condition:
warehouse_id^ny-main$.
The condition selects the warehouse before exporting the value.
Before / after
Before
source data{
"products": [
{
"sku": "SKU-25001",
"name": "Hudson lamp",
"warehouses": [
{
"warehouse_id": "ny-main",
"qty": 14
},
{
"warehouse_id": "la-reserve",
"qty": 6
}
]
},
{
"sku": "SKU-25002",
"name": "Parker chair",
"warehouses": [
{
"warehouse_id": "ny-main",
"qty": 0
},
{
"warehouse_id": "la-reserve",
"qty": 5
}
]
}
]
}After
result{
"products": [
{
"sku": "SKU-25001",
"name": "Hudson lamp",
"stock": 14
},
{
"sku": "SKU-25002",
"name": "Parker chair",
"stock": 0
}
]
}What to keep in mind
- If the warehouse ID is always exact, use
equalswithout a regular expression. - If the needed
warehouse_idis missing, the resulting stock field will stay empty for that product.