Hello team,

We are working with data tables in resilient. The requirement is to access the data in the datatable "Sentinel Incident Entities" and to access a particular cell in the row that is under the column "Entity Properties". In the above example, we need to access the particular value "additional data : " in the cell( second row fourth column).

Hello team,

We are working with data tables in resilient. The requirement is to access the data in the datatable "Sentinel Incident Entities" and to access a particular cell in the row that is under the column "Entity Properties". In the above example, we need to access the particular value "additional data : " in the cell( second row fourth column).

Hello team,

We are working with data tables in resilient. The requirement is to access the data in the datatable "Sentinel Incident Entities" and to access a particular cell in the row that is under the column "Entity Properties". In the above example, we need to access the particular value "additional data : " in the cell( second row fourth column).

Hi Akash -

Yes, you can access the full row of a data table when you create a Playbook or Workflow that is activate on that type of data table.

I'll take the Playbook example to show you what this looks like:

• Create a new playbook (manual or automatic, both will work for this)
• Select object type "Data table"
• You'll see a new drop down appear below the object type, asking for the specific Data table you wish to activate this playbook on
• Select the data table from the drop down
• Now when you write a script within this playbook, you'll have access to the row object which has all of the row's cell values
• You can access those values, you can modify them, etc...
• More documentation on row operations can be found here: https://www.ibm.com/docs/en/sqsp/51?topic=scripts-row-operations

I hope that helps!

If you need to do more complicated operations within a data table, I recommend using the "IBM SOAR Data Table Helper Functions" app on App Exchange which provides extended data table functionality in the form of functions that can be used in any playbook or workflow.

Hello team,

We are working with data tables in resilient. The requirement is to access the data in the datatable "Sentinel Incident Entities" and to access a particular cell in the row that is under the column "Entity Properties". In the above example, we need to access the particular value "additional data : " in the cell( second row fourth column).

Thanks, Bleckel, 

now I am able to get the value of one particular row but in the table, for entity column we have type account in two rows.

now when I run the script, Im only able to get the value of only one row and the values im storing in a different field of text area type.

my goal is to get all the value of type account

for ex

if entity type=="Account"

 then i should get the value of entity properties from all the rows having type account in a single field 

Hi Akash -

Yes, you can access the full row of a data table when you create a Playbook or Workflow that is activate on that type of data table.

I'll take the Playbook example to show you what this looks like:

• Create a new playbook (manual or automatic, both will work for this)
• Select object type "Data table"
• You'll see a new drop down appear below the object type, asking for the specific Data table you wish to activate this playbook on
• Select the data table from the drop down
• Now when you write a script within this playbook, you'll have access to the row object which has all of the row's cell values
• You can access those values, you can modify them, etc...
• More documentation on row operations can be found here: https://www.ibm.com/docs/en/sqsp/51?topic=scripts-row-operations

I hope that helps!

If you need to do more complicated operations within a data table, I recommend using the "IBM SOAR Data Table Helper Functions" app on App Exchange which provides extended data table functionality in the form of functions that can be used in any playbook or workflow.

Hello team,

We are working with data tables in resilient. The requirement is to access the data in the datatable "Sentinel Incident Entities" and to access a particular cell in the row that is under the column "Entity Properties". In the above example, we need to access the particular value "additional data : " in the cell( second row fourth column).

Ah ok. Then I suggest you design a Incident-level playbook which makes use of the "Get all data table rows" function from the "IBM SOAR Data Table Helper Functions" app on App Exchange.

The results of this function give you a list of rows which you can then iterate over and check the cell value for each.

Example script to process the results from that function call:

for row in playbook.functions.results.<output_name>.content.rows:    cells = row.get("cells")    for cell in cells:        # do whatever you want here with the cell

I hope this helps!

Bo

Thanks, Bleckel, 

now I am able to get the value of one particular row but in the table, for entity column we have type account in two rows.

now when I run the script, Im only able to get the value of only one row and the values im storing in a different field of text area type.

my goal is to get all the value of type account

for ex

if entity type=="Account"

 then i should get the value of entity properties from all the rows having type account in a single field 

Hi Akash -

Yes, you can access the full row of a data table when you create a Playbook or Workflow that is activate on that type of data table.

I'll take the Playbook example to show you what this looks like:

• Create a new playbook (manual or automatic, both will work for this)
• Select object type "Data table"
• You'll see a new drop down appear below the object type, asking for the specific Data table you wish to activate this playbook on
• Select the data table from the drop down
• Now when you write a script within this playbook, you'll have access to the row object which has all of the row's cell values
• You can access those values, you can modify them, etc...
• More documentation on row operations can be found here: https://www.ibm.com/docs/en/sqsp/51?topic=scripts-row-operations

