Are you testing with one of your custom workflows or are you testing with the example workflow given with the integration?
If you are using a customer workflow, could you please test the example workflow named, "Example Data Utils: Update Row" and see if that works.
If it only happens with your customer workflows could you please send an example of your customer workflow, so I can get a better understanding of what is happening before the function, Data Table Utils: Update Row, is called.
------------------------------
Richard Swierk
------------------------------
Original Message:
Sent: Fri June 09, 2023 04:47 AM
From: Anu CN
Subject: Update Row in a Data Table Function
Hello Richard,
The error is in pre-processing script. Below is the erros exactly
Pre-processing script for Function 'Data Table Utils: Update Row' from Workflow 'Workflow_Name_Here' was unable to complete because: TypeError: 'NoneType' object is not subscriptable
Thanks,
Anu.
------------------------------
Anu CN
Original Message:
Sent: Tue June 06, 2023 09:18 AM
From: Richard Swierk
Subject: Update Row in a Data Table Function
Is the error occuring in the post-proccessing script or pre-proccssing script or function?
------------------------------
Richard Swierk
Original Message:
Sent: Tue June 06, 2023 02:16 AM
From: Anu CN
Subject: Update Row in a Data Table Function
Hello Richard,
We are on 49 Version SOAR and Python 3. This script also not working for us...We are getting the same error "TypeError: 'NoneType' object is not subscriptable"
Please advise.
Thanks,
Anu.
------------------------------
Anu CN
Original Message:
Sent: Mon June 05, 2023 10:57 AM
From: Richard Swierk
Subject: Update Row in a Data Table Function
What version of SOAR are you using? What version of python are you using for the pre-processing script?
I just tested with IBM Security QRadar SOAR version 46.0.8131 by creating a new data table activated playbook with the following input script,
from json import dumpsfrom datetime import datetime as datenow = int(date.now().timestamp()*1000)inputs.dt_utils_cells_to_update = dumps({"dt_col_name": "Updated Example", "text": "Update from datatable", "number": 1111, "multi_select": ["b", "e", "g"], "boolean": True, "datetime": now, "select": "2"})inputs.dt_utils_datatable_api_name = "dt_utils_test_data_table"inputs.dt_utils_row_id = 0inputs.incident_id = incident.id
and it worked as it should. All fields were changed.
------------------------------
Richard Swierk
Original Message:
Sent: Mon June 05, 2023 07:50 AM
From: Anu CN
Subject: Update Row in a Data Table Function
Hello Team,
I have used the Update Row in a Data Table function since years and it has always worked in my workflows. But this April month, it suddenly stopped working in my existing workflows (which used to work till April) throwing this error "TypeError: 'NoneType' object is not subscriptable"... Have troubleshooted with the Support but they denied help as this app "IBM SOAR Data Table Helper Functions" is a community app.
I have also tested the Update row in a Data table function by explicitly giving the values to be updated, and even then the same error was thrown. Please advice.
Regards,
Anu.
------------------------------
Anu CN
------------------------------