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

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": 216,
        "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": "19"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 218,
                    "id_product_image": 848,
                    "alt_text_small": "",
                    "product_image_key": "product_image_848",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846R",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 848,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 848
                }
            ],
            "id_product_labels": [],
            "price": 1428,
            "abstract_name": "Oxford Collegeblock International Organizerbook 100102777, checkered",
            "id_product_abstract": 108,
            "type": "product_abstract",
            "add_to_cart_sku": "421245",
            "prices": {
                "DEFAULT": 1428
            },
            "abstract_sku": "M21635",
            "url": "\/en\/oxford-collegeblock-international-organizerbook-100102777-kariert-M21635"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 220,
                    "id_product_image": 850,
                    "alt_text_small": "",
                    "product_image_key": "product_image_850",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846M",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 850,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 850
                },
                {
                    "fk_product_image_set": 220,
                    "id_product_image": 852,
                    "alt_text_small": "",
                    "product_image_key": "product_image_852",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007849W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007849W",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 852,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 852
                },
                {
                    "fk_product_image_set": 220,
                    "id_product_image": 854,
                    "alt_text_small": "",
                    "product_image_key": "product_image_854",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007849X?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007849X",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 854,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 854
                },
                {
                    "fk_product_image_set": 220,
                    "id_product_image": 856,
                    "alt_text_small": "",
                    "product_image_key": "product_image_856",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007849Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007849Y",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 856,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 856
                }
            ],
            "id_product_labels": [],
            "price": 995,
            "abstract_name": "Oxford notebook 100100570 DIN A4 checkered, 96 sheets, sorted",
            "id_product_abstract": 109,
            "type": "product_abstract",
            "add_to_cart_sku": "421246",
            "prices": {
                "DEFAULT": 995
            },
            "abstract_sku": "M21636",
            "url": "\/en\/oxford-kladde-100100570-din-a4-kariert-96blatt-sortiert-M21636"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 222,
                    "id_product_image": 858,
                    "alt_text_small": "",
                    "product_image_key": "product_image_858",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845X?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845X",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 858,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 858
                },
                {
                    "fk_product_image_set": 222,
                    "id_product_image": 860,
                    "alt_text_small": "",
                    "product_image_key": "product_image_860",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845Y",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 860,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 860
                },
                {
                    "fk_product_image_set": 222,
                    "id_product_image": 862,
                    "alt_text_small": "",
                    "product_image_key": "product_image_862",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845Z?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007845Z",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 862,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 862
                },
                {
                    "fk_product_image_set": 222,
                    "id_product_image": 864,
                    "alt_text_small": "",
                    "product_image_key": "product_image_864",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846A",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 864,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 864
                },
                {
                    "fk_product_image_set": 222,
                    "id_product_image": 866,
                    "alt_text_small": "",
                    "product_image_key": "product_image_866",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846B",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 866,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 866
                },
                {
                    "fk_product_image_set": 222,
                    "id_product_image": 868,
                    "alt_text_small": "",
                    "product_image_key": "product_image_868",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846C",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 868,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 868
                }
            ],
            "id_product_labels": [],
            "price": 560,
            "abstract_name": "Oxford Collegeblock 100104341 DIN A5, checkered, 90 sheets",
            "id_product_abstract": 110,
            "type": "product_abstract",
            "add_to_cart_sku": "421247",
            "prices": {
                "DEFAULT": 560
            },
            "abstract_sku": "M21637",
            "url": "\/en\/oxford-collegeblock-100104341-din-a5-kariert-90blatt-M21637"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 224,
                    "id_product_image": 870,
                    "alt_text_small": "",
                    "product_image_key": "product_image_870",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007846B",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 870,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 870
                }
            ],
            "id_product_labels": [],
            "price": 689,
            "abstract_name": "Oxford Collegeblock Activebook 100101421 DIN A4, checkered, 90 sheets",
            "id_product_abstract": 111,
            "type": "product_abstract",
            "add_to_cart_sku": "421248",
            "prices": {
                "DEFAULT": 689
            },
            "abstract_sku": "M21638",
            "url": "\/en\/oxford-collegeblock-activebook-100101421-din-a4-kariert-90blatt-M21638"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 226,
                    "id_product_image": 872,
                    "alt_text_small": "",
                    "product_image_key": "product_image_872",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007077R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007077R",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 872,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 872
                }
            ],
            "id_product_labels": [],
            "price": 255,
            "abstract_name": "BIC multi-color ballpoint pen, 4 colors, 831253 0.4 mm blue\/black\/red\/green",
            "id_product_abstract": 112,
            "type": "product_abstract",
            "add_to_cart_sku": "421261",
            "prices": {
                "DEFAULT": 255
            },
            "abstract_sku": "M21646",
            "url": "\/en\/bic-mehrfarbkugelschreiber-4-colours-831253-0-4mm-bl-sw-r-gn-M21646"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 228,
                    "id_product_image": 874,
                    "alt_text_small": "",
                    "product_image_key": "product_image_874",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007349G?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007349G",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 874,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 874
                },
                {
                    "fk_product_image_set": 228,
                    "id_product_image": 876,
                    "alt_text_small": "",
                    "product_image_key": "product_image_876",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007414I?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007414I",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 876,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 876
                },
                {
                    "fk_product_image_set": 228,
                    "id_product_image": 878,
                    "alt_text_small": "",
                    "product_image_key": "product_image_878",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007487L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007487L",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 878,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 878
                }
            ],
            "id_product_labels": [],
            "price": 846,
            "abstract_name": "BIC ballpoint pen 2in1 stylus 919378, 0.4 mm, black",
            "id_product_abstract": 113,
            "type": "product_abstract",
            "add_to_cart_sku": "421263",
            "prices": {
                "DEFAULT": 846
            },
            "abstract_sku": "M21648",
            "url": "\/en\/bic-kugelschreiber-2in1-stylus-919378-0-4mm-schwarz-M21648"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 230,
                    "id_product_image": 880,
                    "alt_text_small": "",
                    "product_image_key": "product_image_880",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007751J?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007751J",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 880,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 880
                },
                {
                    "fk_product_image_set": 230,
                    "id_product_image": 882,
                    "alt_text_small": "",
                    "product_image_key": "product_image_882",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007909S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007909S",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 882,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 882
                }
            ],
            "id_product_labels": [],
            "price": 541,
            "abstract_name": "BIC multi-color ballpoint pen, 4 colors STYLUS 926404 Touchpen",
            "id_product_abstract": 114,
            "type": "product_abstract",
            "add_to_cart_sku": "421265",
            "prices": {
                "DEFAULT": 541
            },
            "abstract_sku": "M21650",
            "url": "\/en\/bic-mehrfarbkugelschreiber-4-colours-stylus-926404-touchpen-M21650"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 232,
                    "id_product_image": 884,
                    "alt_text_small": "",
                    "product_image_key": "product_image_884",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104010Z?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104010Z",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 884,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 884
                }
            ],
            "id_product_labels": [],
            "price": 620,
            "abstract_name": "HP copy paper printing CHP210 DIN A4 80 g, white, 500 sheets\/pack.",
            "id_product_abstract": 115,
            "type": "product_abstract",
            "add_to_cart_sku": "421322",
            "prices": {
                "DEFAULT": 620
            },
            "abstract_sku": "M21679",
            "url": "\/en\/hp-kopierpapier-printing-chp210-din-a4-80g-weiss-500-bl-pack-M21679"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 234,
                    "id_product_image": 886,
                    "alt_text_small": "",
                    "product_image_key": "product_image_886",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/H009197G?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/H009197G",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 886,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 886
                }
            ],
            "id_product_labels": [],
            "price": 530,
            "abstract_name": "HP copy paper Office CHP110 DIN A4 80 g, white, 500 sheets\/pack.",
            "id_product_abstract": 116,
            "type": "product_abstract",
            "add_to_cart_sku": "421323",
            "prices": {
                "DEFAULT": 530
            },
            "abstract_sku": "M21680",
            "url": "\/en\/hp-kopierpapier-office-chp110-din-a4-80g-weiss-500-bl-pack-M21680"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 236,
                    "id_product_image": 888,
                    "alt_text_small": "",
                    "product_image_key": "product_image_888",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007741K?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007741K",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 888,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 888
                },
                {
                    "fk_product_image_set": 236,
                    "id_product_image": 890,
                    "alt_text_small": "",
                    "product_image_key": "product_image_890",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104010Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/S104010Y",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 890,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 890
                }
            ],
            "id_product_labels": [],
            "price": 620,
            "abstract_name": "HP copy paper Copy Paper CHP910 DIN A4 80 g, white, 500 sheets\/pack.",
            "id_product_abstract": 117,
            "type": "product_abstract",
            "add_to_cart_sku": "421324",
            "prices": {
                "DEFAULT": 620
            },
            "abstract_sku": "M21681",
            "url": "\/en\/hp-kopierpapier-copy-paper-chp910-din-a4-80g-weiss-500-bl-pack-M21681"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 238,
                    "id_product_image": 892,
                    "alt_text_small": "",
                    "product_image_key": "product_image_892",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006080J?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006080J",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 892,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 892
                }
            ],
            "id_product_labels": [],
            "price": 314,
            "abstract_name": "Clairefontaine Collegeblock Forever Recycling DIN A4",
            "id_product_abstract": 118,
            "type": "product_abstract",
            "add_to_cart_sku": "421327",
            "prices": {
                "DEFAULT": 314
            },
            "abstract_sku": "M21684",
            "url": "\/en\/clairefontaine-collegeblock-forever-recycling-din-a4-M21684"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 240,
                    "id_product_image": 894,
                    "alt_text_small": "",
                    "product_image_key": "product_image_894",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010192C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010192C",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 894,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 894
                },
                {
                    "fk_product_image_set": 240,
                    "id_product_image": 896,
                    "alt_text_small": "",
                    "product_image_key": "product_image_896",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706C",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 896,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 896
                },
                {
                    "fk_product_image_set": 240,
                    "id_product_image": 898,
                    "alt_text_small": "",
                    "product_image_key": "product_image_898",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706D?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010706D",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 898,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 898
                }
            ],
            "id_product_labels": [],
            "price": 777,
            "abstract_name": "Clairefontaine notebook DIN A5, 96 sheets, sorted",
            "id_product_abstract": 123,
            "type": "product_abstract",
            "add_to_cart_sku": "421347",
            "prices": {
                "DEFAULT": 777
            },
            "abstract_sku": "M21694",
            "url": "\/en\/clairefontaine-kladde-din-a5-90g-96blatt-sortiert-M21694"
        }
    ],
    "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": []
}
{}