topic Re: Creation of table from arrays in Cortex XSOAR Discussions

Creation of table from arrays

JMaton1 — Thu, 06 Oct 2022 10:49:01 GMT

I am trying to create a table something like this:

I already have arrays (of names in this example) for each situation. So my HasX array would be like ["John", "Roger"] and my 'doesn't have X' array would be ["Steve"], and similar for Y with ["Roger", "Steve"] and ["John"] for the two properties.

I feel like I have all the information to turn this into a table like the above but had no luck so far. Any recommendations?

A formatted table or CSV would be good.

Re: Creation of table from arrays

bwebb — Thu, 15 Dec 2022 16:30:19 GMT

Cortex XSOAR supports the use of Markdown for formatting, which includes the ability to create tables such as the one in your example.

You can use the JsonToTable script (included in the Common Scripts pack) to build such tables without having to manually implement the necessary Markdown formatting.

Re: Creation of table from arrays

JMaton1 — Thu, 09 Feb 2023 13:29:27 GMT

Apologies this went by the wayside. I tried this among other options but couldn't get it to produce a table that combined different arrays.

I did end up using JsonToTable which produced a nice output in Microsoft Teams - but only once I had combined the arrays into a singe array of JSON objects.