Working with lists

Bar_Magnezi — Mon, 30 Oct 2023 11:59:58 GMT

Hi ,

In the settings section i created a new list

The list contains for example:

TEST,Mon Oct 30 2023,Teva.com/\teva.co.il/\test@gmail.com,user1,
BBLTD,Mon Oct 30 2023,10.0.0.14/\DASD.com/\sdasdas.co.il,user1,
BBMA,Mon Oct 30 2023,10.0.0.14/\DASD.com/\sdasdas.co.il,user2

in a playbook a user can choose 1 of the 3 ("TEST"/"BBLTD"/"BBMA")
Then the whole line should be deleted , the command !RemoveFromList only removes the specific word...

Re: Working with lists

AbelSantamarina — Tue, 12 Dec 2023 23:33:41 GMT

@Bar_Magnezi,

The command !RemoveFromList only removes single elements from a comma-separated list.
To remove the items from the list based on a user selection, you can do it following this simple process:

1. Survey the user with selection ("TEST"/"BBLTD"/"BBMA"). This can be a Data Collection task and it will record the answer in <DC Name>.Answers.0.
2. Load the content of your list into context data, splitting it by line break as delimiter. This can be a Set command with Split&Trim transformer.

3. From the list in context data, select the list item that contains the answer from the survey. For example, if the user selected BBLTD, this task will retrieve "BBLTD,Mon Oct 30 2023,10.0.0.14/\DASD.com/\sdasdas.co.il,user1,". You can do this by using a filter.
4. Compare this list item with the full list by using the automation CompareLists. This automation takes in two arguments, left and right and it will output the unique elements on each side. From this output, we're only interested in getting all the elements in the list, except the list item that the user selected.

5. We overwrite the list with the command setList.

I've attached here a simple playbook that does this process as a proof of concept. The prerequisite to run this is to have a list called TestLiveCommunityQuestion with this content:

TEST,Mon Oct 30 2023,Teva.com/\teva.co.il/\test@gmail.com,user1,
BBLTD,Mon Oct 30 2023,10.0.0.14/\DASD.com/\sdasdas.co.il,user1,
BBMA,Mon Oct 30 2023,10.0.0.14/\DASD.com/\sdasdas.co.il,user2

To use this playbook, unzip the yml file and upload it to your list of playbooks.

topic Re: Working with lists in Cortex XSOAR Discussions

Working with lists

Re: Working with lists