topic Re: Use DT format inside an automation. in Cortex XSOAR Discussions

Use DT format inside an automation.

Josep — Tue, 03 Oct 2023 10:47:05 GMT

Hello,

We are working on an automation which calls many different lists of nested dicts. Example:

upField:

field1:value1

field2: value2

field1:value3

field2: value4

In a playbook it will be easy to call only field1 using this expression: ${upField.field1} . It will create an array with these values:

[value1, value3]

However, if we want to get these values in an automation, a loop "for" has to be created to go over each dict of the list. Turning into a tedious, heavy and not flexible automation.

To avoid this, we tried unsuccessfully to use the commands "demisto.executeCommand("jmespath",{})" and "demisto.executeCommand("demisto.dt()",{})".

How can we achieve a simple command similar to "${}" in an automation?

Re: Use DT format inside an automation.

gyldz — Tue, 03 Oct 2023 11:29:40 GMT

Hi @Josep ,

Can you please try the below dt statement?

field1_values = demisto.dt(upField, 'field1')

I hope it solves your problem!

Re: Use DT format inside an automation.

Josep — Tue, 03 Oct 2023 12:03:48 GMT

You are the best @gyldz, it worked.

The nested dict was deeper, I show you the full commnand to solve it:

Data = demisto.get(demisto.context(),"Data")
field1_values = demisto.dt(Data, 'upField.midField.downField')