topic Re: Command "setList" issue introducing variables from context in Cortex XSOAR Discussions

Command "setList" issue introducing variables from context

Josep — Thu, 01 Dec 2022 09:58:26 GMT

Hello,

We're using command "demisto.executeCommand("setList",{"listName":listName,"listData":listContent})" in order to introduce data in a json list. Where the "listName" is a json list name and "listContent" is data extracted from the context.

The issue:

The values introduced in "listContent" are like this example, "IPs" is a context variable that could be a single value or an array. And that's the main problem. If it's a single variable, it will be introduced like: "${Variable}":

{"value":{"IPs": "${Variable}"}

However, if it's introduced as an array, the " is no needed, so it will be: ${Variable}. With no comas:

{"value":{"IPs": ${Variable}}

So it's not possible to create the same command or task for both cases.

Re: Command "setList" issue introducing variables from context

jfernandes1 — Mon, 05 Dec 2022 04:24:12 GMT

Hi @Josep, The setList automation is designed to overwrite the data inside the list. Could you try addToList automation? It should work like shown in the screenshot.

Re: Command "setList" issue introducing variables from context

Josep — Mon, 05 Dec 2022 08:28:33 GMT

Good morning Fernandes and thanks for your answer.

The purpose using "SetList" is to overwritre the data. First, we download all json to context, we manipulate it, then "SetList" commmand updates using the context the json, overwriting. However, sometimes the value of the key-value pair can be an array, so this causes a malfunction.

Normally it will be: {"${key}": "${value}"}

But with an array should be: {"${key}": ${value_array}}, with no "

So the point is how to use the same json value format for both cases.

Re: Command "setList" issue introducing variables from context

jfernandes1 — Wed, 07 Dec 2022 22:25:33 GMT

Hi @Josep, the only option would be to merge\join the data before calling the setList command. You could try using the "Join" transformer. It will work with string and list inputs.

Re: Command "setList" issue introducing variables from context

Josep — Fri, 09 Dec 2022 07:20:07 GMT

Thanks Fernandes, I like how it sounds. Join first the list, so it won't be treated as an array.