https://oalp.xiphias-digital.com/DE/en/office-equipment/shredder?page=3

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"
                        }
                    },
                    {
                        "term": {
                            "category.all-parents": {
                                "value": "24",
                                "boost": 1
                            }
                        }
                    }
                ]
            }
        },
        "suggest": {
            "text": ""
        },
        "_source": [
            "search-result-data"
        ],
        "sort": [
            {
                "integer-sort.category:24": {
                    "order": "ASC",
                    "mode": "min",
                    "unmapped_type": "integer"
                }
            }
        ],
        "from": 24,
        "size": 12,
        "aggs": {
            "category.all-parents.category": {
                "terms": {
                    "field": "category.all-parents",
                    "size": 1000
                }
            },
            "global-category": {
                "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": {
                            "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
                                }
                            }
                        }
                    }
                }
            }
        }
    },
    "parameters": {
        "page": "3",
        "category": 24
    }
}
{
    "facets": {
        "category": {},
        "rating": {},
        "label": {},
        "farbe": {},
        "material": {},
        "brand": {},
        "merchant_name": {}
    },
    "sort": {},
    "pagination": {},
    "products": [
        {
            "images": [
                {
                    "fk_product_image_set": 794,
                    "id_product_image": 3148,
                    "alt_text_small": "",
                    "product_image_key": "product_image_3148",
                    "updated_at": "2025-12-02 09:55:28.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522262FF-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00522262FF-01",
                    "created_at": "2025-12-02 09:55:28.000000",
                    "id_product_image_set_to_product_image": 3148,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 3148
                },
                {
                    "fk_product_image_set": 794,
                    "id_product_image": 3150,
                    "alt_text_small": "",
                    "product_image_key": "product_image_3150",
                    "updated_at": "2025-12-02 09:55:28.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051154F-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051154F-01",
                    "created_at": "2025-12-02 09:55:28.000000",
                    "id_product_image_set_to_product_image": 3150,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 3150
                },
                {
                    "fk_product_image_set": 794,
                    "id_product_image": 3152,
                    "alt_text_small": "",
                    "product_image_key": "product_image_3152",
                    "updated_at": "2025-12-02 09:55:28.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051161-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051161-01",
                    "created_at": "2025-12-02 09:55:28.000000",
                    "id_product_image_set_to_product_image": 3152,
                    "sort_order": 5,
                    "alt_text_large": "",
                    "fk_product_image": 3152
                },
                {
                    "fk_product_image_set": 794,
                    "id_product_image": 3154,
                    "alt_text_small": "",
                    "product_image_key": "product_image_3154",
                    "updated_at": "2025-12-02 09:55:28.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051158-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051158-01",
                    "created_at": "2025-12-02 09:55:28.000000",
                    "id_product_image_set_to_product_image": 3154,
                    "sort_order": 7,
                    "alt_text_large": "",
                    "fk_product_image": 3154
                },
                {
                    "fk_product_image_set": 794,
                    "id_product_image": 3156,
                    "alt_text_small": "",
                    "product_image_key": "product_image_3156",
                    "updated_at": "2025-12-02 09:55:28.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051159-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051159-01",
                    "created_at": "2025-12-02 09:55:28.000000",
                    "id_product_image_set_to_product_image": 3156,
                    "sort_order": 9,
                    "alt_text_large": "",
                    "fk_product_image": 3156
                },
                {
                    "fk_product_image_set": 794,
                    "id_product_image": 3158,
                    "alt_text_small": "",
                    "product_image_key": "product_image_3158",
                    "updated_at": "2025-12-02 09:55:28.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051160-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/00051160-01",
                    "created_at": "2025-12-02 09:55:28.000000",
                    "id_product_image_set_to_product_image": 3158,
                    "sort_order": 11,
                    "alt_text_large": "",
                    "fk_product_image": 3158
                }
            ],
            "id_product_labels": [],
            "price": 119653,
            "abstract_name": "IDEAL document shredder - Power 640 watts, 120 l volume",
            "id_product_abstract": 415,
            "type": "product_abstract",
            "add_to_cart_sku": "574973",
            "prices": {
                "DEFAULT": 119653
            },
            "abstract_sku": "M90850",
            "url": "\/en\/ideal-aktenvernichter-leistung-640-watt-120-l-volumen-M90850"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 494,
                    "id_product_image": 1592,
                    "alt_text_small": "View details of Gm\u00f6hling aluminum data disposal container",
                    "product_image_key": "product_image_1592",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124082II-01?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124082II-01",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1592,
                    "sort_order": 1,
                    "alt_text_large": "Front view of Gm\u00f6hling aluminum data disposal container - Exterior - LxWxH 575 x 690 x 1010 mm, with feeder slit",
                    "fk_product_image": 1592
                },
                {
                    "fk_product_image_set": 494,
                    "id_product_image": 1594,
                    "alt_text_small": "View details of Gm\u00f6hling aluminum data disposal container",
                    "product_image_key": "product_image_1594",
                    "updated_at": "2025-12-02 09:55:18.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124082II-02?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/AA00124082II-02",
                    "created_at": "2025-12-02 09:55:18.000000",
                    "id_product_image_set_to_product_image": 1594,
                    "sort_order": 3,
                    "alt_text_large": "Back view of Gm\u00f6hling aluminum data disposal container - Exterior - LxWxH 575 x 690 x 1010 mm, with feeder slits",
                    "fk_product_image": 1594
                }
            ],
            "id_product_labels": [
                4,
                5
            ],
            "price": 34293,
            "abstract_name": "Gm\u00f6hling aluminum data removal container - Exterior - LxWxH 575 x 690 x 1010 mm",
            "rating": 4,
            "id_product_abstract": 258,
            "review_count": 5,
            "type": "product_abstract",
            "add_to_cart_sku": "419780",
            "prices": {
                "DEFAULT": 34293,
                "ORIGINAL": 38103
            },
            "abstract_sku": "M29455",
            "url": "\/en\/alu-datenentsorgungsbehaelter-aussen-lxbxh-575-x-690-x-1010-mm-M29455"
        },
        {
            "images": [
                {
                    "fk_product_image_set": 526,
                    "id_product_image": 1662,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1662",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000023448812_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000023448812_PRD_org_all",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1662,
                    "sort_order": 1,
                    "alt_text_large": "",
                    "fk_product_image": 1662
                },
                {
                    "fk_product_image_set": 526,
                    "id_product_image": 1664,
                    "alt_text_small": "",
                    "product_image_key": "product_image_1664",
                    "updated_at": "2025-12-02 09:55:19.000000",
                    "external_url_small": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000023448813_PRD_org_all?$normal$",
                    "external_url_large": "https:\/\/d2s0ynfc62ej12.cloudfront.net\/image\/000023448813_PRD_org_all",
                    "created_at": "2025-12-02 09:55:19.000000",
                    "id_product_image_set_to_product_image": 1664,
                    "sort_order": 3,
                    "alt_text_large": "",
                    "fk_product_image": 1664
                }
            ],
            "id_product_labels": [
                4
            ],
            "price": 1112479,
            "abstract_name": "HSM conveyor belt document shredder, POWERLINE FA 400.2 - collecting volume 460 l, particle cut",
            "rating": 4,
            "id_product_abstract": 274,
            "review_count": 3,
            "type": "product_abstract",
            "add_to_cart_sku": "621613",
            "prices": {
                "DEFAULT": 1112479
            },
            "abstract_sku": "M29930",
            "url": "\/en\/hsm-foerderband-aktenvernichter-powerline-fa-400-2-auffangvolumen-460-l-partikelschnitt-M29930"
        }
    ],
    "spellingSuggestion": null,
    "categoryTreeFilter": {
        "0": {},
        "1": {},
        "2": {},
        "3": {},
        "4": {},
        "5": {}
    }
}