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

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": 144,
        "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": "13"
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 508,
                    "id_product_image": 1622,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1622",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124190II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124190II-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1622,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1622
                },
                {
                    "fk_product_image_set": 508,
                    "id_product_image": 1624,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1624",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124190II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124190II-02",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1624,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1624
                }
            ],
            "id_product_labels": [],
            "price": 33524,
            "abstract_name": "Safescan automatic banknote counter - 3-fold counterfeit recognition",
            "id_product_abstract": 265,
            "type": "product_abstract",
            "add_to_cart_sku": "419876",
            "prices": {
                "DEFAULT": 33524
            },
            "abstract_sku": "M29504",
            "url": "\/en\/automatischer-banknotenzaehler-3fache-falschgelderkennung-M29504"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 510,
                    "id_product_image": 1626,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1626",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124194II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124194II-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1626,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1626
                },
                {
                    "fk_product_image_set": 510,
                    "id_product_image": 1628,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1628",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124194II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124194II-02",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1628,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1628
                },
                {
                    "fk_product_image_set": 510,
                    "id_product_image": 1630,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1630",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000016457032_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000016457032_PRD_org_all",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1630,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 1630
                },
                {
                    "fk_product_image_set": 510,
                    "id_product_image": 1632,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1632",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000016457034_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000016457034_PRD_org_all",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1632,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 1632
                }
            ],
            "id_product_labels": [],
            "price": 22312,
            "abstract_name": "Safescan automatic coin counter and sorter - SAFESCAN 1250",
            "id_product_abstract": 266,
            "type": "product_abstract",
            "add_to_cart_sku": "419880",
            "prices": {
                "DEFAULT": 22312
            },
            "abstract_sku": "M29507",
            "url": "\/en\/automatischer-muenzzaehler-und-sortierer-safescan-1250-M29507"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 820,
                    "id_product_image": 3194,
                    "alt_text_small": "",
                    "product_image_key": "product_image_3194",
                    "updated_at": "2025-12-02 09:55:28.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00030993-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00030993-01",
                    "created_at": "2025-12-02 09:55:28.000000",
                    "id_product_image_set_to_product_image": 3194,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 3194
                }
            ],
            "id_product_labels": [
                4,
                5
            ],
            "price": 32884,
            "abstract_name": "Dauphin vertebral disc swivel chair, synchronous mechanism",
            "rating": 3.5,
            "id_product_abstract": 298,
            "review_count": 4,
            "type": "product_abstract",
            "add_to_cart_sku": "104939",
            "prices": {
                "DEFAULT": 32884,
                "ORIGINAL": 36537
            },
            "abstract_sku": "M528",
            "url": "\/en\/dauphin-bandscheiben-drehstuhl-synchronmechanik-rueckenlehnenhoehe-400-mm-M528"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 602,
                    "id_product_image": 2048,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2048",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035954-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035954-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2048,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2048
                },
                {
                    "fk_product_image_set": 602,
                    "id_product_image": 2050,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2050",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035951-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035951-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2050,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2050
                },
                {
                    "fk_product_image_set": 602,
                    "id_product_image": 2052,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2052",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035953-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035953-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2052,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2052
                },
                {
                    "fk_product_image_set": 602,
                    "id_product_image": 2054,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2054",
                    "updated_at": "2025-12-02 09:55:21.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035952-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00035952-01",
                    "created_at": "2025-12-02 09:55:21.000000",
                    "id_product_image_set_to_product_image": 2054,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 2054
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 31506,
            "abstract_name": "office akktiv vertebral disc swivel chair, backrest height 580 mm - point-synchronous mechanism, sliding seat",
            "id_product_abstract": 314,
            "type": "product_abstract",
            "add_to_cart_sku": "102169",
            "prices": {
                "DEFAULT": 31506,
                "ORIGINAL": 35006
            },
            "abstract_sku": "M58100",
            "url": "\/en\/office-akktiv-bandscheiben-drehstuhl-rueckenlehnenhoehe-580-mm-punktsynchron-mechanik-schiebesitz-M58100"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 634,
                    "id_product_image": 2224,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2224",
                    "updated_at": "2025-12-02 09:55:22.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00032553F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00032553F-01",
                    "created_at": "2025-12-02 09:55:22.000000",
                    "id_product_image_set_to_product_image": 2224,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2224
                },
                {
                    "fk_product_image_set": 634,
                    "id_product_image": 2226,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2226",
                    "updated_at": "2025-12-02 09:55:22.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000027422001_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000027422001_PRD_org_all",
                    "created_at": "2025-12-02 09:55:22.000000",
                    "id_product_image_set_to_product_image": 2226,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2226
                },
                {
                    "fk_product_image_set": 634,
                    "id_product_image": 2228,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2228",
                    "updated_at": "2025-12-02 09:55:22.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000027422856_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000027422856_PRD_org_all",
                    "created_at": "2025-12-02 09:55:22.000000",
                    "id_product_image_set_to_product_image": 2228,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2228
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 18437,
            "abstract_name": "FRIWA conference table, round - Height 720 mm, \u00d8 1000 mm",
            "id_product_abstract": 330,
            "type": "product_abstract",
            "add_to_cart_sku": "100107",
            "prices": {
                "DEFAULT": 18437,
                "ORIGINAL": 20485
            },
            "abstract_sku": "M61240",
            "url": "\/en\/besprechungstisch-rund-hoehe-720-mm-oe-1000-mm-M61240"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 670,
                    "id_product_image": 2392,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2392",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00011896F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00011896F-01",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2392,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2392
                },
                {
                    "fk_product_image_set": 670,
                    "id_product_image": 2394,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2394",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016322-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016322-01",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2394,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2394
                },
                {
                    "fk_product_image_set": 670,
                    "id_product_image": 2396,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2396",
                    "updated_at": "2025-12-02 09:55:23.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91600-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91600-03",
                    "created_at": "2025-12-02 09:55:23.000000",
                    "id_product_image_set_to_product_image": 2396,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2396
                }
            ],
            "id_product_labels": [
                4
            ],
            "price": 22931,
            "abstract_name": "Rectangular table, rectangular tubing - 1600 x 800 mm",
            "rating": 4.25,
            "id_product_abstract": 348,
            "review_count": 4,
            "type": "product_abstract",
            "prices": {
                "DEFAULT": 22931
            },
            "abstract_sku": "M719",
            "url": "\/en\/rechtecktisch-vierkantrohr-1600-x-800-mm-M719"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2566,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2566",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044316-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044316-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2566,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2566
                },
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2568,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2568",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044317-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044317-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2568,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2568
                },
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2570,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2570",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044318-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044318-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2570,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2570
                },
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2572,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2572",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044319-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00044319-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2572,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 2572
                },
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2574,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2574",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610611II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610611II-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2574,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 2574
                },
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2576,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2576",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610612II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610612II-02",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2576,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 2576
                },
                {
                    "fk_product_image_set": 702,
                    "id_product_image": 2578,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2578",
                    "updated_at": "2025-12-02 09:55:24.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610612II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00610612II-01",
                    "created_at": "2025-12-02 09:55:24.000000",
                    "id_product_image_set_to_product_image": 2578,
                    "sort_order": 13,
                    "alt_text_large": "",
                    "fk_product_image": 2578
                }
            ],
            "id_product_labels": [
                5
            ],
            "price": 71077,
            "abstract_name": "Topstar operator swivel chair, can carry up to 150 kg - point synchronous mechanism, sliding seat, headrest",
            "id_product_abstract": 364,
            "type": "product_abstract",
            "add_to_cart_sku": "101940",
            "prices": {
                "DEFAULT": 71077,
                "ORIGINAL": 78974
            },
            "abstract_sku": "M74907",
            "url": "\/en\/topstar-operator-drehstuhl-belastbar-bis-150-kg-punktsynchron-mechanik-schiebesitz-kopfstuetze-M74907"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 734,
                    "id_product_image": 2804,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2804",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00011896F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00011896F-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2804,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2804
                },
                {
                    "fk_product_image_set": 734,
                    "id_product_image": 2806,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2806",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016322-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00016322-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2806,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2806
                },
                {
                    "fk_product_image_set": 734,
                    "id_product_image": 2808,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2808",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91600-03?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/SK91600-03",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2808,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2808
                }
            ],
            "id_product_labels": [],
            "price": 29793,
            "abstract_name": "Rectangular table, rectangular tubing, chromed - 1600 x 800 mm",
            "id_product_abstract": 380,
            "type": "product_abstract",
            "add_to_cart_sku": "102922",
            "prices": {
                "DEFAULT": 29793
            },
            "abstract_sku": "M771",
            "url": "\/en\/rechtecktisch-rundrohr-verchromt-1600-x-800-mm-M771"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 760,
                    "id_product_image": 2910,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2910",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00003913F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00003913F-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2910,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 2910
                },
                {
                    "fk_product_image_set": 760,
                    "id_product_image": 2912,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2912",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00895164FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00895164FF-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2912,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 2912
                },
                {
                    "fk_product_image_set": 760,
                    "id_product_image": 2914,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2914",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00895172FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00895172FF-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2914,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 2914
                },
                {
                    "fk_product_image_set": 760,
                    "id_product_image": 2916,
                    "alt_text_small": "",
                    "product_image_key": "product_image_2916",
                    "updated_at": "2025-12-02 09:55:26.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00926937FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00926937FF-01",
                    "created_at": "2025-12-02 09:55:26.000000",
                    "id_product_image_set_to_product_image": 2916,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 2916
                }
            ],
            "id_product_labels": [
                4
            ],
            "price": 56140,
            "abstract_name": "Wolf steel cabinet - wide storage cabinet, with base plinth",
            "id_product_abstract": 396,
            "type": "product_abstract",
            "add_to_cart_sku": "507871",
            "prices": {
                "DEFAULT": 56140
            },
            "abstract_sku": "M859",
            "url": "\/en\/wolf-stahlschrank-lagerschrank-breit-mit-bodensockel-M859"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 22,
                    "id_product_image": 68,
                    "alt_text_small": "",
                    "product_image_key": "product_image_68",
                    "updated_at": "2025-12-02 09:55:08.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756515II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00756515II-01",
                    "created_at": "2025-12-02 09:55:08.000000",
                    "id_product_image_set_to_product_image": 68,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 68
                }
            ],
            "id_product_labels": [],
            "price": 13725,
            "abstract_name": "magnetoplan\u00ae Flipchart JUNIOR PLUS - writing surface 680 x 980 mm, magnetic",
            "id_product_abstract": 11,
            "type": "product_abstract",
            "add_to_cart_sku": "517598",
            "prices": {
                "DEFAULT": 13725
            },
            "abstract_sku": "M1013168",
            "url": "\/en\/magnetoplan-flipchart-junior-plus-schreibflaeche-680-x-980-mm-magnethaftend-M1013168"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 98,
                    "id_product_image": 318,
                    "alt_text_small": "",
                    "product_image_key": "product_image_318",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051143F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051143F-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 318,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 318
                },
                {
                    "fk_product_image_set": 98,
                    "id_product_image": 320,
                    "alt_text_small": "",
                    "product_image_key": "product_image_320",
                    "updated_at": "2025-12-02 09:55:10.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051148-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051148-01",
                    "created_at": "2025-12-02 09:55:10.000000",
                    "id_product_image_set_to_product_image": 320,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 320
                }
            ],
            "id_product_labels": [],
            "price": 9929,
            "abstract_name": "IDEAL document shredder, small, SHREDCAT - Collecting volume 18 l",
            "id_product_abstract": 47,
            "type": "product_abstract",
            "add_to_cart_sku": "574969",
            "prices": {
                "DEFAULT": 9929
            },
            "abstract_sku": "M1028095",
            "url": "\/en\/ideal-aktenvernichter-klein-shredcat-auffangvolumen-18-l-M1028095"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 250,
                    "id_product_image": 920,
                    "alt_text_small": "",
                    "product_image_key": "product_image_920",
                    "updated_at": "2025-12-02 09:55:14.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010717Q?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/B010717Q",
                    "created_at": "2025-12-02 09:55:14.000000",
                    "id_product_image_set_to_product_image": 920,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 920
                }
            ],
            "id_product_labels": [],
            "price": 442,
            "abstract_name": "Clairefontaine Collegeblock 8279C DIN A4 checkered, 80 sheets, white",
            "id_product_abstract": 128,
            "type": "product_abstract",
            "add_to_cart_sku": "421426",
            "prices": {
                "DEFAULT": 442
            },
            "abstract_sku": "M21711",
            "url": "\/en\/clairefontaine-collegeblock-8279c-din-a4-kariert-80blatt-weiss-M21711"
        }
    ],
    "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": []
}
{}