topic Re: ParseExcel automation issue in Cortex XSOAR Discussions

ParseExcel automation issue

FrancescoBarducci — Tue, 26 Sep 2023 11:03:28 GMT

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

Re: ParseExcel automation issue

amontminy — Tue, 26 Sep 2023 17:30:58 GMT

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.

Re: ParseExcel automation issue

FrancescoBarducci — Wed, 27 Sep 2023 09:11:52 GMT

Thank you very much