Use DT format inside an automation.

[Josep]

Hello,

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

upField:

0:

field1:value1

field2: value2

1:

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?

[gyldz · Accepted solution]

Hi @Josep ,

Can you please try the below dt statement?

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

I hope it solves your problem!

[Josep]

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')