Geoevent send an Email - loop through events?

AllenScully — Mon, 08 Jan 2018 22:43:35 GMT

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_NUMBER	EMAIL
1	A-1234	user1@email.com
2	A-1235	user1@email.com
3	A-1236	user1@email.com
4	A-1237	user2@fakemail.biz
5	A-1238	user2@fakemail.biz
6	A-1239	user2@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

topic Geoevent send an Email - loop through events? in ArcGIS GeoEvent Server Questions

Geoevent send an Email - loop through events?