AnsweredAssumed Answered

Geoevent send an Email - loop through events?

Question asked by ascullyCOT on Jan 8, 2018

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:

OBJECTID PERMIT_NUMBEREMAIL
1A-1234user1@email.com
2A-1235user1@email.com
3A-1236user1@email.com
4A-1237user2@fakemail.biz
5A-1238user2@fakemail.biz
6A-1239user2@fakemail.biz

 

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.

 

Thanks - 

Allen

Outcomes