Integromat | Formula to search for Name

Hello All
I have an integration with Integromat (that pulls NOAA Weather Zone Alerts).

When Integromat fires off a response… in the alert body an array is presented with zone or multiple zones:

"UGC": [
 "CAZ070",
 "CAZ071",
 ]

Now. Here is the issue:
I then want to search in my NWZ Zone table to get the record ID for each Zone

How do I make a formula to search through the array and iterate through the zone name Id’s?

Thanks

Josh

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.