Working on a service that sends an email to a list of users essentially giving them a list of permits in a specified area (Similar to the City of New Orleans 'NoticeMe' application).
We have a chunk of the work done, but our data is set up in a way that I can't get to work with GeoEvent email output -
basically it sends 1 email per email address/permit combination, whereas we'd like to roll up each permit into a single email per email address.
Here's an example of our data:
So the 2 email addresses here, as currently configured, get 3 emails each. Wondering if this can be handled in GeoEvent or if we need to work on 'flattening' the data for use in the GEV service - this would result in a really ugly and tricky to work with string field - can be done in python I'm fairly certain but figured I'd check the hive brain and see if this scenario has come up for anyone.
I'm experimenting with a field enricher where a table of email addresses joins to the permit data as seen above, but no luck yet.