I hope that helps!

If you need to do more complicated operations within a data table, I recommend using the "IBM SOAR Data Table Helper Functions" app on App Exchange which provides extended data table functionality in the form of functions that can be used in any playbook or workflow.

Hello team,

We are working with data tables in resilient. The requirement is to access the data in the datatable "Sentinel Incident Entities" and to access a particular cell in the row that is under the column "Entity Properties". In the above example, we need to access the particular value "additional data : " in the cell( second row fourth column).

getting the following error for this script

for row in playbook.functions.results.rowdata.content.rows:
    cells = row.get("cells")
    incident.properties.test_datatable=cells

Ah ok. Then I suggest you design a Incident-level playbook which makes use of the "Get all data table rows" function from the "IBM SOAR Data Table Helper Functions" app on App Exchange.

The results of this function give you a list of rows which you can then iterate over and check the cell value for each.

Example script to process the results from that function call:

for row in playbook.functions.results.<output_name>.content.rows:    cells = row.get("cells")    for cell in cells:        # do whatever you want here with the cell

I hope this helps!

Bo

Thanks, Bleckel, 

now I am able to get the value of one particular row but in the table, for entity column we have type account in two rows.

now when I run the script, Im only able to get the value of only one row and the values im storing in a different field of text area type.

my goal is to get all the value of type account

for ex

if entity type=="Account"

 then i should get the value of entity properties from all the rows having type account in a single field 

Hi Akash -

Yes, you can access the full row of a data table when you create a Playbook or Workflow that is activate on that type of data table.

I'll take the Playbook example to show you what this looks like:

• Create a new playbook (manual or automatic, both will work for this)
• Select object type "Data table"
• You'll see a new drop down appear below the object type, asking for the specific Data table you wish to activate this playbook on
• Select the data table from the drop down
• Now when you write a script within this playbook, you'll have access to the row object which has all of the row's cell values
• You can access those values, you can modify them, etc...
• More documentation on row operations can be found here: https://www.ibm.com/docs/en/sqsp/51?topic=scripts-row-operations

I hope that helps!

If you need to do more complicated operations within a data table, I recommend using the "IBM SOAR Data Table Helper Functions" app on App Exchange which provides extended data table functionality in the form of functions that can be used in any playbook or workflow.

Hello team,

We are working with data tables in resilient. The requirement is to access the data in the datatable "Sentinel Incident Entities" and to access a particular cell in the row that is under the column "Entity Properties". In the above example, we need to access the particular value "additional data : " in the cell( second row fourth column).

Ok - well the example I gave was to use in a script that runs after the function is used, and specifically I assumed you were using a playbook.

You'll have to decide how you'll use the function and then process the results. It appears that you're running this as a script test? You won't be able to do that exactly... You'll have to plug this in as a script after the function and play around with it until it works.

If you need help with a specific instance of a playbook and you're willing to share, I'd be happy to take a look at it as a whole and give feedback.

Bo

------------------------------
Bo Bleckel

Original Message:
Sent: Sat January 27, 2024 08:44 AM
From: Akash Jaiswal
Subject: How to access value of any cell in a data table using playbook or workflow

getting the following error for this script

for row in playbook.functions.results.rowdata.content.rows:
    cells = row.get("cells")
    incident.properties.test_datatable=cells

------------------------------
Akash Jaiswal

Original Message:
Sent: Fri January 26, 2024 12:54 PM
From: Bo Bleckel
Subject: How to access value of any cell in a data table using playbook or workflow

Ah ok. Then I suggest you design a Incident-level playbook which makes use of the "Get all data table rows" function from the "IBM SOAR Data Table Helper Functions" app on App Exchange.

The results of this function give you a list of rows which you can then iterate over and check the cell value for each.

Example script to process the results from that function call:

for row in playbook.functions.results.<output_name>.content.rows:    cells = row.get("cells")    for cell in cells:        # do whatever you want here with the cell

I hope this helps!

Bo

------------------------------
Bo Bleckel

Original Message:
Sent: Fri January 26, 2024 12:44 PM
From: Akash Jaiswal
Subject: How to access value of any cell in a data table using playbook or workflow

Thanks, Bleckel, 

now I am able to get the value of one particular row but in the table, for entity column we have type account in two rows.

now when I run the script, Im only able to get the value of only one row and the values im storing in a different field of text area type.

my goal is to get all the value of type account

for ex

if entity type=="Account"

 then i should get the value of entity properties from all the rows having type account in a single field 

------------------------------
Akash Jaiswal

Original Message:
Sent: Wed January 24, 2024 08:39 AM
From: Bo Bleckel
Subject: How to access value of any cell in a data table using playbook or workflow

Hi Akash -

