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