https://oalp.xiphias-digital.com/DE/en/search?page=18

Elasticsearch Search Requests

Destination Payload Result
Http://search:9200
{
    "query": {
        "query": {
            "bool": {
                "must": [
                    {
                        "match_all": {}
                    },
                    {
                        "match": {
                            "type": "product_abstract"
                        }
                    },
                    {
                        "match": {
                            "store": "DE"
                        }
                    },
                    {
                        "match": {
                            "locale": "en_US"
                        }
                    },
                    {
                        "match": {
                            "is-active": true
                        }
                    },
                    {
                        "bool": {
                            "should": [
                                {
                                    "range": {
                                        "active-from": {
                                            "lte": "now"
                                        }
                                    }
                                },
                                {
                                    "bool": {
                                        "must_not": [
                                            {
                                                "exists": {
                                                    "field": "active-from"
                                                }
                                            }
                                        ]
                                    }
                                }
                            ]
                        }
                    },
                    {
                        "bool": {
                            "should": [
                                {
                                    "range": {
                                        "active-to": {
                                            "gte": "now"
                                        }
                                    }
                                },
                                {
                                    "bool": {
                                        "must_not": [
                                            {
                                                "exists": {
                                                    "field": "active-to"
                                                }
                                            }
                                        ]
                                    }
                                }
                            ]
                        }
                    }
                ],
                "filter": [
                    {
                        "nested": {
                            "query": {
                                "term": {
                                    "integer-facet.facet-name": {
                                        "value": "price-DEFAULT-EUR-GROSS_MODE",
                                        "boost": 1
                                    }
                                }
                            },
                            "path": "integer-facet"
                        }
                    }
                ]
            }
        },
        "suggest": {
            "text": ""
        },
        "_source": [
            "search-result-data"
        ],
        "from": 204,
        "size": 12,
        "aggs": {
            "category.all-parents.category": {
                "terms": {
                    "field": "category.all-parents",
                    "size": 1000
                }
            },
            "integer-facet": {
                "nested": {
                    "path": "integer-facet"
                },
                "aggs": {
                    "integer-facet-name": {
                        "terms": {
                            "field": "integer-facet.facet-name",
                            "size": 10
                        },
                        "aggs": {
                            "integer-facet-stats": {
                                "stats": {
                                    "field": "integer-facet.facet-value"
                                }
                            }
                        }
                    }
                }
            },
            "string-facet": {
                "nested": {
                    "path": "string-facet"
                },
                "aggs": {
                    "string-facet-name": {
                        "terms": {
                            "field": "string-facet.facet-name",
                            "size": 10
                        },
                        "aggs": {
                            "string-facet-value": {
                                "terms": {
                                    "field": "string-facet.facet-value",
                                    "size": 10
                                }
                            }
                        }
                    }
                }
            }
        }
    },
    "parameters": {
        "page": "18"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 16,
                    "id_product_image": 42,
                    "alt_text_small": "",
                    "product_image_key": "product_image_42",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522204FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522204FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 42,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 42
                },
                {
                    "fk_product_image_set": 16,
                    "id_product_image": 44,
                    "alt_text_small": "",
                    "product_image_key": "product_image_44",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052620-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052620-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 44,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 44
                }
            ],
            "id_product_labels": [],
            "price": 12975,
            "abstract_name": "HSM SECURIO document shredder - for desktop, 25 l, 400 watts",
            "id_product_abstract": 8,
            "type": "product_abstract",
            "add_to_cart_sku": "212837",
            "prices": {
                "DEFAULT": 12975
            },
            "abstract_sku": "M1006484",
            "url": "\/en\/hsm-aktenvernichter-securio-fuer-schreibtisch-25-l-400-watt-M1006484"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 96,
                    "alt_text_small": "",
                    "product_image_key": "product_image_96",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049521F-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049521F-02",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 96,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 96
                },
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 98,
                    "alt_text_small": "",
                    "product_image_key": "product_image_98",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907160FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907160FF-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 98,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 98
                },
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 100,
                    "alt_text_small": "",
                    "product_image_key": "product_image_100",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970138FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970138FF-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 100,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 100
                },
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 102,
                    "alt_text_small": "",
                    "product_image_key": "product_image_102",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049526-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049526-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 102,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 102
                },
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 104,
                    "alt_text_small": "",
                    "product_image_key": "product_image_104",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907160II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907160II-02",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 104,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 104
                },
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 106,
                    "alt_text_small": "",
                    "product_image_key": "product_image_106",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970138II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970138II-02",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 106,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 106
                },
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 108,
                    "alt_text_small": "",
                    "product_image_key": "product_image_108",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95389-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95389-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 108,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 108
                }
            ],
            "id_product_labels": [],
            "price": 4661,
            "abstract_name": "CP steel cabinet, fire-resistant - 3 adjustable shelves, 1 locker, width 1200 mm",
            "id_product_abstract": 15,
            "type": "product_abstract",
            "add_to_cart_sku": "574603",
            "prices": {
                "DEFAULT": 4661
            },
            "abstract_sku": "M1014502",
            "url": "\/en\/cp-stahlschrank-feuergeschuetzt-3-fachboeden-verstellbar-1-schliessfach-breite-1200-mm-M1014502"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 62,
                    "id_product_image": 180,
                    "alt_text_small": "",
                    "product_image_key": "product_image_180",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00520029II-G1?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00520029II-G1",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 180,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 180
                },
                {
                    "fk_product_image_set": 62,
                    "id_product_image": 182,
                    "alt_text_small": "",
                    "product_image_key": "product_image_182",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00520029II-G2?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00520029II-G2",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 182,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 182
                },
                {
                    "fk_product_image_set": 62,
                    "id_product_image": 184,
                    "alt_text_small": "",
                    "product_image_key": "product_image_184",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052997-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052997-03",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 184,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 184
                }
            ],
            "id_product_labels": [],
            "price": 46591,
            "abstract_name": "QUIPO pallet lift truck, yellow - Steering wheels polyurethane",
            "id_product_abstract": 29,
            "type": "product_abstract",
            "add_to_cart_sku": "464002",
            "prices": {
                "DEFAULT": 46591
            },
            "abstract_sku": "M1015355",
            "url": "\/en\/quipo-paletthubwagen-gelb-lenkraeder-polyurethan-M1015355"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 74,
                    "id_product_image": 214,
                    "alt_text_small": "",
                    "product_image_key": "product_image_214",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050088-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050088-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 214,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 214
                },
                {
                    "fk_product_image_set": 74,
                    "id_product_image": 216,
                    "alt_text_small": "",
                    "product_image_key": "product_image_216",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519711FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519711FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 216,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 216
                },
                {
                    "fk_product_image_set": 74,
                    "id_product_image": 218,
                    "alt_text_small": "",
                    "product_image_key": "product_image_218",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050076-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050076-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 218,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 218
                }
            ],
            "id_product_labels": [],
            "price": 43118,
            "abstract_name": "Mauser universal cabinet, extra-high - HxWxD 2200 x 950 x 420 mm",
            "id_product_abstract": 35,
            "type": "product_abstract",
            "add_to_cart_sku": "573939",
            "prices": {
                "DEFAULT": 43118
            },
            "abstract_sku": "M1018211",
            "url": "\/en\/mauser-universalschrank-extrahoch-hxbxt-2200-x-950-x-420-mm-M1018211"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 84,
                    "id_product_image": 250,
                    "alt_text_small": "",
                    "product_image_key": "product_image_250",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00520029II-G1?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00520029II-G1",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 250,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 250
                },
                {
                    "fk_product_image_set": 84,
                    "id_product_image": 252,
                    "alt_text_small": "",
                    "product_image_key": "product_image_252",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049548-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049548-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 252,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 252
                },
                {
                    "fk_product_image_set": 84,
                    "id_product_image": 254,
                    "alt_text_small": "",
                    "product_image_key": "product_image_254",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00520029II-G2?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00520029II-G2",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 254,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 254
                },
                {
                    "fk_product_image_set": 84,
                    "id_product_image": 256,
                    "alt_text_small": "",
                    "product_image_key": "product_image_256",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052997-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052997-03",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 256,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 256
                }
            ],
            "id_product_labels": [],
            "price": 46591,
            "abstract_name": "QUIPO pallet lift truck, yellow - Nylon load rollers (PA)",
            "id_product_abstract": 40,
            "type": "product_abstract",
            "add_to_cart_sku": "464000",
            "prices": {
                "DEFAULT": 46591
            },
            "abstract_sku": "M1024601",
            "url": "\/en\/quipo-paletthubwagen-gelb-lastrollen-nylon-pa-M1024601"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 278,
                    "alt_text_small": "",
                    "product_image_key": "product_image_278",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050962-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050962-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 278,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 278
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 280,
                    "alt_text_small": "",
                    "product_image_key": "product_image_280",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113318FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113318FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 280,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 280
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 282,
                    "alt_text_small": "",
                    "product_image_key": "product_image_282",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113319FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113319FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 282,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 282
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 284,
                    "alt_text_small": "",
                    "product_image_key": "product_image_284",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113320FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113320FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 284,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 284
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 286,
                    "alt_text_small": "",
                    "product_image_key": "product_image_286",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113321FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113321FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 286,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 286
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 288,
                    "alt_text_small": "",
                    "product_image_key": "product_image_288",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113322FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113322FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 288,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 288
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 290,
                    "alt_text_small": "",
                    "product_image_key": "product_image_290",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113323FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113323FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 290,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 290
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 292,
                    "alt_text_small": "",
                    "product_image_key": "product_image_292",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113324FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113324FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 292,
                    "sort_order": 15,
                    "alt_text_large": "",
                    "fk_product_image": 292
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 294,
                    "alt_text_small": "",
                    "product_image_key": "product_image_294",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113325FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113325FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 294,
                    "sort_order": 17,
                    "alt_text_large": "",
                    "fk_product_image": 294
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 296,
                    "alt_text_small": "",
                    "product_image_key": "product_image_296",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051115-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051115-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 296,
                    "sort_order": 19,
                    "alt_text_large": "",
                    "fk_product_image": 296
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 298,
                    "alt_text_small": "",
                    "product_image_key": "product_image_298",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113318II-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113318II-03",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 298,
                    "sort_order": 21,
                    "alt_text_large": "",
                    "fk_product_image": 298
                }
            ],
            "id_product_labels": [],
            "price": 88798,
            "abstract_name": "Mauser sliding door cabinet - with glass front, 8 shelves, center separating wall",
            "id_product_abstract": 42,
            "type": "product_abstract",
            "add_to_cart_sku": "410102",
            "prices": {
                "DEFAULT": 88798
            },
            "abstract_sku": "M1024689",
            "url": "\/en\/mauser-schiebetuerschrank-mit-glasfront-8-fachboeden-mitteltrennwand-M1024689"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 420,
                    "alt_text_small": "",
                    "product_image_key": "product_image_420",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 420,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 420
                },
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 422,
                    "alt_text_small": "",
                    "product_image_key": "product_image_422",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-02",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 422,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 422
                },
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 424,
                    "alt_text_small": "",
                    "product_image_key": "product_image_424",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-03",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 424,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 424
                },
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 426,
                    "alt_text_small": "",
                    "product_image_key": "product_image_426",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-04?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-04",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 426,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 426
                },
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 428,
                    "alt_text_small": "",
                    "product_image_key": "product_image_428",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-05?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-05",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 428,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 428
                },
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 430,
                    "alt_text_small": "",
                    "product_image_key": "product_image_430",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-06?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-06",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 430,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 430
                },
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 432,
                    "alt_text_small": "",
                    "product_image_key": "product_image_432",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-07?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-07",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 432,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 432
                }
            ],
            "id_product_labels": [],
            "price": 19888,
            "abstract_name": "magnetoplan\u00ae Flipchart DE LUXE - mobile",
            "id_product_abstract": 53,
            "type": "product_abstract",
            "add_to_cart_sku": "408034",
            "prices": {
                "DEFAULT": 19888
            },
            "abstract_sku": "M1031236",
            "url": "\/en\/magnetoplan-flipchart-de-luxe-mobil-M1031236"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 112,
                    "id_product_image": 434,
                    "alt_text_small": "",
                    "product_image_key": "product_image_434",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 434,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 434
                },
                {
                    "fk_product_image_set": 112,
                    "id_product_image": 436,
                    "alt_text_small": "",
                    "product_image_key": "product_image_436",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-02",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 436,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 436
                },
                {
                    "fk_product_image_set": 112,
                    "id_product_image": 438,
                    "alt_text_small": "",
                    "product_image_key": "product_image_438",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-03",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 438,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 438
                },
                {
                    "fk_product_image_set": 112,
                    "id_product_image": 440,
                    "alt_text_small": "",
                    "product_image_key": "product_image_440",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-04?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-04",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 440,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 440
                }
            ],
            "id_product_labels": [],
            "price": 6224,
            "abstract_name": "magnetoplan\u00ae Flipchart JUNIOR SP - magnetic",
            "id_product_abstract": 54,
            "type": "product_abstract",
            "add_to_cart_sku": "408104",
            "prices": {
                "DEFAULT": 6224
            },
            "abstract_sku": "M1031238",
            "url": "\/en\/magnetoplan-flipchart-junior-sp-magnethaftend-M1031238"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 120,
                    "id_product_image": 470,
                    "alt_text_small": "",
                    "product_image_key": "product_image_470",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052642-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052642-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 470,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 470
                },
                {
                    "fk_product_image_set": 120,
                    "id_product_image": 472,
                    "alt_text_small": "",
                    "product_image_key": "product_image_472",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052644-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052644-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 472,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 472
                }
            ],
            "id_product_labels": [],
            "price": 19423,
            "abstract_name": "IDEAL desk document shredder, EASY-TOUCH professional equipping, height 428 mm",
            "id_product_abstract": 58,
            "type": "product_abstract",
            "add_to_cart_sku": "413852",
            "prices": {
                "DEFAULT": 19423
            },
            "abstract_sku": "M1079221",
            "url": "\/en\/ideal-schreibtisch-aktenvernichter-easy-touch-professionelle-ausstattung-hoehe-428-mm-M1079221"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 122,
                    "id_product_image": 474,
                    "alt_text_small": "",
                    "product_image_key": "product_image_474",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052643-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052643-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 474,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 474
                },
                {
                    "fk_product_image_set": 122,
                    "id_product_image": 476,
                    "alt_text_small": "",
                    "product_image_key": "product_image_476",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052645-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052645-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 476,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 476
                },
                {
                    "fk_product_image_set": 122,
                    "id_product_image": 478,
                    "alt_text_small": "",
                    "product_image_key": "product_image_478",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052644-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052644-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 478,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 478
                }
            ],
            "id_product_labels": [],
            "price": 34293,
            "abstract_name": "IDEAL desk document shredder, EASY-TOUCH comfortable equipping, height 516 mm",
            "id_product_abstract": 59,
            "type": "product_abstract",
            "add_to_cart_sku": "413854",
            "prices": {
                "DEFAULT": 34293
            },
            "abstract_sku": "M1079222",
            "url": "\/en\/ideal-schreibtisch-aktenvernichter-easy-touch-komfortable-ausstattung-hoehe-516-mm-M1079222"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 622,
                    "alt_text_small": "",
                    "product_image_key": "product_image_622",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00032045F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00032045F-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 622,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 622
                },
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 624,
                    "alt_text_small": "",
                    "product_image_key": "product_image_624",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00890189FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00890189FF-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 624,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 624
                },
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 626,
                    "alt_text_small": "",
                    "product_image_key": "product_image_626",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00890340FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00890340FF-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 626,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 626
                },
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 628,
                    "alt_text_small": "",
                    "product_image_key": "product_image_628",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00890391FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00890391FF-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 628,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 628
                },
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 630,
                    "alt_text_small": "",
                    "product_image_key": "product_image_630",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95241-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95241-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 630,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 630
                },
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 632,
                    "alt_text_small": "",
                    "product_image_key": "product_image_632",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95242-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95242-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 632,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 632
                },
                {
                    "fk_product_image_set": 152,
                    "id_product_image": 634,
                    "alt_text_small": "",
                    "product_image_key": "product_image_634",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95243-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95243-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 634,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 634
                }
            ],
            "id_product_labels": [
                3
            ],
            "price": 67531,
            "abstract_name": "Wolf wardrobe - light gray RAL 7035",
            "id_product_abstract": 75,
            "type": "product_abstract",
            "add_to_cart_sku": "506670",
            "prices": {
                "DEFAULT": 67531
            },
            "abstract_sku": "M1896",
            "url": "\/en\/wolf-garderobe-lichtgrau-ral-7035-M1896"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 154,
                    "id_product_image": 636,
                    "alt_text_small": "",
                    "product_image_key": "product_image_636",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006124T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006124T",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 636,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 636
                },
                {
                    "fk_product_image_set": 154,
                    "id_product_image": 638,
                    "alt_text_small": "",
                    "product_image_key": "product_image_638",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007592L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007592L",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 638,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 638
                },
                {
                    "fk_product_image_set": 154,
                    "id_product_image": 640,
                    "alt_text_small": "",
                    "product_image_key": "product_image_640",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006683O?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006683O",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 640,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 640
                },
                {
                    "fk_product_image_set": 154,
                    "id_product_image": 642,
                    "alt_text_small": "",
                    "product_image_key": "product_image_642",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007603X?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007603X",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 642,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 642
                }
            ],
            "id_product_labels": [],
            "price": 517,
            "abstract_name": "Post-it Index Mini adhesive stripes, 35 sheets sorted 4",
            "id_product_abstract": 76,
            "type": "product_abstract",
            "add_to_cart_sku": "420506",
            "prices": {
                "DEFAULT": 517
            },
            "abstract_sku": "M21062",
            "url": "\/en\/post-it-haftstreifen-index-mini-35blatt-sortiert-4-M21062"
        }
    ],
    "spellingSuggestion": null,
    "categoryTreeFilter": {
        "0": {},
        "1": {},
        "2": {},
        "3": {},
        "4": {},
        "5": {}
    }
}
Http://search:9200
{
    "query": {
        "query": {
            "bool": {
                "must": [
                    {
                        "match_all": {}
                    },
                    {
                        "match": {
                            "type": "cms_page"
                        }
                    },
                    {
                        "match": {
                            "store": "DE"
                        }
                    },
                    {
                        "match": {
                            "locale": "en_US"
                        }
                    },
                    {
                        "match": {
                            "is-active": true
                        }
                    },
                    {
                        "bool": {
                            "should": [
                                {
                                    "range": {
                                        "active-from": {
                                            "lte": "now"
                                        }
                                    }
                                },
                                {
                                    "bool": {
                                        "must_not": [
                                            {
                                                "exists": {
                                                    "field": "active-from"
                                                }
                                            }
                                        ]
                                    }
                                }
                            ]
                        }
                    },
                    {
                        "bool": {
                            "should": [
                                {
                                    "range": {
                                        "active-to": {
                                            "gte": "now"
                                        }
                                    }
                                },
                                {
                                    "bool": {
                                        "must_not": [
                                            {
                                                "exists": {
                                                    "field": "active-to"
                                                }
                                            }
                                        ]
                                    }
                                }
                            ]
                        }
                    }
                ]
            }
        },
        "_source": [
            "search-result-data"
        ]
    },
    "parameters": []
}
{}