hello,
using XSOAR I wanted to parse an excel from an e-mail and insert the information into a table. I created a Grid field by inserting it inside the incident, used ParseExcel inside a playbook setting as "Mapping" inside the automation to identify the output and then inserted it inside the created Grid field as you can see from the image.
Unfortunately, however, in the incident layout the grid field "ExcelData" is empty each time an incident is created. Do you have any suggestions on how to perform this type of task?
Thank you very much
Regards
I would recommend adding a SetGridField automation after ParseExcel to handle mapping the ParseExcel values into the GridField. Here is an example of how I got it to work for a grid field named ExcelData. One thing to note, you will want to reference ParseExcel.[0] since the ParseExcel automation creates an output that is a list so [0] is where your Excel data is located. Also, if you haven't already, I would recommend editing your column headers in the field itself and then make sure to use those new names in the SetGridField automation in the columns input.
I would recommend adding a SetGridField automation after ParseExcel to handle mapping the ParseExcel values into the GridField. Here is an example of how I got it to work for a grid field named ExcelData. One thing to note, you will want to reference ParseExcel.[0] since the ParseExcel automation creates an output that is a list so [0] is where your Excel data is located. Also, if you haven't already, I would recommend editing your column headers in the field itself and then make sure to use those new names in the SetGridField automation in the columns input.
