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

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": 48,
        "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": "5"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 92,
                    "id_product_image": 304,
                    "alt_text_small": "",
                    "product_image_key": "product_image_304",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00609266FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00609266FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 304,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 304
                },
                {
                    "fk_product_image_set": 92,
                    "id_product_image": 306,
                    "alt_text_small": "",
                    "product_image_key": "product_image_306",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00609267FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00609267FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 306,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 306
                }
            ],
            "id_product_labels": [],
            "price": 33364,
            "abstract_name": "Rocada upholstered stacking chair - Seat HxWxD 460 x 450 x 420 mm, VE 2 pieces",
            "id_product_abstract": 44,
            "type": "product_abstract",
            "add_to_cart_sku": "103740",
            "prices": {
                "DEFAULT": 33364
            },
            "abstract_sku": "M1028049",
            "url": "\/en\/polster-stapelstuhl-sitz-hxbxt-460-x-450-x-420-mm-ve-2-stk-M1028049"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 94,
                    "id_product_image": 308,
                    "alt_text_small": "",
                    "product_image_key": "product_image_308",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051130F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051130F-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 308,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 308
                },
                {
                    "fk_product_image_set": 94,
                    "id_product_image": 310,
                    "alt_text_small": "",
                    "product_image_key": "product_image_310",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970861FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970861FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 310,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 310
                },
                {
                    "fk_product_image_set": 94,
                    "id_product_image": 312,
                    "alt_text_small": "",
                    "product_image_key": "product_image_312",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970863FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970863FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 312,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 312
                }
            ],
            "id_product_labels": [],
            "price": 26464,
            "abstract_name": "FRIWA upholstered stackable chair - Four-foot substructure, VE 2 pieces",
            "id_product_abstract": 45,
            "type": "product_abstract",
            "add_to_cart_sku": "575257",
            "prices": {
                "DEFAULT": 26464
            },
            "abstract_sku": "M1028061",
            "url": "\/en\/polster-stapelstuhl-vierfussgestell-ve-2-stk-M1028061"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 356,
                    "alt_text_small": "",
                    "product_image_key": "product_image_356",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051785-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051785-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 356,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 356
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 358,
                    "alt_text_small": "",
                    "product_image_key": "product_image_358",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114909II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114909II-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 358,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 358
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 360,
                    "alt_text_small": "",
                    "product_image_key": "product_image_360",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114914II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114914II-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 360,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 360
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 362,
                    "alt_text_small": "",
                    "product_image_key": "product_image_362",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114918II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114918II-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 362,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 362
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 364,
                    "alt_text_small": "",
                    "product_image_key": "product_image_364",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00117782II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00117782II-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 364,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 364
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 366,
                    "alt_text_small": "",
                    "product_image_key": "product_image_366",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00117783II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00117783II-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 366,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 366
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 368,
                    "alt_text_small": "",
                    "product_image_key": "product_image_368",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051787-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051787-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 368,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 368
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 370,
                    "alt_text_small": "",
                    "product_image_key": "product_image_370",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114908II-G1?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114908II-G1",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 370,
                    "sort_order": 15,
                    "alt_text_large": "",
                    "fk_product_image": 370
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 372,
                    "alt_text_small": "",
                    "product_image_key": "product_image_372",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052970-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052970-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 372,
                    "sort_order": 17,
                    "alt_text_large": "",
                    "fk_product_image": 372
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 374,
                    "alt_text_small": "",
                    "product_image_key": "product_image_374",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053154-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053154-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 374,
                    "sort_order": 19,
                    "alt_text_large": "",
                    "fk_product_image": 374
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 376,
                    "alt_text_small": "",
                    "product_image_key": "product_image_376",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053155-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053155-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 376,
                    "sort_order": 21,
                    "alt_text_large": "",
                    "fk_product_image": 376
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 378,
                    "alt_text_small": "",
                    "product_image_key": "product_image_378",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053156-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053156-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 378,
                    "sort_order": 23,
                    "alt_text_large": "",
                    "fk_product_image": 378
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 380,
                    "alt_text_small": "",
                    "product_image_key": "product_image_380",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053157-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053157-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 380,
                    "sort_order": 25,
                    "alt_text_large": "",
                    "fk_product_image": 380
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 382,
                    "alt_text_small": "",
                    "product_image_key": "product_image_382",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053158-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053158-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 382,
                    "sort_order": 27,
                    "alt_text_large": "",
                    "fk_product_image": 382
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 384,
                    "alt_text_small": "",
                    "product_image_key": "product_image_384",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95561-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95561-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 384,
                    "sort_order": 29,
                    "alt_text_large": "",
                    "fk_product_image": 384
                },
                {
                    "fk_product_image_set": 102,
                    "id_product_image": 386,
                    "alt_text_small": "",
                    "product_image_key": "product_image_386",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95561-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95561-02",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 386,
                    "sort_order": 31,
                    "alt_text_large": "",
                    "fk_product_image": 386
                }
            ],
            "id_product_labels": [],
            "price": 91808,
            "abstract_name": "Hammerbacher UPLINER-2.0 desk - T-foot substructure, width 1600 mm",
            "id_product_abstract": 49,
            "type": "product_abstract",
            "add_to_cart_sku": "414098",
            "prices": {
                "DEFAULT": 91808
            },
            "abstract_sku": "M1028376",
            "url": "\/en\/upliner-2-0-stehschreibtisch-t-fuss-gestell-breite-1600-mm-M1028376"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 104,
                    "id_product_image": 388,
                    "alt_text_small": "",
                    "product_image_key": "product_image_388",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00180160II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00180160II-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 388,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 388
                },
                {
                    "fk_product_image_set": 104,
                    "id_product_image": 390,
                    "alt_text_small": "",
                    "product_image_key": "product_image_390",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00180160II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00180160II-02",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 390,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 390
                },
                {
                    "fk_product_image_set": 104,
                    "id_product_image": 392,
                    "alt_text_small": "",
                    "product_image_key": "product_image_392",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00180159II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00180159II-02",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 392,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 392
                },
                {
                    "fk_product_image_set": 104,
                    "id_product_image": 394,
                    "alt_text_small": "",
                    "product_image_key": "product_image_394",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00180159II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00180159II-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 394,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 394
                }
            ],
            "id_product_labels": [],
            "price": 26499,
            "abstract_name": "Bilsey UNIVERSAL hinged-door cabinet - Wardrobe insert",
            "id_product_abstract": 50,
            "type": "product_abstract",
            "add_to_cart_sku": "632992",
            "prices": {
                "DEFAULT": 26499
            },
            "abstract_sku": "M1028483",
            "url": "\/en\/bisley-universal-fluegeltuerenschrank-garderobeneinsatz-M1028483"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 106,
                    "id_product_image": 396,
                    "alt_text_small": "",
                    "product_image_key": "product_image_396",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044362F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044362F-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 396,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 396
                },
                {
                    "fk_product_image_set": 106,
                    "id_product_image": 398,
                    "alt_text_small": "",
                    "product_image_key": "product_image_398",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051531-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051531-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 398,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 398
                },
                {
                    "fk_product_image_set": 106,
                    "id_product_image": 400,
                    "alt_text_small": "",
                    "product_image_key": "product_image_400",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051530F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051530F-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 400,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 400
                }
            ],
            "id_product_labels": [],
            "price": 83721,
            "abstract_name": "Pallet lift truck - extra low",
            "id_product_abstract": 51,
            "type": "product_abstract",
            "add_to_cart_sku": "573330",
            "prices": {
                "DEFAULT": 83721
            },
            "abstract_sku": "M1028702",
            "url": "\/en\/paletthubwagen-extra-nieder-M1028702"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 108,
                    "id_product_image": 402,
                    "alt_text_small": "",
                    "product_image_key": "product_image_402",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052324F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052324F-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 402,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 402
                },
                {
                    "fk_product_image_set": 108,
                    "id_product_image": 404,
                    "alt_text_small": "",
                    "product_image_key": "product_image_404",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970894FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970894FF-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 404,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 404
                },
                {
                    "fk_product_image_set": 108,
                    "id_product_image": 406,
                    "alt_text_small": "",
                    "product_image_key": "product_image_406",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970895FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970895FF-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 406,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 406
                },
                {
                    "fk_product_image_set": 108,
                    "id_product_image": 408,
                    "alt_text_small": "",
                    "product_image_key": "product_image_408",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970896FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970896FF-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 408,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 408
                },
                {
                    "fk_product_image_set": 108,
                    "id_product_image": 410,
                    "alt_text_small": "",
                    "product_image_key": "product_image_410",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970897FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970897FF-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 410,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 410
                },
                {
                    "fk_product_image_set": 108,
                    "id_product_image": 412,
                    "alt_text_small": "",
                    "product_image_key": "product_image_412",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970898FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970898FF-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 412,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 412
                },
                {
                    "fk_product_image_set": 108,
                    "id_product_image": 414,
                    "alt_text_small": "",
                    "product_image_key": "product_image_414",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970899FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970899FF-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 414,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 414
                },
                {
                    "fk_product_image_set": 108,
                    "id_product_image": 416,
                    "alt_text_small": "",
                    "product_image_key": "product_image_416",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970897II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970897II-02",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 416,
                    "sort_order": 15,
                    "alt_text_large": "",
                    "fk_product_image": 416
                },
                {
                    "fk_product_image_set": 108,
                    "id_product_image": 418,
                    "alt_text_small": "",
                    "product_image_key": "product_image_418",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052323F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052323F-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 418,
                    "sort_order": 17,
                    "alt_text_large": "",
                    "fk_product_image": 418
                }
            ],
            "id_product_labels": [],
            "price": 17417,
            "abstract_name": "FRIWA plastic shell chair - Substructure chromed",
            "id_product_abstract": 52,
            "type": "product_abstract",
            "add_to_cart_sku": "575284",
            "prices": {
                "DEFAULT": 17417
            },
            "abstract_sku": "M1030133",
            "url": "\/en\/kunststoffschalenstuhl-gestell-verchromt-M1030133"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 124,
                    "id_product_image": 480,
                    "alt_text_small": "",
                    "product_image_key": "product_image_480",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-02",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 480,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 480
                },
                {
                    "fk_product_image_set": 124,
                    "id_product_image": 482,
                    "alt_text_small": "",
                    "product_image_key": "product_image_482",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052676-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 482,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 482
                }
            ],
            "id_product_labels": [],
            "price": 21393,
            "abstract_name": "Lectern, 2 shelves - Front made of steel sheet",
            "id_product_abstract": 60,
            "type": "product_abstract",
            "add_to_cart_sku": "413849",
            "prices": {
                "DEFAULT": 21393
            },
            "abstract_sku": "M1079243",
            "url": "\/en\/rednerpult-2-ablagen-front-aus-stahlblech-M1079243"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 126,
                    "id_product_image": 484,
                    "alt_text_small": "",
                    "product_image_key": "product_image_484",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053199-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053199-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 484,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 484
                },
                {
                    "fk_product_image_set": 126,
                    "id_product_image": 486,
                    "alt_text_small": "",
                    "product_image_key": "product_image_486",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053200-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00053200-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 486,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 486
                },
                {
                    "fk_product_image_set": 126,
                    "id_product_image": 488,
                    "alt_text_small": "",
                    "product_image_key": "product_image_488",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052907-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052907-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 488,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 488
                }
            ],
            "id_product_labels": [],
            "price": 32573,
            "abstract_name": "Topstar upholstery stacking chair, VE 2 pieces - cantilever chair",
            "id_product_abstract": 61,
            "type": "product_abstract",
            "add_to_cart_sku": "411653",
            "prices": {
                "DEFAULT": 32573
            },
            "abstract_sku": "M1080190",
            "url": "\/en\/topstar-polster-stapelstuhl-ve-2-stk-freischwinger-M1080190"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 128,
                    "id_product_image": 490,
                    "alt_text_small": "",
                    "product_image_key": "product_image_490",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035082F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035082F-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 490,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 490
                },
                {
                    "fk_product_image_set": 128,
                    "id_product_image": 492,
                    "alt_text_small": "",
                    "product_image_key": "product_image_492",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014490-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014490-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 492,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 492
                },
                {
                    "fk_product_image_set": 128,
                    "id_product_image": 494,
                    "alt_text_small": "",
                    "product_image_key": "product_image_494",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014491-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014491-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 494,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 494
                },
                {
                    "fk_product_image_set": 128,
                    "id_product_image": 496,
                    "alt_text_small": "",
                    "product_image_key": "product_image_496",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014492-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014492-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 496,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 496
                },
                {
                    "fk_product_image_set": 128,
                    "id_product_image": 498,
                    "alt_text_small": "",
                    "product_image_key": "product_image_498",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014493-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00014493-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 498,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 498
                }
            ],
            "id_product_labels": [],
            "price": 11482,
            "abstract_name": "conference chair - stacking chair, black substructure",
            "id_product_abstract": 62,
            "type": "product_abstract",
            "add_to_cart_sku": "104190",
            "prices": {
                "DEFAULT": 11482
            },
            "abstract_sku": "M10871",
            "url": "\/en\/konferenzstuhl-stapelstuhl-gestell-schwarz-M10871"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 132,
                    "id_product_image": 510,
                    "alt_text_small": "",
                    "product_image_key": "product_image_510",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/673327_2_EstucadoPolsterstuhl?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/673327_2_EstucadoPolsterstuhl",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 510,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 510
                }
            ],
            "id_product_labels": [],
            "price": 19102,
            "abstract_name": "Estucado upholstered chair with armrests, leader, white",
            "id_product_abstract": 64,
            "type": "product_abstract",
            "add_to_cart_sku": "673327",
            "prices": {
                "DEFAULT": 19102
            },
            "abstract_sku": "M111",
            "url": "\/en\/estucado-polsterstuhl-mit-armlehnen-leder-weiss-M111"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 140,
                    "id_product_image": 540,
                    "alt_text_small": "",
                    "product_image_key": "product_image_540",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00022743-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00022743-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 540,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 540
                },
                {
                    "fk_product_image_set": 140,
                    "id_product_image": 542,
                    "alt_text_small": "",
                    "product_image_key": "product_image_542",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00751846II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00751846II-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 542,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 542
                },
                {
                    "fk_product_image_set": 140,
                    "id_product_image": 544,
                    "alt_text_small": "",
                    "product_image_key": "product_image_544",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00751848II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00751848II-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 544,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 544
                },
                {
                    "fk_product_image_set": 140,
                    "id_product_image": 546,
                    "alt_text_small": "",
                    "product_image_key": "product_image_546",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00022742-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00022742-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 546,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 546
                },
                {
                    "fk_product_image_set": 140,
                    "id_product_image": 548,
                    "alt_text_small": "",
                    "product_image_key": "product_image_548",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907221II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907221II-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 548,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 548
                },
                {
                    "fk_product_image_set": 140,
                    "id_product_image": 550,
                    "alt_text_small": "",
                    "product_image_key": "product_image_550",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00022744-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00022744-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 550,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 550
                },
                {
                    "fk_product_image_set": 140,
                    "id_product_image": 552,
                    "alt_text_small": "",
                    "product_image_key": "product_image_552",
                    "updated_at": "2025-12-02 09:55:12.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00022745-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00022745-01",
                    "created_at": "2025-12-02 09:55:12.000000",
                    "id_product_image_set_to_product_image": 552,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 552
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 22780,
            "abstract_name": "Topstar disc swivel chair, synchronous mechanism, disc seating - cover 100% polyacrylic",
            "id_product_abstract": 68,
            "type": "product_abstract",
            "add_to_cart_sku": "101441",
            "prices": {
                "DEFAULT": 22780,
                "ORIGINAL": 25311
            },
            "abstract_sku": "M11480",
            "url": "\/en\/topstar-bandscheiben-drehstuhl-synchronmechanik-bandscheibensitz-bezug-100-polyacryl-M11480"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 840,
                    "id_product_image": 3214,
                    "alt_text_small": "",
                    "product_image_key": "product_image_3214",
                    "updated_at": "2025-12-02 09:55:28.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00748406FF-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00748406FF-02",
                    "created_at": "2025-12-02 09:55:28.000000",
                    "id_product_image_set_to_product_image": 3214,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 3214
                }
            ],
            "id_product_labels": [],
            "price": 20329,
            "abstract_name": "QUIPO universal steel cabinet with swing doors - HxWxD 1950 x 950 x 420 mm",
            "id_product_abstract": 70,
            "type": "product_abstract",
            "add_to_cart_sku": "107254",
            "prices": {
                "DEFAULT": 20329
            },
            "abstract_sku": "M12655",
            "url": "\/en\/quipo-universal-stahlschrank-mit-fluegeltueren-hxbxt-1950-x-950-x-420-mm-M12655"
        }
    ],
    "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": []
}
{}