Task
Product characteristics are stored in a JSON attributes array: material, color, and other parameters. The import needs a separate material field.
Short answer
Open value inside attributes and add a condition on neighboring code: regular expression ^material$ (matches a value that is exactly material).
How to do it in Eofferix
In the JSON snapshot, select
valueinside the repeated block.
The selected field belongs to one repeated object. Open the value settings.
The animation shows opening the field settings. Add an export condition:
code^material$.
The condition selects only the needed object before export.
Before / after
Before
source data{
"products": [
{
"sku": "SKU-14001",
"name": "Hudson lamp",
"attributes": [
{
"code": "material",
"name": "Material",
"value": "steel"
},
{
"code": "color",
"name": "Color",
"value": "white"
}
]
},
{
"sku": "SKU-14002",
"name": "Parker chair",
"attributes": [
{
"code": "material",
"name": "Material",
"value": "wood"
},
{
"code": "color",
"name": "Color",
"value": "black"
}
]
}
]
}After
result{
"products": [
{
"sku": "SKU-14001",
"name": "Hudson lamp",
"material": "steel"
},
{
"sku": "SKU-14002",
"name": "Parker chair",
"material": "wood"
}
]
}What to keep in mind
- The condition must check
codefrom the same attribute, otherwise color can be taken instead of material. - If the supplier uses
attribute_idinstead ofcode, use that path in the condition.