Hi team,
I want to run "Execute custom query" from Microsoft365Defender Integration. query is:
EmailEvents | where Subject contains "testvalue".
This query returns result table which has rows and columns in json format.
for example,
row1 {col1:val1, col2:val2,..}, row2{col1:val1, col2:val2,..},row...
DeliveryLocation is one of the column names from the json result.
I need to check whether DeliveryLocation=Inbox/folder and for each row where this condition is met, should remediate those mails accordingly.
I exported the json result of this action and imported it in the IDE for this integration.
How can I iterate through each row from json result and fetch DeliveryLocation.
In the placeholder of the condition, check for DeliveryLocation and remediate particular emails in every row where DeliveryLocation=Inbox/folder.
Thanks,
Tejaswini