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

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": 252,
        "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": "22"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 296,
                    "id_product_image": 1032,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1032",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007665P?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007665P",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1032,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1032
                },
                {
                    "fk_product_image_set": 296,
                    "id_product_image": 1034,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1034",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007665Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007665Q",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1034,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1034
                }
            ],
            "id_product_labels": [],
            "price": 775,
            "abstract_name": "Xlyne USB stick OTG   silver",
            "id_product_abstract": 151,
            "type": "product_abstract",
            "add_to_cart_sku": "422528",
            "prices": {
                "DEFAULT": 775
            },
            "abstract_sku": "M22232",
            "url": "\/en\/xlyne-usb-stick-otg-silber-M22232"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 300,
                    "id_product_image": 1038,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1038",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032740Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032740Q",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1038,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1038
                },
                {
                    "fk_product_image_set": 300,
                    "id_product_image": 1040,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1040",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032740O?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032740O",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1040,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1040
                },
                {
                    "fk_product_image_set": 300,
                    "id_product_image": 1042,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1042",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032740P?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032740P",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1042,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1042
                },
                {
                    "fk_product_image_set": 300,
                    "id_product_image": 1044,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1044",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007408D?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007408D",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1044,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1044
                }
            ],
            "id_product_labels": [],
            "price": 180,
            "abstract_name": "Soennecken notepad DIN 60 g, checkered, 50 sheets, white",
            "id_product_abstract": 153,
            "type": "product_abstract",
            "add_to_cart_sku": "423383",
            "prices": {
                "DEFAULT": 180
            },
            "abstract_sku": "M22293",
            "url": "\/en\/soennecken-notizblock-din-60g-kariert-50blatt-weiss-M22293"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 302,
                    "id_product_image": 1046,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1046",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003020A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003020A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1046,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1046
                }
            ],
            "id_product_labels": [],
            "price": 376,
            "abstract_name": "Soennecken ballpoint pen 3239 No. 300 stainless steel giant refill, blue",
            "id_product_abstract": 154,
            "type": "product_abstract",
            "add_to_cart_sku": "422721",
            "prices": {
                "DEFAULT": 376
            },
            "abstract_sku": "M22397",
            "url": "\/en\/soennecken-kugelschreiber-3239-nr-300-edelstahl-grossraummine-blau-M22397"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1048,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1048",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016958T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016958T",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1048,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1048
                },
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1050,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1050",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016958U?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S016958U",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1050,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1050
                },
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1052,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1052",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118L",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1052,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1052
                },
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1054,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1054",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118S",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1054,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1054
                },
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1056,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1056",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118N?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118N",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1056,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1056
                },
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1058,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1058",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118R",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1058,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 1058
                },
                {
                    "fk_product_image_set": 304,
                    "id_product_image": 1060,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1060",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007118T",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1060,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 1060
                }
            ],
            "id_product_labels": [],
            "price": 48,
            "abstract_name": "Soennecken text market 2-5 mm chisel tip",
            "id_product_abstract": 155,
            "type": "product_abstract",
            "add_to_cart_sku": "422722",
            "prices": {
                "DEFAULT": 48
            },
            "abstract_sku": "M22398",
            "url": "\/en\/soennecken-textmarker-2-5mm-keilspitze-M22398"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 306,
                    "id_product_image": 1062,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1062",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104009I?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104009I",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1062,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1062
                }
            ],
            "id_product_labels": [],
            "price": 734,
            "abstract_name": "Soennecken copy paper Star DIN 80 g, white, 500 sheets\/pack.",
            "id_product_abstract": 156,
            "type": "product_abstract",
            "add_to_cart_sku": "422741",
            "prices": {
                "DEFAULT": 734
            },
            "abstract_sku": "M22410",
            "url": "\/en\/soennecken-kopierpapier-star-din-80g-weiss-500-bl-pack-M22410"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 308,
                    "id_product_image": 1064,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1064",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003705B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003705B",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1064,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1064
                }
            ],
            "id_product_labels": [],
            "price": 734,
            "abstract_name": "Soennecken copy paper Brilliant 5800 DIN A4 80 g, white, 500 sheets\/pack.",
            "id_product_abstract": 157,
            "type": "product_abstract",
            "add_to_cart_sku": "422743",
            "prices": {
                "DEFAULT": 734
            },
            "abstract_sku": "M22411",
            "url": "\/en\/soennecken-kopierpapier-brillant-5800-din-a4-80g-weiss-500-bl-pack-M22411"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 310,
                    "id_product_image": 1066,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1066",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003002A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003002A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1066,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1066
                }
            ],
            "id_product_labels": [],
            "price": 1259,
            "abstract_name": "Soennecken copy paper Special DIN 80 g, white, 500 sheets\/pack.",
            "id_product_abstract": 158,
            "type": "product_abstract",
            "add_to_cart_sku": "422745",
            "prices": {
                "DEFAULT": 1259
            },
            "abstract_sku": "M22412",
            "url": "\/en\/soennecken-kopierpapier-spezial-din-80g-weiss-500-bl-pack-M22412"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 312,
                    "id_product_image": 1068,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1068",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003003A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003003A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1068,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1068
                },
                {
                    "fk_product_image_set": 312,
                    "id_product_image": 1070,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1070",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007409E?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007409E",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1070,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1070
                }
            ],
            "id_product_labels": [],
            "price": 576,
            "abstract_name": "Soennecken copy paper Standard DIN 80 g, white, 500 sheets\/pack.",
            "id_product_abstract": 159,
            "type": "product_abstract",
            "prices": {
                "DEFAULT": 576
            },
            "abstract_sku": "M22432",
            "url": "\/en\/soennecken-kopierpapier-standard-din-80g-weiss-500-bl-pack-M22432"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 314,
                    "id_product_image": 1072,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1072",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003006H?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003006H",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1072,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1072
                },
                {
                    "fk_product_image_set": 314,
                    "id_product_image": 1074,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1074",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007120F?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007120F",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1074,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1074
                }
            ],
            "id_product_labels": [],
            "price": 90,
            "abstract_name": "Soennecken fine refill   HB 12 pieces\/pack.",
            "id_product_abstract": 160,
            "type": "product_abstract",
            "add_to_cart_sku": "422855",
            "prices": {
                "DEFAULT": 90
            },
            "abstract_sku": "M22484",
            "url": "\/en\/soennecken-feinmine-hb-12-st-pack-M22484"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 318,
                    "id_product_image": 1088,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1088",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003050A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S003050A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1088,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1088
                },
                {
                    "fk_product_image_set": 318,
                    "id_product_image": 1090,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1090",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S038702A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S038702A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1090,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1090
                },
                {
                    "fk_product_image_set": 318,
                    "id_product_image": 1092,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1092",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032798H?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032798H",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1092,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1092
                },
                {
                    "fk_product_image_set": 318,
                    "id_product_image": 1094,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1094",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032798I?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032798I",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1094,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1094
                },
                {
                    "fk_product_image_set": 318,
                    "id_product_image": 1096,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1096",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S038702B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S038702B",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1096,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1096
                }
            ],
            "id_product_labels": [],
            "price": 208,
            "abstract_name": "Soennecken disposable pens No. 1 M 10 pieces\/pack.",
            "id_product_abstract": 162,
            "type": "product_abstract",
            "add_to_cart_sku": "423105",
            "prices": {
                "DEFAULT": 208
            },
            "abstract_sku": "M22613",
            "url": "\/en\/soennecken-einwegkugelschreiber-nr-1-m-10-st-pack-M22613"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 320,
                    "id_product_image": 1098,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1098",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415C",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1098,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1098
                },
                {
                    "fk_product_image_set": 320,
                    "id_product_image": 1100,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1100",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032982G?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B032982G",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1100,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1100
                },
                {
                    "fk_product_image_set": 320,
                    "id_product_image": 1102,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1102",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415F?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415F",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1102,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1102
                },
                {
                    "fk_product_image_set": 320,
                    "id_product_image": 1104,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1104",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415B",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1104,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1104
                },
                {
                    "fk_product_image_set": 320,
                    "id_product_image": 1106,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1106",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415D?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007415D",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1106,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 1106
                }
            ],
            "id_product_labels": [],
            "price": 99,
            "abstract_name": "Soennecken permanent marker 1-4 mm chisel tip",
            "id_product_abstract": 167,
            "type": "product_abstract",
            "add_to_cart_sku": "423178",
            "prices": {
                "DEFAULT": 99
            },
            "abstract_sku": "M22664",
            "url": "\/en\/soennecken-permanentmarker-1-4mm-keilspitze-M22664"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 326,
                    "id_product_image": 1116,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1116",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006304C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006304C",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1116,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1116
                },
                {
                    "fk_product_image_set": 326,
                    "id_product_image": 1118,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1118",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006304B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006304B",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1118,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1118
                },
                {
                    "fk_product_image_set": 326,
                    "id_product_image": 1120,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1120",
                    "updated_at": "2025-12-02 09:55:15.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006304A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006304A",
                    "created_at": "2025-12-02 09:55:15.000000",
                    "id_product_image_set_to_product_image": 1120,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1120
                }
            ],
            "id_product_labels": [],
            "price": 104,
            "abstract_name": "Soennecken ballpoint pen No. 180 printing mechanism M",
            "id_product_abstract": 170,
            "type": "product_abstract",
            "add_to_cart_sku": "423456",
            "prices": {
                "DEFAULT": 104
            },
            "abstract_sku": "M22797",
            "url": "\/en\/soennecken-kugelschreiber-nr-180-druckmechanik-m-M22797"
        }
    ],
    "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": []
}
{}