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

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": 240,
        "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": "21"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 268,
                    "id_product_image": 948,
                    "alt_text_small": "",
                    "product_image_key": "product_image_948",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005H?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109005H",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 948,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 948
                }
            ],
            "id_product_labels": [],
            "price": 393,
            "abstract_name": "rotring mechanical pencil Tikky RD 1904697, 1 mm, black",
            "id_product_abstract": 137,
            "type": "product_abstract",
            "add_to_cart_sku": "421478",
            "prices": {
                "DEFAULT": 393
            },
            "abstract_sku": "M21743",
            "url": "\/en\/rotring-druckbleistift-tikky-rd-1904697-1mm-schwarz-M21743"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 270,
                    "id_product_image": 950,
                    "alt_text_small": "",
                    "product_image_key": "product_image_950",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007075H?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007075H",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 950,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 950
                },
                {
                    "fk_product_image_set": 270,
                    "id_product_image": 952,
                    "alt_text_small": "",
                    "product_image_key": "product_image_952",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007075G?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007075G",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 952,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 952
                }
            ],
            "id_product_labels": [],
            "price": 442,
            "abstract_name": "rotring ballpoint pen Tikky Redesign M",
            "id_product_abstract": 138,
            "type": "product_abstract",
            "add_to_cart_sku": "421479",
            "prices": {
                "DEFAULT": 442
            },
            "abstract_sku": "M21744",
            "url": "\/en\/rotring-kugelschreiber-tikky-redesign-m-M21744"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 272,
                    "id_product_image": 954,
                    "alt_text_small": "",
                    "product_image_key": "product_image_954",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109002W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S109002W",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 954,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 954
                }
            ],
            "id_product_labels": [],
            "price": 1182,
            "abstract_name": "rotring mechanical pencil Tikky S0801310, 3 pieces\/pack",
            "id_product_abstract": 139,
            "type": "product_abstract",
            "add_to_cart_sku": "421481",
            "prices": {
                "DEFAULT": 1182
            },
            "abstract_sku": "M21745",
            "url": "\/en\/rotring-druckbleistift-tikky-s0801310-3-st-pack-M21745"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 276,
                    "id_product_image": 960,
                    "alt_text_small": "",
                    "product_image_key": "product_image_960",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070D?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070D",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 960,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 960
                },
                {
                    "fk_product_image_set": 276,
                    "id_product_image": 962,
                    "alt_text_small": "",
                    "product_image_key": "product_image_962",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070G?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070G",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 962,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 962
                },
                {
                    "fk_product_image_set": 276,
                    "id_product_image": 964,
                    "alt_text_small": "",
                    "product_image_key": "product_image_964",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070F?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070F",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 964,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 964
                }
            ],
            "id_product_labels": [],
            "price": 271,
            "abstract_name": "Papermate ballpoint pen InkJoy 700 RT M printing mechanism",
            "id_product_abstract": 141,
            "type": "product_abstract",
            "prices": {
                "DEFAULT": 271
            },
            "abstract_sku": "M21766",
            "url": "\/en\/papermate-kugelschreiber-inkjoy-700-rt-m-druckmechanik-M21766"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 278,
                    "id_product_image": 966,
                    "alt_text_small": "",
                    "product_image_key": "product_image_966",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070U?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070U",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 966,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 966
                },
                {
                    "fk_product_image_set": 278,
                    "id_product_image": 968,
                    "alt_text_small": "",
                    "product_image_key": "product_image_968",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070S",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 968,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 968
                },
                {
                    "fk_product_image_set": 278,
                    "id_product_image": 970,
                    "alt_text_small": "",
                    "product_image_key": "product_image_970",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070V?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070V",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 970,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 970
                },
                {
                    "fk_product_image_set": 278,
                    "id_product_image": 972,
                    "alt_text_small": "",
                    "product_image_key": "product_image_972",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070T",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 972,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 972
                },
                {
                    "fk_product_image_set": 278,
                    "id_product_image": 974,
                    "alt_text_small": "",
                    "product_image_key": "product_image_974",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007070W",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 974,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 974
                }
            ],
            "id_product_labels": [],
            "price": 261,
            "abstract_name": "Papermate ballpoint pen InkJoy 550 RT M printing mechanism",
            "id_product_abstract": 142,
            "type": "product_abstract",
            "add_to_cart_sku": "421530",
            "prices": {
                "DEFAULT": 261
            },
            "abstract_sku": "M21771",
            "url": "\/en\/papermate-kugelschreiber-inkjoy-550-rt-m-druckmechanik-M21771"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 280,
                    "id_product_image": 976,
                    "alt_text_small": "",
                    "product_image_key": "product_image_976",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/R005702B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/R005702B",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 976,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 976
                }
            ],
            "id_product_labels": [],
            "price": 3642,
            "abstract_name": "rotring fountain pen rapidograph S0194270, 0.25 mm, black",
            "id_product_abstract": 143,
            "type": "product_abstract",
            "add_to_cart_sku": "421531",
            "prices": {
                "DEFAULT": 3642
            },
            "abstract_sku": "M21772",
            "url": "\/en\/rotring-tuschefueller-rapidograph-s0194270-0-25mm-schwarz-M21772"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 282,
                    "id_product_image": 978,
                    "alt_text_small": "",
                    "product_image_key": "product_image_978",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/R005702D?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/R005702D",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 978,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 978
                },
                {
                    "fk_product_image_set": 282,
                    "id_product_image": 980,
                    "alt_text_small": "",
                    "product_image_key": "product_image_980",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/R005702A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/R005702A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 980,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 980
                }
            ],
            "id_product_labels": [],
            "price": 4168,
            "abstract_name": "rotring fountain pen rapidograph    red",
            "id_product_abstract": 144,
            "type": "product_abstract",
            "add_to_cart_sku": "421533",
            "prices": {
                "DEFAULT": 4168
            },
            "abstract_sku": "M21773",
            "url": "\/en\/rotring-tuschefueller-rapidograph-rot-M21773"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 284,
                    "id_product_image": 982,
                    "alt_text_small": "",
                    "product_image_key": "product_image_982",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006264B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006264B",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 982,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 982
                },
                {
                    "fk_product_image_set": 284,
                    "id_product_image": 984,
                    "alt_text_small": "",
                    "product_image_key": "product_image_984",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006264A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006264A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 984,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 984
                }
            ],
            "id_product_labels": [],
            "price": 1678,
            "abstract_name": "rotring multi-function pen Tikky",
            "id_product_abstract": 145,
            "type": "product_abstract",
            "add_to_cart_sku": "421534",
            "prices": {
                "DEFAULT": 1678
            },
            "abstract_sku": "M21774",
            "url": "\/en\/rotring-multifunktionsstift-tikky-M21774"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 286,
                    "id_product_image": 986,
                    "alt_text_small": "",
                    "product_image_key": "product_image_986",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007021O?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007021O",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 986,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 986
                },
                {
                    "fk_product_image_set": 286,
                    "id_product_image": 988,
                    "alt_text_small": "",
                    "product_image_key": "product_image_988",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/V005518Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/V005518Q",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 988,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 988
                }
            ],
            "id_product_labels": [],
            "price": 1437,
            "abstract_name": "Veloflex table flipchart 4101080 DIN A4 crosswise, 4 rings, 10 covers, black",
            "id_product_abstract": 146,
            "type": "product_abstract",
            "add_to_cart_sku": "421538",
            "prices": {
                "DEFAULT": 1437
            },
            "abstract_sku": "M21777",
            "url": "\/en\/veloflex-tischflipchart-4101080-din-a4-quer-4ringe-10huellen-schwarz-M21777"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 288,
                    "id_product_image": 990,
                    "alt_text_small": "",
                    "product_image_key": "product_image_990",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007039A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007039A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 990,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 990
                }
            ],
            "id_product_labels": [],
            "price": 1437,
            "abstract_name": "Veloflex table flipchart V4102080 DIN A4 crosswise 4 rings, 10 covers, black",
            "id_product_abstract": 147,
            "type": "product_abstract",
            "add_to_cart_sku": "421539",
            "prices": {
                "DEFAULT": 1437
            },
            "abstract_sku": "M21778",
            "url": "\/en\/veloflex-tischflipchart-v4102080-din-a4-hoch-4ringe-10huellen-schwarz-M21778"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 292,
                    "id_product_image": 994,
                    "alt_text_small": "",
                    "product_image_key": "product_image_994",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006025J?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006025J",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 994,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 994
                },
                {
                    "fk_product_image_set": 292,
                    "id_product_image": 996,
                    "alt_text_small": "",
                    "product_image_key": "product_image_996",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006025K?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006025K",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 996,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 996
                },
                {
                    "fk_product_image_set": 292,
                    "id_product_image": 998,
                    "alt_text_small": "",
                    "product_image_key": "product_image_998",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007081L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007081L",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 998,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 998
                },
                {
                    "fk_product_image_set": 292,
                    "id_product_image": 1000,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1000",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007987T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007987T",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1000,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1000
                },
                {
                    "fk_product_image_set": 292,
                    "id_product_image": 1002,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1002",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006686O?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006686O",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1002,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1002
                }
            ],
            "id_product_labels": [],
            "price": 1080,
            "abstract_name": "MAUL ballpoint pen stand 10.6x13.8x11.2 cm, plastic",
            "id_product_abstract": 149,
            "type": "product_abstract",
            "add_to_cart_sku": "421768",
            "prices": {
                "DEFAULT": 1080
            },
            "abstract_sku": "M21903",
            "url": "\/en\/maul-kugelschreiberstaender-10-6x13-8x11-2cm-kunststoff-M21903"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1004,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1004",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606R",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1004,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1004
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1006,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1006",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007607A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007607A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1006,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1006
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1008,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1008",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606J?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606J",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1008,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1008
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1010,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1010",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606Q",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1010,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1010
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1012,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1012",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606K?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606K",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1012,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1012
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1014,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1014",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606M",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1014,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 1014
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1016,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1016",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606L",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1016,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 1016
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1018,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1018",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606O?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606O",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1018,
                    "sort_order": 15,
                    "alt_text_large": "",
                    "fk_product_image": 1018
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1020,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1020",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606S",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1020,
                    "sort_order": 17,
                    "alt_text_large": "",
                    "fk_product_image": 1020
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1022,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1022",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606X?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606X",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1022,
                    "sort_order": 19,
                    "alt_text_large": "",
                    "fk_product_image": 1022
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1024,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1024",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606N?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606N",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1024,
                    "sort_order": 21,
                    "alt_text_large": "",
                    "fk_product_image": 1024
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1026,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1026",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606P?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606P",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1026,
                    "sort_order": 23,
                    "alt_text_large": "",
                    "fk_product_image": 1026
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1028,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1028",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606T",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1028,
                    "sort_order": 25,
                    "alt_text_large": "",
                    "fk_product_image": 1028
                },
                {
                    "fk_product_image_set": 294,
                    "id_product_image": 1030,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1030",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606U?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007606U",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1030,
                    "sort_order": 27,
                    "alt_text_large": "",
                    "fk_product_image": 1030
                }
            ],
            "id_product_labels": [],
            "price": 1049,
            "abstract_name": "USB stick clip\/me 4GB 2.0",
            "id_product_abstract": 150,
            "type": "product_abstract",
            "add_to_cart_sku": "422524",
            "prices": {
                "DEFAULT": 1049
            },
            "abstract_sku": "M22230",
            "url": "\/en\/usb-stick-clip-me-4gb-2-0-M22230"
        }
    ],
    "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": []
}
{}