topic Re: Rename table headers in Cortex XSOAR Discussions

Rename table headers

nivnetanel96 — Sun, 13 Oct 2024 10:48:28 GMT

Hi all 😀

I have a table of data in Cortex XSOAR (e.g., a list of dictionaries with results from a query), and I need to rename one of the column headers before processing it further in my playbook.

For example, I want to rename the column oldName to newName. How can I achieve this either within a script, automation, or as part of a playbook task?

If there are any best practices or recommended approaches for handling this kind of column renaming, I'd appreciate the guidance!

Thanks!

Re: Rename table headers

akoppad — Tue, 15 Oct 2024 18:25:42 GMT

@nivnetanel96 Are these table headers the keys of list of dictionaries you are getting back in response to your query? So when you say you want to change the header value do mean that you want to change one of the dict keys so that when you display them in a table the header is changed?

Re: Rename table headers

jfernandes1 — Thu, 17 Oct 2024 03:07:46 GMT

Hi @nivnetanel96, this is the simplest way I can think of without modifying the context.

Example using the File key. Table below showing the original value of the key as a table.

Same ToTable function with a bunch of transformers applied.

The output should looks like below.

There are other methods but they require some programming knowledge and modification of the CommonServerUserPython script. You can check the pascalToSpace function inside CommonServerPython as an example.

Thanks,

Jeremy.