https://oalp.xiphias-digital.com/DE/en/search?merchant_name%5B0%5D=Spryker&page=16

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"
                        }
                    },
                    {
                        "bool": {
                            "should": [
                                {
                                    "nested": {
                                        "path": "string-facet",
                                        "query": {
                                            "bool": {
                                                "filter": [
                                                    {
                                                        "term": {
                                                            "string-facet.facet-name": {
                                                                "value": "merchant_name",
                                                                "boost": 1
                                                            }
                                                        }
                                                    },
                                                    {
                                                        "term": {
                                                            "string-facet.facet-value": {
                                                                "value": "Spryker",
                                                                "boost": 1
                                                            }
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    }
                                }
                            ]
                        }
                    }
                ]
            }
        },
        "suggest": {
            "text": ""
        },
        "_source": [
            "search-result-data"
        ],
        "from": 180,
        "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
                                }
                            }
                        }
                    }
                }
            },
            "global-merchant_name": {
                "global": {},
                "aggs": {
                    "filter": {
                        "filter": {
                            "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"
                                        }
                                    }
                                ]
                            }
                        },
                        "aggs": {
                            "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": {
        "merchant_name": [
            "Spryker"
        ],
        "page": "16"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 480,
                    "id_product_image": 1574,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1574",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845E?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845E",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1574,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1574
                },
                {
                    "fk_product_image_set": 480,
                    "id_product_image": 1576,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1576",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041168L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B041168L",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1576,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1576
                }
            ],
            "id_product_labels": [],
            "price": 3456,
            "abstract_name": "Brennenstuhl socket strip Secure-Tec 1159540376, 6-fold, anthracite",
            "id_product_abstract": 251,
            "type": "product_abstract",
            "add_to_cart_sku": "425086",
            "prices": {
                "DEFAULT": 3456
            },
            "abstract_sku": "M26415",
            "url": "\/en\/brennenstuhl-steckdosenleiste-secure-tec-1159540376-6fach-an-M26415"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 482,
                    "id_product_image": 1578,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1578",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007458Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007458Q",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1578,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1578
                }
            ],
            "id_product_labels": [],
            "price": 4304,
            "abstract_name": "Brennenstuhl socket strip SecureTec 1159490936, 8-fold, anthracite",
            "id_product_abstract": 252,
            "type": "product_abstract",
            "add_to_cart_sku": "425096",
            "prices": {
                "DEFAULT": 4304
            },
            "abstract_sku": "M26416",
            "url": "\/en\/brennenstuhl-steckdosenleiste-securetec-1159490936-8-fach-an-M26416"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 484,
                    "id_product_image": 1580,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1580",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007780Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007780Q",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1580,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1580
                }
            ],
            "id_product_labels": [],
            "price": 1637,
            "abstract_name": "Brennenstuhl socket strip Premium-Line 1951140100, 4-fold, black",
            "id_product_abstract": 253,
            "type": "product_abstract",
            "add_to_cart_sku": "425097",
            "prices": {
                "DEFAULT": 1637
            },
            "abstract_sku": "M26417",
            "url": "\/en\/brennenstuhl-steckdosenleiste-premium-line-1951140100-4fach-sw-M26417"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 6,
                    "id_product_image": 14,
                    "alt_text_small": "",
                    "product_image_key": "product_image_14",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522202FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522202FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 14,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 14
                },
                {
                    "fk_product_image_set": 6,
                    "id_product_image": 16,
                    "alt_text_small": "",
                    "product_image_key": "product_image_16",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052619-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052619-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 16,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 16
                }
            ],
            "id_product_labels": [],
            "price": 2625,
            "abstract_name": "HSM SECURIO document shredder - for desktop, 25 l, 300 watts",
            "id_product_abstract": 3,
            "type": "product_abstract",
            "add_to_cart_sku": "212440",
            "prices": {
                "DEFAULT": 2625
            },
            "abstract_sku": "M1000786",
            "url": "\/en\/hsm-aktenvernichter-securio-fuer-schreibtisch-25-l-300-watt-M1000786"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 8,
                    "id_product_image": 18,
                    "alt_text_small": "",
                    "product_image_key": "product_image_18",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048295-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00048295-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 18,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 18
                },
                {
                    "fk_product_image_set": 8,
                    "id_product_image": 20,
                    "alt_text_small": "",
                    "product_image_key": "product_image_20",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522206FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522206FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 20,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 20
                },
                {
                    "fk_product_image_set": 8,
                    "id_product_image": 22,
                    "alt_text_small": "",
                    "product_image_key": "product_image_22",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00031340-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00031340-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 22,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 22
                }
            ],
            "id_product_labels": [],
            "price": 12938,
            "abstract_name": "HSM SECURIO document shredder - for open-plan offices, 145 l, 1800 watts",
            "id_product_abstract": 4,
            "type": "product_abstract",
            "prices": {
                "DEFAULT": 12938
            },
            "abstract_sku": "M1000838",
            "url": "\/en\/hsm-aktenvernichter-securio-fuer-grossraumbuero-145-l-1800-watt-M1000838"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 16,
                    "id_product_image": 42,
                    "alt_text_small": "",
                    "product_image_key": "product_image_42",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522204FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522204FF-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 42,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 42
                },
                {
                    "fk_product_image_set": 16,
                    "id_product_image": 44,
                    "alt_text_small": "",
                    "product_image_key": "product_image_44",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052620-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052620-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 44,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 44
                }
            ],
            "id_product_labels": [],
            "price": 12975,
            "abstract_name": "HSM SECURIO document shredder - for desktop, 25 l, 400 watts",
            "id_product_abstract": 8,
            "type": "product_abstract",
            "add_to_cart_sku": "212837",
            "prices": {
                "DEFAULT": 12975
            },
            "abstract_sku": "M1006484",
            "url": "\/en\/hsm-aktenvernichter-securio-fuer-schreibtisch-25-l-400-watt-M1006484"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 96,
                    "alt_text_small": "",
                    "product_image_key": "product_image_96",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049521F-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049521F-02",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 96,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 96
                },
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 98,
                    "alt_text_small": "",
                    "product_image_key": "product_image_98",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907160FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907160FF-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 98,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 98
                },
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 100,
                    "alt_text_small": "",
                    "product_image_key": "product_image_100",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970138FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970138FF-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 100,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 100
                },
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 102,
                    "alt_text_small": "",
                    "product_image_key": "product_image_102",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049526-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00049526-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 102,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 102
                },
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 104,
                    "alt_text_small": "",
                    "product_image_key": "product_image_104",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907160II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00907160II-02",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 104,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 104
                },
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 106,
                    "alt_text_small": "",
                    "product_image_key": "product_image_106",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970138II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00970138II-02",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 106,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 106
                },
                {
                    "fk_product_image_set": 30,
                    "id_product_image": 108,
                    "alt_text_small": "",
                    "product_image_key": "product_image_108",
                    "updated_at": "2025-12-02 09:55:09.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95389-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK95389-01",
                    "created_at": "2025-12-02 09:55:09.000000",
                    "id_product_image_set_to_product_image": 108,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 108
                }
            ],
            "id_product_labels": [],
            "price": 4661,
            "abstract_name": "CP steel cabinet, fire-resistant - 3 adjustable shelves, 1 locker, width 1200 mm",
            "id_product_abstract": 15,
            "type": "product_abstract",
            "add_to_cart_sku": "574603",
            "prices": {
                "DEFAULT": 4661
            },
            "abstract_sku": "M1014502",
            "url": "\/en\/cp-stahlschrank-feuergeschuetzt-3-fachboeden-verstellbar-1-schliessfach-breite-1200-mm-M1014502"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 74,
                    "id_product_image": 214,
                    "alt_text_small": "",
                    "product_image_key": "product_image_214",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050088-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050088-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 214,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 214
                },
                {
                    "fk_product_image_set": 74,
                    "id_product_image": 216,
                    "alt_text_small": "",
                    "product_image_key": "product_image_216",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519711FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519711FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 216,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 216
                },
                {
                    "fk_product_image_set": 74,
                    "id_product_image": 218,
                    "alt_text_small": "",
                    "product_image_key": "product_image_218",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050076-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050076-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 218,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 218
                }
            ],
            "id_product_labels": [],
            "price": 43118,
            "abstract_name": "Mauser universal cabinet, extra-high - HxWxD 2200 x 950 x 420 mm",
            "id_product_abstract": 35,
            "type": "product_abstract",
            "add_to_cart_sku": "573939",
            "prices": {
                "DEFAULT": 43118
            },
            "abstract_sku": "M1018211",
            "url": "\/en\/mauser-universalschrank-extrahoch-hxbxt-2200-x-950-x-420-mm-M1018211"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 278,
                    "alt_text_small": "",
                    "product_image_key": "product_image_278",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050962-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00050962-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 278,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 278
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 280,
                    "alt_text_small": "",
                    "product_image_key": "product_image_280",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113318FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113318FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 280,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 280
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 282,
                    "alt_text_small": "",
                    "product_image_key": "product_image_282",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113319FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113319FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 282,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 282
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 284,
                    "alt_text_small": "",
                    "product_image_key": "product_image_284",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113320FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113320FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 284,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 284
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 286,
                    "alt_text_small": "",
                    "product_image_key": "product_image_286",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113321FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113321FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 286,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 286
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 288,
                    "alt_text_small": "",
                    "product_image_key": "product_image_288",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113322FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113322FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 288,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 288
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 290,
                    "alt_text_small": "",
                    "product_image_key": "product_image_290",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113323FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113323FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 290,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 290
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 292,
                    "alt_text_small": "",
                    "product_image_key": "product_image_292",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113324FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113324FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 292,
                    "sort_order": 15,
                    "alt_text_large": "",
                    "fk_product_image": 292
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 294,
                    "alt_text_small": "",
                    "product_image_key": "product_image_294",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113325FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113325FF-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 294,
                    "sort_order": 17,
                    "alt_text_large": "",
                    "fk_product_image": 294
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 296,
                    "alt_text_small": "",
                    "product_image_key": "product_image_296",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051115-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051115-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 296,
                    "sort_order": 19,
                    "alt_text_large": "",
                    "fk_product_image": 296
                },
                {
                    "fk_product_image_set": 88,
                    "id_product_image": 298,
                    "alt_text_small": "",
                    "product_image_key": "product_image_298",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113318II-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00113318II-03",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 298,
                    "sort_order": 21,
                    "alt_text_large": "",
                    "fk_product_image": 298
                }
            ],
            "id_product_labels": [],
            "price": 88798,
            "abstract_name": "Mauser sliding door cabinet - with glass front, 8 shelves, center separating wall",
            "id_product_abstract": 42,
            "type": "product_abstract",
            "add_to_cart_sku": "410102",
            "prices": {
                "DEFAULT": 88798
            },
            "abstract_sku": "M1024689",
            "url": "\/en\/mauser-schiebetuerschrank-mit-glasfront-8-fachboeden-mitteltrennwand-M1024689"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 420,
                    "alt_text_small": "",
                    "product_image_key": "product_image_420",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 420,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 420
                },
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 422,
                    "alt_text_small": "",
                    "product_image_key": "product_image_422",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-02",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 422,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 422
                },
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 424,
                    "alt_text_small": "",
                    "product_image_key": "product_image_424",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-03",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 424,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 424
                },
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 426,
                    "alt_text_small": "",
                    "product_image_key": "product_image_426",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-04?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-04",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 426,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 426
                },
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 428,
                    "alt_text_small": "",
                    "product_image_key": "product_image_428",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-05?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-05",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 428,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 428
                },
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 430,
                    "alt_text_small": "",
                    "product_image_key": "product_image_430",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-06?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-06",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 430,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 430
                },
                {
                    "fk_product_image_set": 110,
                    "id_product_image": 432,
                    "alt_text_small": "",
                    "product_image_key": "product_image_432",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-07?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111017II-07",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 432,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 432
                }
            ],
            "id_product_labels": [],
            "price": 19888,
            "abstract_name": "magnetoplan\u00ae Flipchart DE LUXE - mobile",
            "id_product_abstract": 53,
            "type": "product_abstract",
            "add_to_cart_sku": "408034",
            "prices": {
                "DEFAULT": 19888
            },
            "abstract_sku": "M1031236",
            "url": "\/en\/magnetoplan-flipchart-de-luxe-mobil-M1031236"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 112,
                    "id_product_image": 434,
                    "alt_text_small": "",
                    "product_image_key": "product_image_434",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 434,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 434
                },
                {
                    "fk_product_image_set": 112,
                    "id_product_image": 436,
                    "alt_text_small": "",
                    "product_image_key": "product_image_436",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-02",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 436,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 436
                },
                {
                    "fk_product_image_set": 112,
                    "id_product_image": 438,
                    "alt_text_small": "",
                    "product_image_key": "product_image_438",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-03",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 438,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 438
                },
                {
                    "fk_product_image_set": 112,
                    "id_product_image": 440,
                    "alt_text_small": "",
                    "product_image_key": "product_image_440",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-04?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00111092II-04",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 440,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 440
                }
            ],
            "id_product_labels": [],
            "price": 6224,
            "abstract_name": "magnetoplan\u00ae Flipchart JUNIOR SP - magnetic",
            "id_product_abstract": 54,
            "type": "product_abstract",
            "add_to_cart_sku": "408104",
            "prices": {
                "DEFAULT": 6224
            },
            "abstract_sku": "M1031238",
            "url": "\/en\/magnetoplan-flipchart-junior-sp-magnethaftend-M1031238"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 120,
                    "id_product_image": 470,
                    "alt_text_small": "",
                    "product_image_key": "product_image_470",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052642-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052642-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 470,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 470
                },
                {
                    "fk_product_image_set": 120,
                    "id_product_image": 472,
                    "alt_text_small": "",
                    "product_image_key": "product_image_472",
                    "updated_at": "2025-12-02 09:55:11.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052644-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00052644-01",
                    "created_at": "2025-12-02 09:55:11.000000",
                    "id_product_image_set_to_product_image": 472,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 472
                }
            ],
            "id_product_labels": [],
            "price": 19423,
            "abstract_name": "IDEAL desk document shredder, EASY-TOUCH professional equipping, height 428 mm",
            "id_product_abstract": 58,
            "type": "product_abstract",
            "add_to_cart_sku": "413852",
            "prices": {
                "DEFAULT": 19423
            },
            "abstract_sku": "M1079221",
            "url": "\/en\/ideal-schreibtisch-aktenvernichter-easy-touch-professionelle-ausstattung-hoehe-428-mm-M1079221"
        }
    ],
    "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": []
}
{}