The provided field is not an array

I want to split this json so that each product is a separate item

{
    "status": "SUCCESS",
    "products": {
        "1055241981": {
            "id": 1055241981,
            "ean": "",
            "sku": "E14",
            "name": "Pokrowiec na fotel Muren nowy model",
            "stock": {
                "bl_1089": "15"
            },
            "prices": {
                "770": "369.00"
            }
        },
        "1055242002": {
            "id": 1055242002,
            "ean": "",
            "sku": "T02",
            "name": "Tkanina na metry Natural",
            "stock": {
                "bl_1089": "16"
            },
            "prices": {
                "770": "35.00"
            }
        },
        "1055242024": {
            "id": 1055242024,
            "ean": "",
            "sku": "T01",
            "name": "Tkanina na metry Lux",
            "stock": {
                "bl_1089": "9"
            },
            "prices": {
                "770": "25.00"
            }
        },
        "1055242038": {
            "id": 1055242038,
            "ean": "",
            "sku": "E09",
            "name": "Pokrowiec na podnóżek Ektorp",
            "stock": {
                "bl_1089": "16"
            },
            "prices": {
                "770": "249.00"
            }
        },
        "1055242061": {
            "id": 1055242061,
            "ean": "",
            "sku": "E06",
            "name": "Pokrowiec na narożnik Ektorp",
            "stock": {
                "bl_1089": "15"
            },
            "prices": {
                "770": "1199.00"
            }
        },
        "1055242082": {
            "id": 1055242082,
            "ean": "",
            "sku": "E11",
            "name": "Pokrowiec na fotel Tullsta",
            "stock": {
                "bl_1089": "15"
            },
            "prices": {
                "770": "279.00"
            }
        },
        "1055242103": {
            "id": 1055242103,
            "ean": "",
            "sku": "E12",
            "name": "Pokrowiec na fotel Muren stary model",
            "stock": {
                "bl_1089": "15"
            },
            "prices": {
                "770": "369.00"
            }
        },
        "1055242125": {
            "id": 1055242125,
            "ean": "",
            "sku": "E05",
            "name": "Pokrowiec na fotel Jennylund",
            "stock": {
                "bl_1089": "15"
            },
            "prices": {
                "770": "299.00"
            }
        },
        "1055242147": {
            "id": 1055242147,
            "ean": "",
            "sku": "E04",
            "name": "Pokrowiec na fotel Ektorp",
            "stock": {
                "bl_1089": "16"
            },
            "prices": {
                "770": "379.00"
            }
        },
        "1055242170": {
            "id": 1055242170,
            "ean": "",
            "sku": "E08",
            "name": "Pokrowiec na sofę Ektorp 3 rozkładany stary model",
            "stock": {
                "bl_1089": "16"
            },
            "prices": {
                "770": "749.00"
            }
        },
        "1055242192": {
            "id": 1055242192,
            "ean": "",
            "sku": "E10",
            "name": "Pokrowiec na sofę Ektorp 3 rozkładany nowy model",
            "stock": {
                "bl_1089": "16"
            },
            "prices": {
                "770": "699.00"
            }
        },
        "1055242215": {
            "id": 1055242215,
            "ean": "",
            "sku": "E03",
            "name": "Pokrowiec na sofę Ektorp 3 nierozkładany",
            "stock": {
                "bl_1089": "16"
            },
            "prices": {
                "770": "699.00"
            }
        },
        "1055242238": {
            "id": 1055242238,
            "ean": "",
            "sku": "E02",
            "name": "Pokrowiec na sofę Ektorp 2 rozkładany nowy model",
            "stock": {
                "bl_1089": "16"
            },
            "prices": {
                "770": "599.00"
            }
        },
        "1055242263": {
            "id": 1055242263,
            "ean": "",
            "sku": "E13",
            "name": "Pokrowiec na sofę Ektorp 2 rozkładany stary model",
            "stock": {
                "bl_1089": "16"
            },
            "prices": {
                "770": "599.00"
            }
        },
        "1055242288": {
            "id": 1055242288,
            "ean": "",
            "sku": "E01",
            "name": "Pokrowiec na sofę Ektorp 2 nierozkładany",
            "stock": {
                "bl_1089": "16"
            },
            "prices": {
                "770": "599.00"
            }
        },
        "1055242311": {
            "id": 1055242311,
            "ean": "",
            "sku": "B03",
            "name": "Poszewka na poduszkę pod plecy",
            "stock": {
                "bl_1089": "9"
            },
            "prices": {
                "770": "29.00"
            }
        },
        "1055242325": {
            "id": 1055242325,
            "ean": "",
            "sku": "B05",
            "name": "Poszewka na podłokietnik prostokątny",
            "stock": {
                "bl_1089": "9"
            },
            "prices": {
                "770": "40.00"
            }
        },
        "1055242339": {
            "id": 1055242339,
            "ean": "",
            "sku": "B04",
            "name": "Poszewka na podłokietnik półokrągły",
            "stock": {
                "bl_1089": "9"
            },
            "prices": {
                "770": "40.00"
            }
        },
        "1055242353": {
            "id": 1055242353,
            "ean": "",
            "sku": "B02",
            "name": "Pokrowiec na sofę beddinge w karo",
            "stock": {
                "bl_1089": "5"
            },
            "prices": {
                "770": "259.00"
            }
        },
        "1055242362": {
            "id": 1055242362,
            "ean": "",
            "sku": "B01",
            "name": "Pokrowiec na sofę beddinge w pasy",
            "stock": {
                "bl_1089": "11"
            },
            "prices": {
                "770": "259.00"
            }
        }
    }
}

I tried to use Item Lists, but I get an error “ERROR: The provided field ‘products’ is not an array”

Hi @Valdri

Please see the workflow below.
First function is the data input, so you won’t need that.
Second is the function that extracts the products.
3rd is the item lists node you are already using, but now it works. :slight_smile:

1 Like

It worked, thanks for your help

2 Likes