Help

Integromat | Formula to search for Name

Topic Labels: Integrations
702 0
cancel
Showing results for 
Search instead for 
Did you mean: 
WildfireSnow
4 - Data Explorer
4 - Data Explorer

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 ZoneScreenshot 2021-11-08 083118

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

Screenshot 2021-11-08 084000

Thanks

Josh

0 Replies 0