SetGridField

Update Grid Table from items or key value pairs.

Script Data


NameDescription
Script Typepython3
Tags
Demisto Version5.0.0

Inputs


Argument NameDescription
context_pathContext path to list of items with similar properties or key value pairs.
grid_idGrid ID to modify. This argument can be either: 1) Grid name as it appears in the layout. 2) Grid "Machine name", as can be found in the grid incident field editor under Settings->Advanced->Fields (Incidents).
overwriteTrue if to overwrite Grid Data, False otherwise.
columnsComma-separated list of grid columns to populate (as appear in the original Grid), for example: (col1,col2,..,coln).
keysKeys to retrieve from items or "*" for max keys (limited when item list to columns amount) - Key will not be columns correlated. If you want to leave an empty column, please provide a place holder name that should not be in the context data such as "PLACE_HOLDER"
sort_byColumn name to sort the rows by.

Command Example

Assume the following:

  1. Entry Context:
{
"EWS": {
"Items": {
"HeadersMap": {
"X-MS-Exchange-Organization-AuthSource": "Value1",
"Received": "Value2",
"Thread-Index": "Value3",
"Accept-Language": "Value4"
},
"headers": [
{
"name": "name1",
"value": "value1"
},
{
"name": "name2",
"value": "value2"
},
{
"name": "name3",
"value": "value3"
},
{
"name": "name4",
"value": "value4"
}
]
}
}
}
  1. Grid: \ Grid

Considering the following cases:

  1. Key value to Grid:
!SetGridField columns="columnheade1,columnheade2,columnheade3" context_path=EWS.Items.HeadersMap grid_id=mygrid keys="Received,Thread-Index"

Grid after update: \ Grid

  1. List of item properties to Grid:
!SetGridField columns="columnheade1,columnheade2,columnheade3" context_path=EWS.Items.headers grid_id=mygrid keys="Received,Thread-Index"

Grid after update: \ Grid