Yes, you can access the full row of a data table when you create a Playbook or Workflow that is activate on that type of data table.

I'll take the Playbook example to show you what this looks like:

• Create a new playbook (manual or automatic, both will work for this)
• Select object type "Data table"
• You'll see a new drop down appear below the object type, asking for the specific Data table you wish to activate this playbook on
• Select the data table from the drop down
• Now when you write a script within this playbook, you'll have access to the row object which has all of the row's cell values
• You can access those values, you can modify them, etc...
• More documentation on row operations can be found here: https://www.ibm.com/docs/en/sqsp/51?topic=scripts-row-operations

I hope that helps!

If you need to do more complicated operations within a data table, I recommend using the "IBM SOAR Data Table Helper Functions" app on App Exchange which provides extended data table functionality in the form of functions that can be used in any playbook or workflow.

------------------------------
Bo Bleckel

Original Message:
Sent: Wed January 24, 2024 01:57 AM
From: Akash Jaiswal
Subject: How to access value of any cell in a data table using playbook or workflow

Hello team,

We are working with data tables in resilient. The requirement is to access the data in the datatable "Sentinel Incident Entities" and to access a particular cell in the row that is under the column "Entity Properties". In the above example, we need to access the particular value "additional data : " in the cell( second row fourth column).

------------------------------
Akash Jaiswal
------------------------------

Hi Bo,I have added the Playbook Screenshot as well as the result I'm getting when I run the playbook manually on a particular incident

can you help me to understand why I'm  getting this error or anything  I'm doing  wrong

, 

------------------------------
Akash Jaiswal

Original Message:
Sent: Mon January 29, 2024 08:30 AM
From: Bo Bleckel
Subject: How to access value of any cell in a data table using playbook or workflow

Ok - well the example I gave was to use in a script that runs after the function is used, and specifically I assumed you were using a playbook.

You'll have to decide how you'll use the function and then process the results. It appears that you're running this as a script test? You won't be able to do that exactly... You'll have to plug this in as a script after the function and play around with it until it works.

If you need help with a specific instance of a playbook and you're willing to share, I'd be happy to take a look at it as a whole and give feedback.

Bo

------------------------------
Bo Bleckel

Original Message:
Sent: Sat January 27, 2024 08:44 AM
From: Akash Jaiswal
Subject: How to access value of any cell in a data table using playbook or workflow

getting the following error for this script

for row in playbook.functions.results.rowdata.content.rows:
    cells = row.get("cells")
    incident.properties.test_datatable=cells

------------------------------
Akash Jaiswal

Original Message:
Sent: Fri January 26, 2024 12:54 PM
From: Bo Bleckel
Subject: How to access value of any cell in a data table using playbook or workflow

Ah ok. Then I suggest you design a Incident-level playbook which makes use of the "Get all data table rows" function from the "IBM SOAR Data Table Helper Functions" app on App Exchange.

The results of this function give you a list of rows which you can then iterate over and check the cell value for each.

Example script to process the results from that function call:

for row in playbook.functions.results.<output_name>.content.rows:    cells = row.get("cells")    for cell in cells:        # do whatever you want here with the cell

I hope this helps!

Bo

------------------------------
Bo Bleckel

Original Message:
Sent: Fri January 26, 2024 12:44 PM
From: Akash Jaiswal
Subject: How to access value of any cell in a data table using playbook or workflow

Thanks, Bleckel, 

now I am able to get the value of one particular row but in the table, for entity column we have type account in two rows.

now when I run the script, Im only able to get the value of only one row and the values im storing in a different field of text area type.

my goal is to get all the value of type account

for ex

if entity type=="Account"

 then i should get the value of entity properties from all the rows having type account in a single field 

------------------------------
Akash Jaiswal

Original Message:
Sent: Wed January 24, 2024 08:39 AM
From: Bo Bleckel
Subject: How to access value of any cell in a data table using playbook or workflow

Hi Akash -

Yes, you can access the full row of a data table when you create a Playbook or Workflow that is activate on that type of data table.

I'll take the Playbook example to show you what this looks like:

• Create a new playbook (manual or automatic, both will work for this)
• Select object type "Data table"
• You'll see a new drop down appear below the object type, asking for the specific Data table you wish to activate this playbook on
• Select the data table from the drop down
• Now when you write a script within this playbook, you'll have access to the row object which has all of the row's cell values
• You can access those values, you can modify them, etc...
• More documentation on row operations can be found here: https://www.ibm.com/docs/en/sqsp/51?topic=scripts-row-operations

I hope that helps!

If you need to do more complicated operations within a data table, I recommend using the "IBM SOAR Data Table Helper Functions" app on App Exchange which provides extended data table functionality in the form of functions that can be used in any playbook or workflow.

