https://oalp.xiphias-digital.com/DE/en/newsletter/subscribe

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": 144,
        "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": "13"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 50,
                    "id_product_image": 156,
                    "alt_text_small": "",
                    "product_image_key": "product_image_156",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049515-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049515-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 156,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 156
                },
                {
                    "fk_product_image_set": 50,
                    "id_product_image": 158,
                    "alt_text_small": "",
                    "product_image_key": "product_image_158",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049516-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049516-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 158,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 158
                }
            ],
            "id_product_labels": [],
            "price": 58000,
            "abstract_name": "Palette lifting truck with balance - Load capacity 2000 kg",
            "id_product_abstract": 23,
            "type": "product_abstract",
            "add_to_cart_sku": "464007",
            "prices": {
                "DEFAULT": 58000
            },
            "abstract_sku": "M1014656",
            "url": "\/en\/paletthubwagen-mit-waage-tragfaehigkeit-2000-kg-M1014656"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 116,
                    "id_product_image": 450,
                    "alt_text_small": "",
                    "product_image_key": "product_image_450",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00731548FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00731548FF-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 450,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 450
                },
                {
                    "fk_product_image_set": 116,
                    "id_product_image": 452,
                    "alt_text_small": "",
                    "product_image_key": "product_image_452",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00731549FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00731549FF-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 452,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 452
                },
                {
                    "fk_product_image_set": 116,
                    "id_product_image": 454,
                    "alt_text_small": "",
                    "product_image_key": "product_image_454",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00731550FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00731550FF-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 454,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 454
                },
                {
                    "fk_product_image_set": 116,
                    "id_product_image": 456,
                    "alt_text_small": "",
                    "product_image_key": "product_image_456",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00013690-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00013690-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 456,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 456
                },
                {
                    "fk_product_image_set": 116,
                    "id_product_image": 458,
                    "alt_text_small": "",
                    "product_image_key": "product_image_458",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00743638FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00743638FF-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 458,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 458
                },
                {
                    "fk_product_image_set": 116,
                    "id_product_image": 460,
                    "alt_text_small": "",
                    "product_image_key": "product_image_460",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00918470FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00918470FF-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 460,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 460
                },
                {
                    "fk_product_image_set": 116,
                    "id_product_image": 462,
                    "alt_text_small": "",
                    "product_image_key": "product_image_462",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00013691-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00013691-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 462,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 462
                }
            ],
            "id_product_labels": [],
            "price": 9785,
            "abstract_name": "Topstar standard swivel chair - without armrests, backrest 450 mm",
            "id_product_abstract": 56,
            "type": "product_abstract",
            "add_to_cart_sku": "104151",
            "prices": {
                "DEFAULT": 9785
            },
            "abstract_sku": "M10577",
            "url": "\/en\/topstar-standard-drehstuhl-ohne-armlehnen-rueckenlehne-450-mm-M10577"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 180,
                    "id_product_image": 728,
                    "alt_text_small": "",
                    "product_image_key": "product_image_728",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007625S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007625S",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 728,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 728
                },
                {
                    "fk_product_image_set": 180,
                    "id_product_image": 730,
                    "alt_text_small": "",
                    "product_image_key": "product_image_730",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007625V?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007625V",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 730,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 730
                }
            ],
            "id_product_labels": [],
            "price": 2596,
            "abstract_name": "Verbatim USB stick OTG",
            "id_product_abstract": 89,
            "type": "product_abstract",
            "add_to_cart_sku": "420573",
            "prices": {
                "DEFAULT": 2596
            },
            "abstract_sku": "M21103",
            "url": "\/en\/verbatim-usb-stick-otg-M21103"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 610,
                    "id_product_image": 2062,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2062",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035965-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035965-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2062,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2062
                }
            ],
            "id_product_labels": [],
            "price": 20040,
            "abstract_name": "office akktiv operator swivel chair, backrest height 600 mm - point-synchronous mechanism, sliding seat",
            "id_product_abstract": 315,
            "type": "product_abstract",
            "add_to_cart_sku": "102180",
            "prices": {
                "DEFAULT": 20040
            },
            "abstract_sku": "M58102",
            "url": "\/en\/office-akktiv-operator-drehstuhl-rueckenlehnenhoehe-600-mm-punktsynchron-mechanik-muldensitz-M58102"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 650,
                    "id_product_image": 2314,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2314",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00042727F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00042727F-01",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2314,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2314
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 13689,
            "abstract_name": "Dipiplast stackable chair made of polypropylene - without upholstery",
            "id_product_abstract": 338,
            "type": "product_abstract",
            "add_to_cart_sku": "101515",
            "prices": {
                "DEFAULT": 13689,
                "ORIGINAL": 15210
            },
            "abstract_sku": "M64933",
            "url": "\/en\/schalenstuhl-aus-polypropylen-ohne-polster-M64933"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 672,
                    "id_product_image": 2398,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2398",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00608953FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00608953FF-01",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2398,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2398
                },
                {
                    "fk_product_image_set": 672,
                    "id_product_image": 2400,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2400",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00041742-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00041742-02",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2400,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2400
                },
                {
                    "fk_product_image_set": 672,
                    "id_product_image": 2402,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2402",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00608953II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00608953II-02",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2402,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2402
                }
            ],
            "id_product_labels": [],
            "price": 51218,
            "abstract_name": "office akktiv hinged-door cabinet - HxWxD 1864 x 615 x 440 mm, 4 shelves",
            "id_product_abstract": 349,
            "type": "product_abstract",
            "add_to_cart_sku": "103838",
            "prices": {
                "DEFAULT": 51218
            },
            "abstract_sku": "M72843",
            "url": "\/en\/office-akktiv-fluegeltuerenschrank-hxbxt-1864-x-615-x-440-mm-4-fachboeden-M72843"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 694,
                    "id_product_image": 2520,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2520",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610396FF-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610396FF-02",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2520,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2520
                },
                {
                    "fk_product_image_set": 694,
                    "id_product_image": 2522,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2522",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610397FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610397FF-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2522,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2522
                },
                {
                    "fk_product_image_set": 694,
                    "id_product_image": 2524,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2524",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610395II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610395II-02",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2524,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2524
                },
                {
                    "fk_product_image_set": 694,
                    "id_product_image": 2526,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2526",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034271-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00034271-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2526,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 2526
                },
                {
                    "fk_product_image_set": 694,
                    "id_product_image": 2528,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2528",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610395II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610395II-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2528,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 2528
                },
                {
                    "fk_product_image_set": 694,
                    "id_product_image": 2530,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2530",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK94886-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK94886-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2530,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 2530
                }
            ],
            "id_product_labels": [],
            "price": 83155,
            "abstract_name": "Hammerbacher UPLINER standing desk, electrically height-adjustable - 655 - 1300 mm, WxD 1800 x 800 mm",
            "id_product_abstract": 360,
            "type": "product_abstract",
            "add_to_cart_sku": "575060",
            "prices": {
                "DEFAULT": 83155
            },
            "abstract_sku": "M72944",
            "url": "\/en\/upliner-stehschreibtisch-elektrisch-hoehenverstellbar-655-1300-mm-bxt-1800-x-800-mm-M72944"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 704,
                    "id_product_image": 2580,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2580",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049523F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049523F-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2580,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2580
                },
                {
                    "fk_product_image_set": 704,
                    "id_product_image": 2582,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2582",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00611584FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00611584FF-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2582,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2582
                },
                {
                    "fk_product_image_set": 704,
                    "id_product_image": 2584,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2584",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970137FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970137FF-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2584,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2584
                },
                {
                    "fk_product_image_set": 704,
                    "id_product_image": 2586,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2586",
                    "updated_at": "2025-12-02 09:55:24.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:24.000000",
                    "id_product_image_set_to_product_image": 2586,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 2586
                },
                {
                    "fk_product_image_set": 704,
                    "id_product_image": 2588,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2588",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00611584II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00611584II-02",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2588,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 2588
                },
                {
                    "fk_product_image_set": 704,
                    "id_product_image": 2590,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2590",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970137II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970137II-02",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2590,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 2590
                },
                {
                    "fk_product_image_set": 704,
                    "id_product_image": 2592,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2592",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK94894-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK94894-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2592,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 2592
                }
            ],
            "id_product_labels": [],
            "price": 182654,
            "abstract_name": "CP steel cabinet, fire-resistant - 4 adjustable shelves, width 1200 mm",
            "id_product_abstract": 365,
            "type": "product_abstract",
            "add_to_cart_sku": "574602",
            "prices": {
                "DEFAULT": 182654
            },
            "abstract_sku": "M74966",
            "url": "\/en\/cp-stahlschrank-feuergeschuetzt-4-fachboeden-verstellbar-breite-1200-mm-M74966"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 772,
                    "id_product_image": 2984,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2984",
                    "updated_at": "2025-12-02 09:55:27.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046110-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046110-01",
                    "created_at": "2025-12-02 09:55:27.000000",
                    "id_product_image_set_to_product_image": 2984,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2984
                },
                {
                    "fk_product_image_set": 772,
                    "id_product_image": 2986,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2986",
                    "updated_at": "2025-12-02 09:55:27.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046525F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046525F-01",
                    "created_at": "2025-12-02 09:55:27.000000",
                    "id_product_image_set_to_product_image": 2986,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2986
                },
                {
                    "fk_product_image_set": 772,
                    "id_product_image": 2988,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2988",
                    "updated_at": "2025-12-02 09:55:27.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046111-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046111-01",
                    "created_at": "2025-12-02 09:55:27.000000",
                    "id_product_image_set_to_product_image": 2988,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2988
                }
            ],
            "id_product_labels": [],
            "price": 257513,
            "abstract_name": "KPZ pallet lifting truck with precision weighing - with standard display, multiple range distribution",
            "id_product_abstract": 404,
            "type": "product_abstract",
            "add_to_cart_sku": "490001",
            "prices": {
                "DEFAULT": 257513
            },
            "abstract_sku": "M88181",
            "url": "\/en\/paletthubwagen-mit-praezisionswaage-mit-standardanzeige-mehrbereichsteilung-M88181"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 492,
                    "id_product_image": 1588,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1588",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00729438FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00729438FF-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1588,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1588
                },
                {
                    "fk_product_image_set": 492,
                    "id_product_image": 1590,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1590",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000025389133_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000025389133_PRD_org_all",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1590,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1590
                }
            ],
            "id_product_labels": [],
            "price": 76882,
            "abstract_name": "HSM document shredder CLASSIC - 125.2, collecting volume 76 I",
            "id_product_abstract": 257,
            "type": "product_abstract",
            "add_to_cart_sku": "104074",
            "prices": {
                "DEFAULT": 76882
            },
            "abstract_sku": "M26831",
            "url": "\/en\/hsm-aktenvernichter-classic-125-2-auffangvolumen-76-l-M26831"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 66,
                    "id_product_image": 192,
                    "alt_text_small": "",
                    "product_image_key": "product_image_192",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00761038II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00761038II-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 192,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 192
                }
            ],
            "id_product_labels": [
                4
            ],
            "price": 37728,
            "abstract_name": "Rocada speaker stand FORUM - 2 glass plates",
            "rating": 5,
            "id_product_abstract": 31,
            "review_count": 3,
            "type": "product_abstract",
            "add_to_cart_sku": "520561",
            "prices": {
                "DEFAULT": 37728
            },
            "abstract_sku": "M1016129",
            "url": "\/en\/rednerstativ-forum-2-glasplatten-M1016129"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 322,
                    "alt_text_small": "",
                    "product_image_key": "product_image_322",
                    "updated_at": "2025-12-02 09:55:10.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:10.000000",
                    "id_product_image_set_to_product_image": 322,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 322
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 324,
                    "alt_text_small": "",
                    "product_image_key": "product_image_324",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114908II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114908II-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 324,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 324
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 326,
                    "alt_text_small": "",
                    "product_image_key": "product_image_326",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114913II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114913II-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 326,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 326
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 328,
                    "alt_text_small": "",
                    "product_image_key": "product_image_328",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114917II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114917II-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 328,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 328
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 330,
                    "alt_text_small": "",
                    "product_image_key": "product_image_330",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00117779II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00117779II-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 330,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 330
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 332,
                    "alt_text_small": "",
                    "product_image_key": "product_image_332",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00117780II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00117780II-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 332,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 332
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 334,
                    "alt_text_small": "",
                    "product_image_key": "product_image_334",
                    "updated_at": "2025-12-02 09:55:10.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:10.000000",
                    "id_product_image_set_to_product_image": 334,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 334
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 336,
                    "alt_text_small": "",
                    "product_image_key": "product_image_336",
                    "updated_at": "2025-12-02 09:55:10.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:10.000000",
                    "id_product_image_set_to_product_image": 336,
                    "sort_order": 15,
                    "alt_text_large": "",
                    "fk_product_image": 336
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 338,
                    "alt_text_small": "",
                    "product_image_key": "product_image_338",
                    "updated_at": "2025-12-02 09:55:10.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:10.000000",
                    "id_product_image_set_to_product_image": 338,
                    "sort_order": 17,
                    "alt_text_large": "",
                    "fk_product_image": 338
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 340,
                    "alt_text_small": "",
                    "product_image_key": "product_image_340",
                    "updated_at": "2025-12-02 09:55:10.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:10.000000",
                    "id_product_image_set_to_product_image": 340,
                    "sort_order": 19,
                    "alt_text_large": "",
                    "fk_product_image": 340
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 342,
                    "alt_text_small": "",
                    "product_image_key": "product_image_342",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114908II-G2?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00114908II-G2",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 342,
                    "sort_order": 21,
                    "alt_text_large": "",
                    "fk_product_image": 342
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 344,
                    "alt_text_small": "",
                    "product_image_key": "product_image_344",
                    "updated_at": "2025-12-02 09:55:10.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:10.000000",
                    "id_product_image_set_to_product_image": 344,
                    "sort_order": 23,
                    "alt_text_large": "",
                    "fk_product_image": 344
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 346,
                    "alt_text_small": "",
                    "product_image_key": "product_image_346",
                    "updated_at": "2025-12-02 09:55:10.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:10.000000",
                    "id_product_image_set_to_product_image": 346,
                    "sort_order": 25,
                    "alt_text_large": "",
                    "fk_product_image": 346
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 348,
                    "alt_text_small": "",
                    "product_image_key": "product_image_348",
                    "updated_at": "2025-12-02 09:55:10.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:10.000000",
                    "id_product_image_set_to_product_image": 348,
                    "sort_order": 27,
                    "alt_text_large": "",
                    "fk_product_image": 348
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 350,
                    "alt_text_small": "",
                    "product_image_key": "product_image_350",
                    "updated_at": "2025-12-02 09:55:10.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:10.000000",
                    "id_product_image_set_to_product_image": 350,
                    "sort_order": 29,
                    "alt_text_large": "",
                    "fk_product_image": 350
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 352,
                    "alt_text_small": "",
                    "product_image_key": "product_image_352",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95560-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95560-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 352,
                    "sort_order": 31,
                    "alt_text_large": "",
                    "fk_product_image": 352
                },
                {
                    "fk_product_image_set": 100,
                    "id_product_image": 354,
                    "alt_text_small": "",
                    "product_image_key": "product_image_354",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95560-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95560-02",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 354,
                    "sort_order": 33,
                    "alt_text_large": "",
                    "fk_product_image": 354
                }
            ],
            "id_product_labels": [],
            "price": 86756,
            "abstract_name": "Hammerbacher UPLINER-2.0 desk - T-foot substructure, width 1200 mm",
            "id_product_abstract": 48,
            "type": "product_abstract",
            "add_to_cart_sku": "414097",
            "prices": {
                "DEFAULT": 86756
            },
            "abstract_sku": "M1028375",
            "url": "\/en\/upliner-2-0-stehschreibtisch-t-fuss-gestell-breite-1200-mm-M1028375"
        }
    ],
    "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": []
}
{}