{
    "cellEditingEnabled": false,                  // {boolean} Optional. Specifies whether Cell editing is enabled by default for the grid, required for auto-save use-case. Disable for manual save; enable 'editButtons' in config below instead.
    "enableFooter":false,
    "columns":{
       "idFieldName":"id",
       "header":{
          "titleCase":"",
          "overflow":"tooltip"
       },
       "columnDefs":[
          {
             "fieldName":"Shift",
             "overflow":"tooltip",
             "columnFormatter":{
                "type":"html",
                 "format":'unsanitized'
             },
             "hidden":false,
             "textAlignment":"center",
             "inLayout":true,
             "width":"45px",
             "autoWidth":false,
             "headerTextAlignment":"center",
             "title":" ",
             "targets":2
          },
          {
             "fieldName":"UserName",
             "overflow":"tooltip",
             "columnFormatter":{
                "type":"html",
                 "format":'unsanitized'
             },
             "hidden":false,
             "textAlignment":"left",
             "inLayout":true,
             "width":"200px",
             "autoWidth":false,
             "headerTextAlignment":"center",
             "title":" ",
             "targets":1
          }
       ]
    },
   "rows":       {                               // Optional
     "selection":                  "none",      // *{string} row selection setting. Options: 'none, 'single', 'multi'
     "defaultSelectedRows":        "",           // *{string} default row selection setting starting with row 1. Options: '1', '1,2,3', '1-5,10'
     "minHeight":                  "22",         // {string} row height setting in px.
     "autoScroll":                 true          // {boolean} scroll to the selected rows on update or resize
   },
   "styles":     {                               // Optional unless styles are defined in state formatters
     "tableWrapperStyle":              {         // {string} name of the style.
       "backgroundColor":          "#ffffff",    // {string} the background style color
       "secondaryBackgroundColor": "",           // {string} the secondary background style color for a gradient.
       "foregroundColor":          "",           // {string} the font color.
       "textDecoration":           "",           // {string} text decoration settings. Options: 'underline', 'line-through', 'overline'
       "image":                    "",           // {string} MediaEntity url
       "lineColor":                "#b3b3b3",    // {string} the color of the cell outline.
       "borderStyle":              "solid",      // {string} the style of the cell outline. Options: 'dotted', 'dashed', 'solid', 'double', 'groove', 'ridge', 'inset', 'outset', 'none', hidden.
       "borderWidth":              "1px",        // {string} the width of cell border in px.
       "fontFamily":               ["helvetica", "arial"],  // {string[]} array of fonts.
       "fontStyle":                "normal",     // {string} the style of the font. Options: 'normal', 'italic', 'oblique'
       "fontSize":                 "11px",       // {string} font size.
       "fontWeight":               "normal"      // {string} font weight. Options: 'normal', 'bold', 'bolder', 'lighter', number
     },
     "tableHeaderStyle":              {
       "backgroundColor":          "#F3F2F1",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "#202020",
       "textDecoration":           "",
       "image":                    "",
       "lineColor":                "#c0c0c0",
       "borderStyle":              "solid",
       "borderWidth":              "0px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "11px",
       "fontWeight":               "bold"
     },
     "rowBorderStyle":                {
       "backgroundColor":          "",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "",
       "textDecoration":           "",
       "image":                    "",
       "lineColor":                "#E9ECEF",
       "borderStyle":              "solid",
       "borderWidth":              "1px",
       "fontFamily":               "",
       "fontStyle":                "",
       "fontSize":                 "",
       "fontWeight":               ""
     },
     "cellBorderStyle":               {
       "backgroundColor":          "",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "",
       "textDecoration":           "underline",
       "image":                    "",
       "lineColor":                "#E9ECEF",
       "borderStyle":              "solid",
       "borderWidth":              "1px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "11px",
       "fontWeight":               "bold"
     },
     "rowBackgroundStyle":            {
       "backgroundColor":          "",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "",
       "textDecoration":           "",
       "image":                    "",
       "lineColor":                "",
       "borderStyle":              "",
       "borderWidth":              "2px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "11px",
       "fontWeight":               ""
     },
     "rowAlternateBackgroundStyle":   {
       "backgroundColor":          "",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "",
       "textDecoration":           "",
       "image":                    "",
       "lineColor":                "",
       "borderStyle":              "",
       "borderWidth":              "",
       "fontFamily":               "",
       "fontStyle":                "",
       "fontSize":                 "11px",
       "fontWeight":               ""
     },
     "rowHoverStyle":                 {
       "backgroundColor":          "#dddddd",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "#333333",
       "textDecoration":           "",
       "image":                    "",
       "lineColor":                "",
       "borderStyle":              "",
       "borderWidth":              "1px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "11px",
       "fontWeight":               "normal"
     },
     "rowSelectedStyle":              {
       "backgroundColor":          "#C8DDF1",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "#000000",
       "textDecoration":           "",
       "image":                    "/Thingworx/MediaEntities/SubsystemNotRunning",
       "lineColor":                "#C8DDF1",
       "borderStyle":              "solid",
       "borderWidth":              "0px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "11px",
       "fontWeight":               "normal"
     },
     "paginationButtonStyle": {
       "backgroundColor":          "#EEEEEE",
       "secondaryBackgroundColor": "#FFFFFF",
       "foregroundColor":          "#202020",
       "textDecoration":           "",
       "image":                    "",
       "lineColor":                "",
       "borderStyle":              "solid",
       "borderWidth":              "1px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "12px",
       "fontWeight":               "bold"
     },
     "paginationHoverStyle": {
       "backgroundColor":          "#252525",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "#ffffff",
       "textDecoration":           "",
       "image":                    "",
       "lineColor":                "",
       "borderStyle":              "solid",
       "borderWidth":              "1px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "12px",
       "fontWeight":               "bold"
     },
     "paginationSelectedStyle": {
       "backgroundColor":          "#0088cc",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "#ffffff",
       "textDecoration":           "",
       "image":                    "",
       "lineColor":                "",
       "borderStyle":              "solid",
       "borderWidth":              "1px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "12px",
       "fontWeight":               "bold"
     },
     "toolbarStyle": {
       "backgroundColor":          "#fafafa",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "#202020",
       "textDecoration":           "",
       "image":                    "",
       "lineColor":                "",
       "borderStyle":              "solid",
       "borderWidth":              "1px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "12px",
       "fontWeight":               ""
     },
     "rowFormatterStyle":             {
       "backgroundColor":          "#636262",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "white",
       "textDecoration":           "underline",
       "image":                    "",
       "lineColor":                "black",
       "borderStyle":              "solid",
       "borderWidth":              "1px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "14px",
       "fontWeight":               "bold"
     },
     "sortAscendingStyle": {
       "backgroundColor":          "",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "",
       "textDecoration":           "",
       "image":                    "/Thingworx/MediaEntities/GridSortAscendingArrow",
       "lineColor":                "",
       "borderStyle":              "",
       "borderWidth":              "",
       "fontFamily":               "",
       "fontStyle":                "",
       "fontSize":                 "",
       "fontWeight":               ""
     },
     "sortDescendingStyle": {
       "backgroundColor":          "",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "",
       "textDecoration":           "",
       "image":                    "/Thingworx/MediaEntities/GridSortDescendingArrow",
       "lineColor":                "",
       "borderStyle":              "",
       "borderWidth":              "",
       "fontFamily":               "",
       "fontStyle":                "",
       "fontSize":                 "",
       "fontWeight":               ""
     },
     "rowIconStyle": {
         "backgroundColor":          "",
         "secondaryBackgroundColor": "",
         "foregroundColor":          "",
         "textDecoration":           "",
         "image":                    "/Thingworx/MediaEntities/GridRowIcon",
         "lineColor":                "",
         "borderStyle":              "",
         "borderWidth":              "",
         "fontFamily":               "",
         "fontStyle":                "",
         "fontSize":                 "",
         "fontWeight":               ""
     },
     "rowExpansionIconStyle": {
         "backgroundColor":          "",
         "secondaryBackgroundColor": "",
         "foregroundColor":          "",
         "textDecoration":           "",
         "image":                    "/Thingworx/MediaEntities/GridRowExpansionIcon",
         "lineColor":                "",
         "borderStyle":              "",
         "borderWidth":              "",
         "fontFamily":               "",
         "fontStyle":                "",
         "fontSize":                 "",
         "fontWeight":               ""
     },
     "rowCollapseIconStyle": {
         "backgroundColor":          "",
         "secondaryBackgroundColor": "",
         "foregroundColor":          "",
         "textDecoration":           "",
         "image":                    "/Thingworx/MediaEntities/GridRowCollapseIcon",
         "lineColor":                "",
         "borderStyle":              "",
         "borderWidth":              "",
         "fontFamily":               "",
         "fontStyle":                "",
         "fontSize":                 "",
         "fontWeight":               ""
     },
     "snowFormatterStyle":             {
       "backgroundColor":          "",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "black",
       "textDecoration":           "",
       "image":                    "",
       "lineColor":                "black",
       "borderStyle":              "solid",
       "borderWidth":              "0px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "11px",
       "fontWeight":               "bold"
     },
     "coldFormatterStyle":             {
       "backgroundColor":          "",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "black",
       "textDecoration":           "underline",
       "image":                    "/Thingworx/MediaEntities/SubsystemNotRunning",
       "lineColor":                "black",
       "borderStyle":              "",
       "borderWidth":              "",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "14px",
       "fontWeight":               "bold"
     },
     "warmFormatterStyle":             {
       "backgroundColor":          "",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "black",
       "textDecoration":           "underline",
       "image":                    "/Thingworx/MediaEntities/SubsystemRunning",
       "lineColor":                "black",
       "borderStyle":              "",
       "borderWidth":              "",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "14px",
       "fontWeight":               "bold"
     },
     "cellValidationErrorStyle":             {
       "backgroundColor":          "",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "black",
       "textDecoration":           "none",
       "image":                    "",
       "lineColor":                "red",
       "borderStyle":              "solid",
       "borderWidth":              "1px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "11px",
       "fontWeight":               "normal"
     },
     "cellValidationErrorTooltipStyle":             {
       "backgroundColor":          "red",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "white",
       "textDecoration":           "none",
       "image":                    "",
       "lineColor":                "white",
       "borderStyle":              "solid",
       "borderWidth":              "1px",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "11px",
       "fontWeight":               "normal"
     },
     "tooltipStyle": {
       "backgroundColor":          "#0000ff",
       "secondaryBackgroundColor": "",
       "foregroundColor":          "#ffffff",
       "textDecoration":           "",
       "image":                    "",
       "lineColor":                "",
       "borderStyle":              "none",
       "borderWidth":              "",
       "fontFamily":               ["helvetica", "arial"],
       "fontStyle":                "normal",
       "fontSize":                 "12px",
       "fontWeight":               ""
     },
   },
   "search": {                                    // Optional search capabilities
     "multiColumn":  {                            // Optional global grid search control
       "enabled":  false,                          // {boolean} enable the grid search toolbar
       "location": "top-left"                     // {string} location of grid search toolbar. Options: 'top-right', 'top-left', 'bottom-right', 'bottom-left'
     }
   },
   "resetButton": {                               // Optional reset button that allows the end-user to reset the user specific grid settings. It clears all the grid cookie values.
     "enabled": false,                             // {boolean} show the reset button in the Mashup.
     "location": "top-right"                      // {string} Location of the reset button. Options:  top-right', 'top-left', 'bottom-right', 'bottom-left'
   }
  }