------------------------------
Bo Bleckel

Original Message:
Sent: Wed January 24, 2024 01:57 AM
From: Akash Jaiswal
Subject: How to access value of any cell in a data table using playbook or workflow

Hello team,

We are working with data tables in resilient. The requirement is to access the data in the datatable "Sentinel Incident Entities" and to access a particular cell in the row that is under the column "Entity Properties". In the above example, we need to access the particular value "additional data : " in the cell( second row fourth column).

------------------------------
Akash Jaiswal
------------------------------

Hi Akash - may I recommend two things:

• Set the inputs for incident id from the hard coded incident ID to incident.id
• Make sure that you use the output name of the function correctly in the script that processes the results. In this case, change playbook.functions.results.rowdata to playbook.functions.results.changerowdata since that's the name you've given the function results

Hi Bo,I have added the Playbook Screenshot as well as the result I'm getting when I run the playbook manually on a particular incident

can you help me to understand why I'm  getting this error or anything  I'm doing  wrong

, 

------------------------------
Akash Jaiswal

Original Message:
Sent: Mon January 29, 2024 08:30 AM
From: Bo Bleckel
Subject: How to access value of any cell in a data table using playbook or workflow

Ok - well the example I gave was to use in a script that runs after the function is used, and specifically I assumed you were using a playbook.

You'll have to decide how you'll use the function and then process the results. It appears that you're running this as a script test? You won't be able to do that exactly... You'll have to plug this in as a script after the function and play around with it until it works.

If you need help with a specific instance of a playbook and you're willing to share, I'd be happy to take a look at it as a whole and give feedback.

Bo

------------------------------
Bo Bleckel

Original Message:
Sent: Sat January 27, 2024 08:44 AM
From: Akash Jaiswal
Subject: How to access value of any cell in a data table using playbook or workflow

getting the following error for this script

for row in playbook.functions.results.rowdata.content.rows:
    cells = row.get("cells")
    incident.properties.test_datatable=cells

------------------------------
Akash Jaiswal

Original Message:
Sent: Fri January 26, 2024 12:54 PM
From: Bo Bleckel
Subject: How to access value of any cell in a data table using playbook or workflow

Ah ok. Then I suggest you design a Incident-level playbook which makes use of the "Get all data table rows" function from the "IBM SOAR Data Table Helper Functions" app on App Exchange.

The results of this function give you a list of rows which you can then iterate over and check the cell value for each.

Example script to process the results from that function call:

for row in playbook.functions.results.<output_name>.content.rows:    cells = row.get("cells")    for cell in cells:        # do whatever you want here with the cell

I hope this helps!

Bo

------------------------------
Bo Bleckel

Original Message:
Sent: Fri January 26, 2024 12:44 PM
From: Akash Jaiswal
Subject: How to access value of any cell in a data table using playbook or workflow

Thanks, Bleckel, 

now I am able to get the value of one particular row but in the table, for entity column we have type account in two rows.

now when I run the script, Im only able to get the value of only one row and the values im storing in a different field of text area type.

my goal is to get all the value of type account

for ex

if entity type=="Account"

 then i should get the value of entity properties from all the rows having type account in a single field 

------------------------------
Akash Jaiswal

Original Message:
Sent: Wed January 24, 2024 08:39 AM
From: Bo Bleckel
Subject: How to access value of any cell in a data table using playbook or workflow

Hi Akash -

Yes, you can access the full row of a data table when you create a Playbook or Workflow that is activate on that type of data table.

I'll take the Playbook example to show you what this looks like:

• Create a new playbook (manual or automatic, both will work for this)
• Select object type "Data table"
• You'll see a new drop down appear below the object type, asking for the specific Data table you wish to activate this playbook on
• Select the data table from the drop down
• Now when you write a script within this playbook, you'll have access to the row object which has all of the row's cell values
• You can access those values, you can modify them, etc...
• More documentation on row operations can be found here: https://www.ibm.com/docs/en/sqsp/51?topic=scripts-row-operations

I hope that helps!

If you need to do more complicated operations within a data table, I recommend using the "IBM SOAR Data Table Helper Functions" app on App Exchange which provides extended data table functionality in the form of functions that can be used in any playbook or workflow.

------------------------------
Bo Bleckel

Original Message:
Sent: Wed January 24, 2024 01:57 AM
From: Akash Jaiswal
Subject: How to access value of any cell in a data table using playbook or workflow

Hello team,

We are working with data tables in resilient. The requirement is to access the data in the datatable "Sentinel Incident Entities" and to access a particular cell in the row that is under the column "Entity Properties". In the above example, we need to access the particular value "additional data : " in the cell( second row fourth column).

------------------------------
Akash Jaiswal
------------------------------