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

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": 204,
        "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": "18"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 194,
                    "id_product_image": 752,
                    "alt_text_small": "",
                    "product_image_key": "product_image_752",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006103Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006103Q",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 752,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 752
                },
                {
                    "fk_product_image_set": 194,
                    "id_product_image": 754,
                    "alt_text_small": "",
                    "product_image_key": "product_image_754",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007732U?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007732U",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 754,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 754
                },
                {
                    "fk_product_image_set": 194,
                    "id_product_image": 756,
                    "alt_text_small": "",
                    "product_image_key": "product_image_756",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006103P?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006103P",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 756,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 756
                },
                {
                    "fk_product_image_set": 194,
                    "id_product_image": 758,
                    "alt_text_small": "",
                    "product_image_key": "product_image_758",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007732T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007732T",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 758,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 758
                }
            ],
            "id_product_labels": [],
            "price": 580,
            "abstract_name": "Post-it Index Strong adhesive stripes, 3 x 22 sheets\/pack",
            "id_product_abstract": 96,
            "type": "product_abstract",
            "add_to_cart_sku": "420692",
            "prices": {
                "DEFAULT": 580
            },
            "abstract_sku": "M21194",
            "url": "\/en\/post-it-haftstreifen-index-strong-3x22-st-pack-M21194"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 196,
                    "id_product_image": 760,
                    "alt_text_small": "",
                    "product_image_key": "product_image_760",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007353R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007353R",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 760,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 760
                },
                {
                    "fk_product_image_set": 196,
                    "id_product_image": 762,
                    "alt_text_small": "",
                    "product_image_key": "product_image_762",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007380I?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007380I",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 762,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 762
                },
                {
                    "fk_product_image_set": 196,
                    "id_product_image": 764,
                    "alt_text_small": "",
                    "product_image_key": "product_image_764",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007749Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007749Y",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 764,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 764
                }
            ],
            "id_product_labels": [],
            "price": 422,
            "abstract_name": "Post-it Page Marker adhesive stripes, 670-10AB 12.7x44.4 mm, 10 pieces\/pack.",
            "id_product_abstract": 97,
            "type": "product_abstract",
            "add_to_cart_sku": "420694",
            "prices": {
                "DEFAULT": 422
            },
            "abstract_sku": "M21195",
            "url": "\/en\/post-it-haftstreifen-page-marker-670-10ab-12-7x44-4mm-10-st-pack-M21195"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 198,
                    "id_product_image": 766,
                    "alt_text_small": "",
                    "product_image_key": "product_image_766",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007353S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007353S",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 766,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 766
                },
                {
                    "fk_product_image_set": 198,
                    "id_product_image": 768,
                    "alt_text_small": "",
                    "product_image_key": "product_image_768",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007353T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007353T",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 768,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 768
                },
                {
                    "fk_product_image_set": 198,
                    "id_product_image": 770,
                    "alt_text_small": "",
                    "product_image_key": "product_image_770",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007644S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007644S",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 770,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 770
                },
                {
                    "fk_product_image_set": 198,
                    "id_product_image": 772,
                    "alt_text_small": "",
                    "product_image_key": "product_image_772",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007609L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007609L",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 772,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 772
                },
                {
                    "fk_product_image_set": 198,
                    "id_product_image": 774,
                    "alt_text_small": "",
                    "product_image_key": "product_image_774",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007644R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007644R",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 774,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 774
                }
            ],
            "id_product_labels": [],
            "price": 945,
            "abstract_name": "Post-it Super Sticky sticky notes, 6 pieces\/pack.",
            "id_product_abstract": 98,
            "type": "product_abstract",
            "add_to_cart_sku": "420695",
            "prices": {
                "DEFAULT": 945
            },
            "abstract_sku": "M21196",
            "url": "\/en\/post-it-haftnotiz-super-sticky-sortiert-6-st-pack-M21196"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 200,
                    "id_product_image": 776,
                    "alt_text_small": "",
                    "product_image_key": "product_image_776",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007357V?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007357V",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 776,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 776
                },
                {
                    "fk_product_image_set": 200,
                    "id_product_image": 778,
                    "alt_text_small": "",
                    "product_image_key": "product_image_778",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007644T?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007644T",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 778,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 778
                }
            ],
            "id_product_labels": [],
            "price": 1231,
            "abstract_name": "Post-it stick note Super Sticky, 62212SE sorted 12 pieces\/pack.",
            "id_product_abstract": 99,
            "type": "product_abstract",
            "add_to_cart_sku": "420696",
            "prices": {
                "DEFAULT": 1231
            },
            "abstract_sku": "M21197",
            "url": "\/en\/post-it-haftnotiz-super-sticky-62212se-sortiert-12-st-pack-M21197"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 780,
                    "alt_text_small": "",
                    "product_image_key": "product_image_780",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289M",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 780,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 780
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 782,
                    "alt_text_small": "",
                    "product_image_key": "product_image_782",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006315A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006315A",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 782,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 782
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 784,
                    "alt_text_small": "",
                    "product_image_key": "product_image_784",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007553X?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007553X",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 784,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 784
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 786,
                    "alt_text_small": "",
                    "product_image_key": "product_image_786",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289L?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289L",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 786,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 786
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 788,
                    "alt_text_small": "",
                    "product_image_key": "product_image_788",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554C?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554C",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 788,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 788
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 790,
                    "alt_text_small": "",
                    "product_image_key": "product_image_790",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289K?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289K",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 790,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 790
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 792,
                    "alt_text_small": "",
                    "product_image_key": "product_image_792",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007553Z?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007553Z",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 792,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 792
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 794,
                    "alt_text_small": "",
                    "product_image_key": "product_image_794",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554M",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 794,
                    "sort_order": 15,
                    "alt_text_large": "",
                    "fk_product_image": 794
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 796,
                    "alt_text_small": "",
                    "product_image_key": "product_image_796",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289I?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289I",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 796,
                    "sort_order": 17,
                    "alt_text_large": "",
                    "fk_product_image": 796
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 798,
                    "alt_text_small": "",
                    "product_image_key": "product_image_798",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554B?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554B",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 798,
                    "sort_order": 19,
                    "alt_text_large": "",
                    "fk_product_image": 798
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 800,
                    "alt_text_small": "",
                    "product_image_key": "product_image_800",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289H?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289H",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 800,
                    "sort_order": 21,
                    "alt_text_large": "",
                    "fk_product_image": 800
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 802,
                    "alt_text_small": "",
                    "product_image_key": "product_image_802",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007553Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007553Y",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 802,
                    "sort_order": 23,
                    "alt_text_large": "",
                    "fk_product_image": 802
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 804,
                    "alt_text_small": "",
                    "product_image_key": "product_image_804",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006291E?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006291E",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 804,
                    "sort_order": 25,
                    "alt_text_large": "",
                    "fk_product_image": 804
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 806,
                    "alt_text_small": "",
                    "product_image_key": "product_image_806",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554Y",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 806,
                    "sort_order": 27,
                    "alt_text_large": "",
                    "fk_product_image": 806
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 808,
                    "alt_text_small": "",
                    "product_image_key": "product_image_808",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289N?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A006289N",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 808,
                    "sort_order": 29,
                    "alt_text_large": "",
                    "fk_product_image": 808
                },
                {
                    "fk_product_image_set": 202,
                    "id_product_image": 810,
                    "alt_text_small": "",
                    "product_image_key": "product_image_810",
                    "updated_at": "2025-12-02 09:55:13.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554A?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007554A",
                    "created_at": "2025-12-02 09:55:13.000000",
                    "id_product_image_set_to_product_image": 810,
                    "sort_order": 31,
                    "alt_text_large": "",
                    "fk_product_image": 810
                }
            ],
            "id_product_labels": [],
            "price": 432,
            "abstract_name": "Post-it Index 2 adhesive stripes",
            "id_product_abstract": 100,
            "type": "product_abstract",
            "add_to_cart_sku": "420706",
            "prices": {
                "DEFAULT": 432
            },
            "abstract_sku": "M21200",
            "url": "\/en\/post-it-haftstreifen-index-2-M21200"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 204,
                    "id_product_image": 812,
                    "alt_text_small": "",
                    "product_image_key": "product_image_812",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007081Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007081Q",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 812,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 812
                }
            ],
            "id_product_labels": [],
            "price": 422,
            "abstract_name": "Post-it Index Strong adhesive stripes, 686-PLOY 6 sheets sorted, 4 pieces\/pack",
            "id_product_abstract": 101,
            "type": "product_abstract",
            "add_to_cart_sku": "420707",
            "prices": {
                "DEFAULT": 422
            },
            "abstract_sku": "M21201",
            "url": "\/en\/post-it-haftstreifen-index-strong-686-ploy-6blatt-sortiert-4-st-pack-M21201"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 206,
                    "id_product_image": 814,
                    "alt_text_small": "",
                    "product_image_key": "product_image_814",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007686U?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007686U",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 814,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 814
                }
            ],
            "id_product_labels": [],
            "price": 1043,
            "abstract_name": "Post-it Z-Notes adhesive notes R3306SJ 76x76 mm, 90 sheets, red\/green\/blue, 6 pieces\/pack.",
            "id_product_abstract": 102,
            "type": "product_abstract",
            "add_to_cart_sku": "420708",
            "prices": {
                "DEFAULT": 1043
            },
            "abstract_sku": "M21202",
            "url": "\/en\/post-it-haftnotiz-z-notes-r3306sj-76x76mm-90bl-rt-gn-bl-6-st-pack-M21202"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 208,
                    "id_product_image": 816,
                    "alt_text_small": "",
                    "product_image_key": "product_image_816",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007353S?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007353S",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 816,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 816
                },
                {
                    "fk_product_image_set": 208,
                    "id_product_image": 818,
                    "alt_text_small": "",
                    "product_image_key": "product_image_818",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007631M?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007631M",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 818,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 818
                },
                {
                    "fk_product_image_set": 208,
                    "id_product_image": 820,
                    "alt_text_small": "",
                    "product_image_key": "product_image_820",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007644D?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007644D",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 820,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 820
                }
            ],
            "id_product_labels": [],
            "price": 1043,
            "abstract_name": "Post-it Super Sticky adhesive notes, Bangkok Collection R3306SE 6 pieces\/pack.",
            "id_product_abstract": 103,
            "type": "product_abstract",
            "add_to_cart_sku": "420709",
            "prices": {
                "DEFAULT": 1043
            },
            "abstract_sku": "M21203",
            "url": "\/en\/post-it-haftnotiz-super-sticky-bangkok-coll-r3306se-6-st-pack-M21203"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 210,
                    "id_product_image": 822,
                    "alt_text_small": "",
                    "product_image_key": "product_image_822",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007736O?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007736O",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 822,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 822
                },
                {
                    "fk_product_image_set": 210,
                    "id_product_image": 824,
                    "alt_text_small": "",
                    "product_image_key": "product_image_824",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007736P?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007736P",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 824,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 824
                }
            ],
            "id_product_labels": [],
            "price": 245,
            "abstract_name": "Post-it adhesive note Super Sticky 6910YPOG 48x48 mm sorted. 4 pieces\/pack.",
            "id_product_abstract": 104,
            "type": "product_abstract",
            "add_to_cart_sku": "420712",
            "prices": {
                "DEFAULT": 245
            },
            "abstract_sku": "M21205",
            "url": "\/en\/post-it-haftnotiz-super-sticky-6910ypog-48x48mm-sort-4-st-pack-M21205"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 212,
                    "id_product_image": 826,
                    "alt_text_small": "",
                    "product_image_key": "product_image_826",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787W?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787W",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 826,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 826
                },
                {
                    "fk_product_image_set": 212,
                    "id_product_image": 828,
                    "alt_text_small": "",
                    "product_image_key": "product_image_828",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787R?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787R",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 828,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 828
                },
                {
                    "fk_product_image_set": 212,
                    "id_product_image": 830,
                    "alt_text_small": "",
                    "product_image_key": "product_image_830",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007787Q",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 830,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 830
                }
            ],
            "id_product_labels": [],
            "price": 1182,
            "abstract_name": "SanDisk SDHC storage card",
            "id_product_abstract": 105,
            "type": "product_abstract",
            "add_to_cart_sku": "420836",
            "prices": {
                "DEFAULT": 1182
            },
            "abstract_sku": "M21296",
            "url": "\/en\/sandisk-speicherkarte-sdhc-M21296"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 214,
                    "id_product_image": 832,
                    "alt_text_small": "",
                    "product_image_key": "product_image_832",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007435Y?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/A007435Y",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 832,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 832
                }
            ],
            "id_product_labels": [],
            "price": 3647,
            "abstract_name": "SanDisk USB stick Ultra USB3.0 black",
            "id_product_abstract": 106,
            "type": "product_abstract",
            "add_to_cart_sku": "420845",
            "prices": {
                "DEFAULT": 3647
            },
            "abstract_sku": "M21299",
            "url": "\/en\/sandisk-usb-stick-ultra-usb3-0-sw-M21299"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 834,
                    "alt_text_small": "",
                    "product_image_key": "product_image_834",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046296F-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046296F-03",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 834,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 834
                },
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 836,
                    "alt_text_small": "",
                    "product_image_key": "product_image_836",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704087FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00704087FF-01",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 836,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 836
                },
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 838,
                    "alt_text_small": "",
                    "product_image_key": "product_image_838",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00905994FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00905994FF-01",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 838,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 838
                },
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 840,
                    "alt_text_small": "",
                    "product_image_key": "product_image_840",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519688FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519688FF-01",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 840,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 840
                },
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 842,
                    "alt_text_small": "",
                    "product_image_key": "product_image_842",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519737FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00519737FF-01",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 842,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 842
                },
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 844,
                    "alt_text_small": "",
                    "product_image_key": "product_image_844",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046295-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00046295-01",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 844,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 844
                },
                {
                    "fk_product_image_set": 216,
                    "id_product_image": 846,
                    "alt_text_small": "",
                    "product_image_key": "product_image_846",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91863-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91863-01",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 846,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 846
                }
            ],
            "id_product_labels": [],
            "price": 28488,
            "abstract_name": "Mauser steel cabinet with swing doors - 4 shelves, T 420 mm",
            "id_product_abstract": 107,
            "type": "product_abstract",
            "add_to_cart_sku": "107305",
            "prices": {
                "DEFAULT": 28488
            },
            "abstract_sku": "M213",
            "url": "\/en\/mauser-stahlschrank-mit-fluegeltueren-4-fachboeden-t-420-mm-M213"
        }
    ],
    "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": []
}
{}