Answered

Merge 2 separate Filter array action output into one array

(0) Share

Report

Posted on by RADical

164

Is it possible to merge the output from the below filter actions into one array for additional filtering? I need to put the output of both into one array so I can remove duplicates returned in both actions.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

grantjenkins 11,063 Moderator on at

Like (2)

Report
You can add the output from each of your Filter arrays into a union expression to combine them.

union(body('Filter_DNAT_array_1'), body('Filter_DNAT_array_2'))

Was this reply helpful? Yes No
RADical 164 on at

Like (0)

Report
@grantjenkinsAs always, thanks for the swift response and great help.

That worked to combine the items into one, but for some reason it didn't get rid of the duplicates.

This was the output of the union:

[ { "Row_Ref": "4", "DNAT_RuleCollectionPriority": "\n600", "DNAT_RuleCollectionName": "\nnat", "DNAT_RuleName": "\nib-test-udp-75", "DNAT_Source": "\n*", "DNAT_Port": "\n75", "DNAT_Protocol": "\nUDP", "DNAT_Destination": "\nxx.xxx.xxx.59", "DNAT_TranslatedAddress": "\nxx.xxx.1.6", "DNAT_TranslatedPort": "\n75", "DNAT_Action": "\nDnat", "DNAT_DestinationFQDNs": "\n", "DNAT_DestinationIPGroups": "\n" }, { "Row_Ref": "4", "DNAT_RuleCollectionPriority": "\n600", "DNAT_RuleCollectionName": "\nnat", "DNAT_RuleName": "\nib-test-udp-75", "DNAT_Source": "\n*", "DNAT_Port": "\n75", "DNAT_Protocol": "\nUDP", "DNAT_Destination": "\nxx.xxx.xxx.59", "DNAT_TranslatedAddress": "\nxx.xxx.1.6", "DNAT_TranslatedPort": "\n75", "DNAT_Action": "\nDnat", "DNAT_DestinationFQDNs": "\n", "DNAT_DestinationIPGroups": "\n" }, { "Row_Ref": "15", "DNAT_RuleCollectionPriority": "\n100", "DNAT_RuleCollectionName": "\nnat", "DNAT_RuleName": "\nib-thisisatest-tcp-447", "DNAT_Source": "\n*", "DNAT_Port": "\n447", "DNAT_Protocol": "\nTCP", "DNAT_Destination": "\nxx.xxx.xxx.61", "DNAT_TranslatedAddress": "\nxx.xxx.x.9", "DNAT_TranslatedPort": "\n447", "DNAT_Action": "\nDnat", "DNAT_DestinationFQDNs": "\n", "DNAT_DestinationIPGroups": "\n" } ]

Is there any way to get rid of the duplicate item in the return format? As you can see the output has two inner blocks with the exact same data.

Was this reply helpful? Yes No
RADical 164 on at

Like (0)

Report

@grantjenkinsThanks for your help...I think it got me on the right path. Much appreciated!

Was this reply helpful? Yes No