Virtual Scrolling with Grouping

The native Vue Grid by Kendo UI enables you to use virtualization with grouped data.

To enable grouping:

  1. Set the groupable and group options of the Grid.
  2. Set the scrollable option to virtual.
  3. Handle the emitted datastatechange event. The datastatechange event fires when the user interacts with the Grid by scrolling or changing its groups, then processes the data, and returns the requested page to the Grid. To implement the processing of the data programmatically, send a request to the server to execute the grouping for the current page on server-side, or use the process method of the DataQuery library which automatically processes the data.

The Grid expects the grouped data to be a collection of GroupResults.

<div id="vueapp" class="vue-app">
    <Grid
            style="height: 720px;"
            :data-items="gridData"
            :columns="columns"
            :resizable="true"
            :reorderable="true"
            :filterable="true"
            :sortable="true"
            :groupable="true"
            :group= "group"
            :row-height="40"
            :take="take"
            :skip="skip"
            :scrollable="'virtual'"
            @datastatechange="dataStateChange"
            @expandchange="expandChange"
            @datastatechange="dataStateChange"
            :expand-field="'expanded'">
        </Grid>
</div>
import { process } from '@progress/kendo-data-query';
import { Grid } from '@progress/kendo-vue-grid';

Vue.component('Grid', Grid);

