IBM QRadar SOAR

 View Only
  • 1.  Update Row in a Data Table Function

    Posted Mon June 05, 2023 07:51 AM

    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
    ------------------------------


  • 2.  RE: Update Row in a Data Table Function

    Posted Mon June 05, 2023 10:57 AM

    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 dumps
    from datetime import datetime as date
    now = 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 = 0
    inputs.incident_id = incident.id

    and it worked as it should. All fields were changed.



    ------------------------------
    Richard Swierk
    ------------------------------



  • 3.  RE: Update Row in a Data Table Function

    Posted Tue June 06, 2023 02:16 AM

    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
    ------------------------------



  • 4.  RE: Update Row in a Data Table Function

    Posted Tue June 06, 2023 09:19 AM

    Is the error occuring in the post-proccessing script or pre-proccssing script or function?



    ------------------------------
    Richard Swierk
    ------------------------------



  • 5.  RE: Update Row in a Data Table Function

    Posted Fri June 09, 2023 04:48 AM

    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
    ------------------------------



  • 6.  RE: Update Row in a Data Table Function

    Posted Mon June 12, 2023 08:56 AM

    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
    ------------------------------