new Vue({
    el: '#vueapp',
    data: function () {
        return {
            gridData: [],
            skip: 0,
            take: 15,
            group: [  
                { field: 'UnitsInStock' },
                { field: 'Category.CategoryName' } ],
            columns: [
                { field: 'ProductID', title: 'ID', filter: 'numeric' },
                { field: 'ProductName', title: 'Product Name', reorderable: false },
                { field: 'QuantityPerUnit', title: 'Quantity Per Unit', groupable: true },
                { field: 'UnitsInStock', title: 'Units In Stock', filter: 'numeric', reorderable: false },
                { field: 'Category.CategoryName', title: 'Category Name' }
            ]
        };
    },
    created: function() {
        this.getData();
    },
    methods: {
        getData: function () {
            this.gridData = process(this.getProducts(), {take: this.take, skip: this.skip, group: this.group});
        },
        createAppState: function(dataState) {
            this.group = dataState.group;
            this.take = dataState.take;
            this.skip = dataState.skip;
            this.getData();
        },
        dataStateChange: function (event) {
            this.createAppState(event.data);
        },
        expandChange: function (event) {
            Vue.set(event.dataItem, event.target.$props.expandField, event.value);
        },
        getProducts: function(){
            return [
                    {
                        "ProductID": 1,
                        "ProductName": "Chai",
                        "SupplierID": 1,
                        "CategoryID": 1,
                        "QuantityPerUnit": "10 boxes x 20 bags",
                        "UnitPrice": 18.0000,
                        "UnitsInStock": 39,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 10,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 1,
                            "CategoryName": "Beverages",
                            "Description": "Soft drinks, coffees, teas, beers, and ales"
                        }
                    },
                    {
                        "ProductID": 2,
                        "ProductName": "Chang",
                        "SupplierID": 1,
                        "CategoryID": 1,
                        "QuantityPerUnit": "24 - 12 oz bottles",
                        "UnitPrice": 19.0000,
                        "UnitsInStock": 17,
                        "UnitsOnOrder": 40,
                        "ReorderLevel": 25,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 1,
                            "CategoryName": "Beverages",
                            "Description": "Soft drinks, coffees, teas, beers, and ales"
                        }
                    },
                    {
                        "ProductID": 3,
                        "ProductName": "Aniseed Syrup",
                        "SupplierID": 1,
                        "CategoryID": 2,
                        "QuantityPerUnit": "12 - 550 ml bottles",
                        "UnitPrice": 10.0000,
                        "UnitsInStock": 13,
                        "UnitsOnOrder": 70,
                        "ReorderLevel": 25,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 2,
                            "CategoryName": "Condiments",
                            "Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
                        }
                    },
                    {
                        "ProductID": 4,
                        "ProductName": "Chef Anton's Cajun Seasoning",
                        "SupplierID": 2,
                        "CategoryID": 2,
                        "QuantityPerUnit": "48 - 6 oz jars",
                        "UnitPrice": 22.0000,
                        "UnitsInStock": 53,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 2,
                            "CategoryName": "Condiments",
                            "Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
                        }
                    },
                    {
                        "ProductID": 5,
                        "ProductName": "Chef Anton's Gumbo Mix",
                        "SupplierID": 2,
                        "CategoryID": 2,
                        "QuantityPerUnit": "36 boxes",
                        "UnitPrice": 21.3500,
                        "UnitsInStock": 0,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": true,
                        "Category": {
                            "CategoryID": 2,
                            "CategoryName": "Condiments",
                            "Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
                        }
                    },
                    {
                        "ProductID": 6,
                        "ProductName": "Grandma's Boysenberry Spread",
                        "SupplierID": 3,
                        "CategoryID": 2,
                        "QuantityPerUnit": "12 - 8 oz jars",
                        "UnitPrice": 25.0000,
                        "UnitsInStock": 120,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 25,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 2,
                            "CategoryName": "Condiments",
                            "Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
                        }
                    },
                    {
                        "ProductID": 7,
                        "ProductName": "Uncle Bob's Organic Dried Pears",
                        "SupplierID": 3,
                        "CategoryID": 7,
                        "QuantityPerUnit": "12 - 1 lb pkgs.",
                        "UnitPrice": 30.0000,
                        "UnitsInStock": 15,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 10,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 7,
                            "CategoryName": "Produce",
                            "Description": "Dried fruit and bean curd"
                        }
                    },
                    {
                        "ProductID": 8,
                        "ProductName": "Northwoods Cranberry Sauce",
                        "SupplierID": 3,
                        "CategoryID": 2,
                        "QuantityPerUnit": "12 - 12 oz jars",
                        "UnitPrice": 40.0000,
                        "UnitsInStock": 6,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 2,
                            "CategoryName": "Condiments",
                            "Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
                        }
                    },
                    {
                        "ProductID": 9,
                        "ProductName": "Mishi Kobe Niku",
                        "SupplierID": 4,
                        "CategoryID": 6,
                        "QuantityPerUnit": "18 - 500 g pkgs.",
                        "UnitPrice": 97.0000,
                        "UnitsInStock": 29,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": true,
                        "Category": {
                            "CategoryID": 6,
                            "CategoryName": "Meat/Poultry",
                            "Description": "Prepared meats"
                        }
                    },
                    {
                        "ProductID": 10,
                        "ProductName": "Ikura",
                        "SupplierID": 4,
                        "CategoryID": 8,
                        "QuantityPerUnit": "12 - 200 ml jars",
                        "UnitPrice": 31.0000,
                        "UnitsInStock": 31,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 8,
                            "CategoryName": "Seafood",
                            "Description": "Seaweed and fish"
                        }
                    },
                    {
                        "ProductID": 11,
                        "ProductName": "Queso Cabrales",
                        "SupplierID": 5,
                        "CategoryID": 4,
                        "QuantityPerUnit": "1 kg pkg.",
                        "UnitPrice": 21.0000,
                        "UnitsInStock": 22,
                        "UnitsOnOrder": 30,
                        "ReorderLevel": 30,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 4,
                            "CategoryName": "Dairy Products",
                            "Description": "Cheeses"
                        }
                    },
                    {
                        "ProductID": 12,
                        "ProductName": "Queso Manchego La Pastora",
                        "SupplierID": 5,
                        "CategoryID": 4,
                        "QuantityPerUnit": "10 - 500 g pkgs.",
                        "UnitPrice": 38.0000,
                        "UnitsInStock": 86,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 4,
                            "CategoryName": "Dairy Products",
                            "Description": "Cheeses"
                        }
                    },
                    {
                        "ProductID": 13,
                        "ProductName": "Konbu",
                        "SupplierID": 6,
                        "CategoryID": 8,
                        "QuantityPerUnit": "2 kg box",
                        "UnitPrice": 6.0000,
                        "UnitsInStock": 24,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 5,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 8,
                            "CategoryName": "Seafood",
                            "Description": "Seaweed and fish"
                        }
                    },
                    {
                        "ProductID": 14,
                        "ProductName": "Tofu",
                        "SupplierID": 6,
                        "CategoryID": 7,
                        "QuantityPerUnit": "40 - 100 g pkgs.",
                        "UnitPrice": 23.2500,
                        "UnitsInStock": 35,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 7,
                            "CategoryName": "Produce",
                            "Description": "Dried fruit and bean curd"
                        }
                    },
                    {
                        "ProductID": 15,
                        "ProductName": "Genen Shouyu",
                        "SupplierID": 6,
                        "CategoryID": 2,
                        "QuantityPerUnit": "24 - 250 ml bottles",
                        "UnitPrice": 15.5000,
                        "UnitsInStock": 39,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 5,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 2,
                            "CategoryName": "Condiments",
                            "Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
                        }
                    },
                    {
                        "ProductID": 16,
                        "ProductName": "Pavlova",
                        "SupplierID": 7,
                        "CategoryID": 3,
                        "QuantityPerUnit": "32 - 500 g boxes",
                        "UnitPrice": 17.4500,
                        "UnitsInStock": 29,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 10,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 17,
                        "ProductName": "Alice Mutton",
                        "SupplierID": 7,
                        "CategoryID": 6,
                        "QuantityPerUnit": "20 - 1 kg tins",
                        "UnitPrice": 39.0000,
                        "UnitsInStock": 0,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": true,
                        "Category": {
                            "CategoryID": 6,
                            "CategoryName": "Meat/Poultry",
                            "Description": "Prepared meats"
                        }
                    },
                    {
                        "ProductID": 18,
                        "ProductName": "Carnarvon Tigers",
                        "SupplierID": 7,
                        "CategoryID": 8,
                        "QuantityPerUnit": "16 kg pkg.",
                        "UnitPrice": 62.5000,
                        "UnitsInStock": 42,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 8,
                            "CategoryName": "Seafood",
                            "Description": "Seaweed and fish"
                        }
                    },
                    {
                        "ProductID": 19,
                        "ProductName": "Teatime Chocolate Biscuits",
                        "SupplierID": 8,
                        "CategoryID": 3,
                        "QuantityPerUnit": "10 boxes x 12 pieces",
                        "UnitPrice": 9.2000,
                        "UnitsInStock": 25,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 5,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 20,
                        "ProductName": "Sir Rodney's Marmalade",
                        "SupplierID": 8,
                        "CategoryID": 3,
                        "QuantityPerUnit": "30 gift boxes",
                        "UnitPrice": 81.0000,
                        "UnitsInStock": 40,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 21,
                        "ProductName": "Sir Rodney's Scones",
                        "SupplierID": 8,
                        "CategoryID": 3,
                        "QuantityPerUnit": "24 pkgs. x 4 pieces",
                        "UnitPrice": 10.0000,
                        "UnitsInStock": 3,
                        "UnitsOnOrder": 40,
                        "ReorderLevel": 5,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 22,
                        "ProductName": "Gustaf's Knäckebröd",
                        "SupplierID": 9,
                        "CategoryID": 5,
                        "QuantityPerUnit": "24 - 500 g pkgs.",
                        "UnitPrice": 21.0000,
                        "UnitsInStock": 104,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 25,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 5,
                            "CategoryName": "Grains/Cereals",
                            "Description": "Breads, crackers, pasta, and cereal"
                        }
                    },
                    {
                        "ProductID": 23,
                        "ProductName": "Tunnbröd",
                        "SupplierID": 9,
                        "CategoryID": 5,
                        "QuantityPerUnit": "12 - 250 g pkgs.",
                        "UnitPrice": 9.0000,
                        "UnitsInStock": 61,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 25,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 5,
                            "CategoryName": "Grains/Cereals",
                            "Description": "Breads, crackers, pasta, and cereal"
                        }
                    },
                    {
                        "ProductID": 24,
                        "ProductName": "Guaraná Fantástica",
                        "SupplierID": 10,
                        "CategoryID": 1,
                        "QuantityPerUnit": "12 - 355 ml cans",
                        "UnitPrice": 4.5000,
                        "UnitsInStock": 20,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": true,
                        "Category": {
                            "CategoryID": 1,
                            "CategoryName": "Beverages",
                            "Description": "Soft drinks, coffees, teas, beers, and ales"
                        }
                    },
                    {
                        "ProductID": 25,
                        "ProductName": "NuNuCa Nuß-Nougat-Creme",
                        "SupplierID": 11,
                        "CategoryID": 3,
                        "QuantityPerUnit": "20 - 450 g glasses",
                        "UnitPrice": 14.0000,
                        "UnitsInStock": 76,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 30,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 26,
                        "ProductName": "Gumbär Gummibärchen",
                        "SupplierID": 11,
                        "CategoryID": 3,
                        "QuantityPerUnit": "100 - 250 g bags",
                        "UnitPrice": 31.2300,
                        "UnitsInStock": 15,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 27,
                        "ProductName": "Schoggi Schokolade",
                        "SupplierID": 11,
                        "CategoryID": 3,
                        "QuantityPerUnit": "100 - 100 g pieces",
                        "UnitPrice": 43.9000,
                        "UnitsInStock": 49,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 30,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 28,
                        "ProductName": "Rössle Sauerkraut",
                        "SupplierID": 12,
                        "CategoryID": 7,
                        "QuantityPerUnit": "25 - 825 g cans",
                        "UnitPrice": 45.6000,
                        "UnitsInStock": 26,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": true,
                        "Category": {
                            "CategoryID": 7,
                            "CategoryName": "Produce",
                            "Description": "Dried fruit and bean curd"
                        }
                    },
                    {
                        "ProductID": 29,
                        "ProductName": "Thüringer Rostbratwurst",
                        "SupplierID": 12,
                        "CategoryID": 6,
                        "QuantityPerUnit": "50 bags x 30 sausgs.",
                        "UnitPrice": 123.7900,
                        "UnitsInStock": 0,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": true,
                        "Category": {
                            "CategoryID": 6,
                            "CategoryName": "Meat/Poultry",
                            "Description": "Prepared meats"
                        }
                    },
                    {
                        "ProductID": 30,
                        "ProductName": "Nord-Ost Matjeshering",
                        "SupplierID": 13,
                        "CategoryID": 8,
                        "QuantityPerUnit": "10 - 200 g glasses",
                        "UnitPrice": 25.8900,
                        "UnitsInStock": 10,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 15,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 8,
                            "CategoryName": "Seafood",
                            "Description": "Seaweed and fish"
                        }
                    },
                    {
                        "ProductID": 31,
                        "ProductName": "Gorgonzola Telino",
                        "SupplierID": 14,
                        "CategoryID": 4,
                        "QuantityPerUnit": "12 - 100 g pkgs",
                        "UnitPrice": 12.5000,
                        "UnitsInStock": 0,
                        "UnitsOnOrder": 70,
                        "ReorderLevel": 20,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 4,
                            "CategoryName": "Dairy Products",
                            "Description": "Cheeses"
                        }
                    },
                    {
                        "ProductID": 32,
                        "ProductName": "Mascarpone Fabioli",
                        "SupplierID": 14,
                        "CategoryID": 4,
                        "QuantityPerUnit": "24 - 200 g pkgs.",
                        "UnitPrice": 32.0000,
                        "UnitsInStock": 9,
                        "UnitsOnOrder": 40,
                        "ReorderLevel": 25,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 4,
                            "CategoryName": "Dairy Products",
                            "Description": "Cheeses"
                        }
                    },
                    {
                        "ProductID": 33,
                        "ProductName": "Geitost",
                        "SupplierID": 15,
                        "CategoryID": 4,
                        "QuantityPerUnit": "500 g",
                        "UnitPrice": 2.5000,
                        "UnitsInStock": 112,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 20,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 4,
                            "CategoryName": "Dairy Products",
                            "Description": "Cheeses"
                        }
                    },
                    {
                        "ProductID": 34,
                        "ProductName": "Sasquatch Ale",
                        "SupplierID": 16,
                        "CategoryID": 1,
                        "QuantityPerUnit": "24 - 12 oz bottles",
                        "UnitPrice": 14.0000,
                        "UnitsInStock": 111,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 15,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 1,
                            "CategoryName": "Beverages",
                            "Description": "Soft drinks, coffees, teas, beers, and ales"
                        }
                    },
                    {
                        "ProductID": 35,
                        "ProductName": "Steeleye Stout",
                        "SupplierID": 16,
                        "CategoryID": 1,
                        "QuantityPerUnit": "24 - 12 oz bottles",
                        "UnitPrice": 18.0000,
                        "UnitsInStock": 20,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 15,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 1,
                            "CategoryName": "Beverages",
                            "Description": "Soft drinks, coffees, teas, beers, and ales"
                        }
                    },
                    {
                        "ProductID": 36,
                        "ProductName": "Inlagd Sill",
                        "SupplierID": 17,
                        "CategoryID": 8,
                        "QuantityPerUnit": "24 - 250 g  jars",
                        "UnitPrice": 19.0000,
                        "UnitsInStock": 112,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 20,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 8,
                            "CategoryName": "Seafood",
                            "Description": "Seaweed and fish"
                        }
                    },
                    {
                        "ProductID": 37,
                        "ProductName": "Gravad lax",
                        "SupplierID": 17,
                        "CategoryID": 8,
                        "QuantityPerUnit": "12 - 500 g pkgs.",
                        "UnitPrice": 26.0000,
                        "UnitsInStock": 11,
                        "UnitsOnOrder": 50,
                        "ReorderLevel": 25,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 8,
                            "CategoryName": "Seafood",
                            "Description": "Seaweed and fish"
                        }
                    },
                    {
                        "ProductID": 38,
                        "ProductName": "Côte de Blaye",
                        "SupplierID": 18,
                        "CategoryID": 1,
                        "QuantityPerUnit": "12 - 75 cl bottles",
                        "UnitPrice": 263.5000,
                        "UnitsInStock": 17,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 15,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 1,
                            "CategoryName": "Beverages",
                            "Description": "Soft drinks, coffees, teas, beers, and ales"
                        }
                    },
                    {
                        "ProductID": 39,
                        "ProductName": "Chartreuse verte",
                        "SupplierID": 18,
                        "CategoryID": 1,
                        "QuantityPerUnit": "750 cc per bottle",
                        "UnitPrice": 18.0000,
                        "UnitsInStock": 69,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 5,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 1,
                            "CategoryName": "Beverages",
                            "Description": "Soft drinks, coffees, teas, beers, and ales"
                        }
                    },
                    {
                        "ProductID": 40,
                        "ProductName": "Boston Crab Meat",
                        "SupplierID": 19,
                        "CategoryID": 8,
                        "QuantityPerUnit": "24 - 4 oz tins",
                        "UnitPrice": 18.4000,
                        "UnitsInStock": 123,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 30,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 8,
                            "CategoryName": "Seafood",
                            "Description": "Seaweed and fish"
                        }
                    },
                    {
                        "ProductID": 41,
                        "ProductName": "Jack's New England Clam Chowder",
                        "SupplierID": 19,
                        "CategoryID": 8,
                        "QuantityPerUnit": "12 - 12 oz cans",
                        "UnitPrice": 9.6500,
                        "UnitsInStock": 85,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 10,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 8,
                            "CategoryName": "Seafood",
                            "Description": "Seaweed and fish"
                        }
                    },
                    {
                        "ProductID": 42,
                        "ProductName": "Singaporean Hokkien Fried Mee",
                        "SupplierID": 20,
                        "CategoryID": 5,
                        "QuantityPerUnit": "32 - 1 kg pkgs.",
                        "UnitPrice": 14.0000,
                        "UnitsInStock": 26,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": true,
                        "Category": {
                            "CategoryID": 5,
                            "CategoryName": "Grains/Cereals",
                            "Description": "Breads, crackers, pasta, and cereal"
                        }
                    },
                    {
                        "ProductID": 43,
                        "ProductName": "Ipoh Coffee",
                        "SupplierID": 20,
                        "CategoryID": 1,
                        "QuantityPerUnit": "16 - 500 g tins",
                        "UnitPrice": 46.0000,
                        "UnitsInStock": 17,
                        "UnitsOnOrder": 10,
                        "ReorderLevel": 25,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 1,
                            "CategoryName": "Beverages",
                            "Description": "Soft drinks, coffees, teas, beers, and ales"
                        }
                    },
                    {
                        "ProductID": 44,
                        "ProductName": "Gula Malacca",
                        "SupplierID": 20,
                        "CategoryID": 2,
                        "QuantityPerUnit": "20 - 2 kg bags",
                        "UnitPrice": 19.4500,
                        "UnitsInStock": 27,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 15,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 2,
                            "CategoryName": "Condiments",
                            "Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
                        }
                    },
                    {
                        "ProductID": 45,
                        "ProductName": "Rogede sild",
                        "SupplierID": 21,
                        "CategoryID": 8,
                        "QuantityPerUnit": "1k pkg.",
                        "UnitPrice": 9.5000,
                        "UnitsInStock": 5,
                        "UnitsOnOrder": 70,
                        "ReorderLevel": 15,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 8,
                            "CategoryName": "Seafood",
                            "Description": "Seaweed and fish"
                        }
                    },
                    {
                        "ProductID": 46,
                        "ProductName": "Spegesild",
                        "SupplierID": 21,
                        "CategoryID": 8,
                        "QuantityPerUnit": "4 - 450 g glasses",
                        "UnitPrice": 12.0000,
                        "UnitsInStock": 95,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 8,
                            "CategoryName": "Seafood",
                            "Description": "Seaweed and fish"
                        }
                    },
                    {
                        "ProductID": 47,
                        "ProductName": "Zaanse koeken",
                        "SupplierID": 22,
                        "CategoryID": 3,
                        "QuantityPerUnit": "10 - 4 oz boxes",
                        "UnitPrice": 9.5000,
                        "UnitsInStock": 36,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 48,
                        "ProductName": "Chocolade",
                        "SupplierID": 22,
                        "CategoryID": 3,
                        "QuantityPerUnit": "10 pkgs.",
                        "UnitPrice": 12.7500,
                        "UnitsInStock": 15,
                        "UnitsOnOrder": 70,
                        "ReorderLevel": 25,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 49,
                        "ProductName": "Maxilaku",
                        "SupplierID": 23,
                        "CategoryID": 3,
                        "QuantityPerUnit": "24 - 50 g pkgs.",
                        "UnitPrice": 20.0000,
                        "UnitsInStock": 10,
                        "UnitsOnOrder": 60,
                        "ReorderLevel": 15,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 50,
                        "ProductName": "Valkoinen suklaa",
                        "SupplierID": 23,
                        "CategoryID": 3,
                        "QuantityPerUnit": "12 - 100 g bars",
                        "UnitPrice": 16.2500,
                        "UnitsInStock": 65,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 30,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 51,
                        "ProductName": "Manjimup Dried Apples",
                        "SupplierID": 24,
                        "CategoryID": 7,
                        "QuantityPerUnit": "50 - 300 g pkgs.",
                        "UnitPrice": 53.0000,
                        "UnitsInStock": 20,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 10,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 7,
                            "CategoryName": "Produce",
                            "Description": "Dried fruit and bean curd"
                        }
                    },
                    {
                        "ProductID": 52,
                        "ProductName": "Filo Mix",
                        "SupplierID": 24,
                        "CategoryID": 5,
                        "QuantityPerUnit": "16 - 2 kg boxes",
                        "UnitPrice": 7.0000,
                        "UnitsInStock": 38,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 25,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 5,
                            "CategoryName": "Grains/Cereals",
                            "Description": "Breads, crackers, pasta, and cereal"
                        }
                    },
                    {
                        "ProductID": 53,
                        "ProductName": "Perth Pasties",
                        "SupplierID": 24,
                        "CategoryID": 6,
                        "QuantityPerUnit": "48 pieces",
                        "UnitPrice": 32.8000,
                        "UnitsInStock": 0,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": true,
                        "Category": {
                            "CategoryID": 6,
                            "CategoryName": "Meat/Poultry",
                            "Description": "Prepared meats"
                        }
                    },
                    {
                        "ProductID": 54,
                        "ProductName": "Tourtière",
                        "SupplierID": 25,
                        "CategoryID": 6,
                        "QuantityPerUnit": "16 pies",
                        "UnitPrice": 7.4500,
                        "UnitsInStock": 21,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 10,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 6,
                            "CategoryName": "Meat/Poultry",
                            "Description": "Prepared meats"
                        }
                    },
                    {
                        "ProductID": 55,
                        "ProductName": "Pâté chinois",
                        "SupplierID": 25,
                        "CategoryID": 6,
                        "QuantityPerUnit": "24 boxes x 2 pies",
                        "UnitPrice": 24.0000,
                        "UnitsInStock": 115,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 20,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 6,
                            "CategoryName": "Meat/Poultry",
                            "Description": "Prepared meats"
                        }
                    },
                    {
                        "ProductID": 56,
                        "ProductName": "Gnocchi di nonna Alice",
                        "SupplierID": 26,
                        "CategoryID": 5,
                        "QuantityPerUnit": "24 - 250 g pkgs.",
                        "UnitPrice": 38.0000,
                        "UnitsInStock": 21,
                        "UnitsOnOrder": 10,
                        "ReorderLevel": 30,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 5,
                            "CategoryName": "Grains/Cereals",
                            "Description": "Breads, crackers, pasta, and cereal"
                        }
                    },
                    {
                        "ProductID": 57,
                        "ProductName": "Ravioli Angelo",
                        "SupplierID": 26,
                        "CategoryID": 5,
                        "QuantityPerUnit": "24 - 250 g pkgs.",
                        "UnitPrice": 19.5000,
                        "UnitsInStock": 36,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 20,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 5,
                            "CategoryName": "Grains/Cereals",
                            "Description": "Breads, crackers, pasta, and cereal"
                        }
                    },
                    {
                        "ProductID": 58,
                        "ProductName": "Escargots de Bourgogne",
                        "SupplierID": 27,
                        "CategoryID": 8,
                        "QuantityPerUnit": "24 pieces",
                        "UnitPrice": 13.2500,
                        "UnitsInStock": 62,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 20,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 8,
                            "CategoryName": "Seafood",
                            "Description": "Seaweed and fish"
                        }
                    },
                    {
                        "ProductID": 59,
                        "ProductName": "Raclette Courdavault",
                        "SupplierID": 28,
                        "CategoryID": 4,
                        "QuantityPerUnit": "5 kg pkg.",
                        "UnitPrice": 55.0000,
                        "UnitsInStock": 79,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 4,
                            "CategoryName": "Dairy Products",
                            "Description": "Cheeses"
                        }
                    },
                    {
                        "ProductID": 60,
                        "ProductName": "Camembert Pierrot",
                        "SupplierID": 28,
                        "CategoryID": 4,
                        "QuantityPerUnit": "15 - 300 g rounds",
                        "UnitPrice": 34.0000,
                        "UnitsInStock": 19,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 4,
                            "CategoryName": "Dairy Products",
                            "Description": "Cheeses"
                        }
                    },
                    {
                        "ProductID": 61,
                        "ProductName": "Sirop d'érable",
                        "SupplierID": 29,
                        "CategoryID": 2,
                        "QuantityPerUnit": "24 - 500 ml bottles",
                        "UnitPrice": 28.5000,
                        "UnitsInStock": 113,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 25,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 2,
                            "CategoryName": "Condiments",
                            "Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
                        }
                    },
                    {
                        "ProductID": 62,
                        "ProductName": "Tarte au sucre",
                        "SupplierID": 29,
                        "CategoryID": 3,
                        "QuantityPerUnit": "48 pies",
                        "UnitPrice": 49.3000,
                        "UnitsInStock": 17,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 63,
                        "ProductName": "Vegie-spread",
                        "SupplierID": 7,
                        "CategoryID": 2,
                        "QuantityPerUnit": "15 - 625 g jars",
                        "UnitPrice": 43.9000,
                        "UnitsInStock": 24,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 5,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 2,
                            "CategoryName": "Condiments",
                            "Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
                        }
                    },
                    {
                        "ProductID": 64,
                        "ProductName": "Wimmers gute Semmelknödel",
                        "SupplierID": 12,
                        "CategoryID": 5,
                        "QuantityPerUnit": "20 bags x 4 pieces",
                        "UnitPrice": 33.2500,
                        "UnitsInStock": 22,
                        "UnitsOnOrder": 80,
                        "ReorderLevel": 30,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 5,
                            "CategoryName": "Grains/Cereals",
                            "Description": "Breads, crackers, pasta, and cereal"
                        }
                    },
                    {
                        "ProductID": 65,
                        "ProductName": "Louisiana Fiery Hot Pepper Sauce",
                        "SupplierID": 2,
                        "CategoryID": 2,
                        "QuantityPerUnit": "32 - 8 oz bottles",
                        "UnitPrice": 21.0500,
                        "UnitsInStock": 76,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 2,
                            "CategoryName": "Condiments",
                            "Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
                        }
                    },
                    {
                        "ProductID": 66,
                        "ProductName": "Louisiana Hot Spiced Okra",
                        "SupplierID": 2,
                        "CategoryID": 2,
                        "QuantityPerUnit": "24 - 8 oz jars",
                        "UnitPrice": 17.0000,
                        "UnitsInStock": 4,
                        "UnitsOnOrder": 100,
                        "ReorderLevel": 20,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 2,
                            "CategoryName": "Condiments",
                            "Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
                        }
                    },
                    {
                        "ProductID": 67,
                        "ProductName": "Laughing Lumberjack Lager",
                        "SupplierID": 16,
                        "CategoryID": 1,
                        "QuantityPerUnit": "24 - 12 oz bottles",
                        "UnitPrice": 14.0000,
                        "UnitsInStock": 52,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 10,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 1,
                            "CategoryName": "Beverages",
                            "Description": "Soft drinks, coffees, teas, beers, and ales"
                        }
                    },
                    {
                        "ProductID": 68,
                        "ProductName": "Scottish Longbreads",
                        "SupplierID": 8,
                        "CategoryID": 3,
                        "QuantityPerUnit": "10 boxes x 8 pieces",
                        "UnitPrice": 12.5000,
                        "UnitsInStock": 6,
                        "UnitsOnOrder": 10,
                        "ReorderLevel": 15,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 3,
                            "CategoryName": "Confections",
                            "Description": "Desserts, candies, and sweet breads"
                        }
                    },
                    {
                        "ProductID": 69,
                        "ProductName": "Gudbrandsdalsost",
                        "SupplierID": 15,
                        "CategoryID": 4,
                        "QuantityPerUnit": "10 kg pkg.",
                        "UnitPrice": 36.0000,
                        "UnitsInStock": 26,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 15,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 4,
                            "CategoryName": "Dairy Products",
                            "Description": "Cheeses"
                        }
                    },
                    {
                        "ProductID": 70,
                        "ProductName": "Outback Lager",
                        "SupplierID": 7,
                        "CategoryID": 1,
                        "QuantityPerUnit": "24 - 355 ml bottles",
                        "UnitPrice": 15.0000,
                        "UnitsInStock": 15,
                        "UnitsOnOrder": 10,
                        "ReorderLevel": 30,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 1,
                            "CategoryName": "Beverages",
                            "Description": "Soft drinks, coffees, teas, beers, and ales"
                        }
                    },
                    {
                        "ProductID": 71,
                        "ProductName": "Flotemysost",
                        "SupplierID": 15,
                        "CategoryID": 4,
                        "QuantityPerUnit": "10 - 500 g pkgs.",
                        "UnitPrice": 21.5000,
                        "UnitsInStock": 26,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 4,
                            "CategoryName": "Dairy Products",
                            "Description": "Cheeses"
                        }
                    },
                    {
                        "ProductID": 72,
                        "ProductName": "Mozzarella di Giovanni",
                        "SupplierID": 14,
                        "CategoryID": 4,
                        "QuantityPerUnit": "24 - 200 g pkgs.",
                        "UnitPrice": 34.8000,
                        "UnitsInStock": 14,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 0,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 4,
                            "CategoryName": "Dairy Products",
                            "Description": "Cheeses"
                        }
                    },
                    {
                        "ProductID": 73,
                        "ProductName": "Röd Kaviar",
                        "SupplierID": 17,
                        "CategoryID": 8,
                        "QuantityPerUnit": "24 - 150 g jars",
                        "UnitPrice": 15.0000,
                        "UnitsInStock": 101,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 5,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 8,
                            "CategoryName": "Seafood",
                            "Description": "Seaweed and fish"
                        }
                    },
                    {
                        "ProductID": 74,
                        "ProductName": "Longlife Tofu",
                        "SupplierID": 4,
                        "CategoryID": 7,
                        "QuantityPerUnit": "5 kg pkg.",
                        "UnitPrice": 10.0000,
                        "UnitsInStock": 4,
                        "UnitsOnOrder": 20,
                        "ReorderLevel": 5,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 7,
                            "CategoryName": "Produce",
                            "Description": "Dried fruit and bean curd"
                        }
                    },
                    {
                        "ProductID": 75,
                        "ProductName": "Rhönbräu Klosterbier",
                        "SupplierID": 12,
                        "CategoryID": 1,
                        "QuantityPerUnit": "24 - 0.5 l bottles",
                        "UnitPrice": 7.7500,
                        "UnitsInStock": 125,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 25,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 1,
                            "CategoryName": "Beverages",
                            "Description": "Soft drinks, coffees, teas, beers, and ales"
                        }
                    },
                    {
                        "ProductID": 76,
                        "ProductName": "Lakkalikööri",
                        "SupplierID": 23,
                        "CategoryID": 1,
                        "QuantityPerUnit": "500 ml",
                        "UnitPrice": 18.0000,
                        "UnitsInStock": 57,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 20,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 1,
                            "CategoryName": "Beverages",
                            "Description": "Soft drinks, coffees, teas, beers, and ales"
                        }
                    },
                    {
                        "ProductID": 77,
                        "ProductName": "Original Frankfurter grüne Soße",
                        "SupplierID": 12,
                        "CategoryID": 2,
                        "QuantityPerUnit": "12 boxes",
                        "UnitPrice": 13.0000,
                        "UnitsInStock": 32,
                        "UnitsOnOrder": 0,
                        "ReorderLevel": 15,
                        "Discontinued": false,
                        "Category": {
                            "CategoryID": 2,
                            "CategoryName": "Condiments",
                            "Description": "Sweet and savory sauces, relishes, spreads, and seasonings"
                        }
                    }
                ];
        }
    }
});

In this article