nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sending email on feature service edit

joerodmey

I'm looking to have an email sent out each time my hosted feature service (on AGOL) has my status field altered. This status field is set to "not complete" by default, and as its completed it changes to "complete". When this happens I want an email sent out.

I've been playing around with webhooks and services likes Microsoft Flow and Integromat but not having too much success.

Any ideas?

Encontre mais publicações marcadas com

Accepted answers

dougbrowning

Ok I got it after some searching. GMAIL is much different.

Do this

change this line #server = smtplib.SMTP(emailSMTP)

to server = smtplib.SMTP_SSL(emailSMTP,465)

Remove the port number from the top so change emailSMTP = "smtp.gmail.com:587"

to just emailSMTP = "smtp.gmail.com"

Change this line #server.starttls()

to server.ehlo()

Add your username and pass to the lines

smtpusername = "you@gmail.com"
smtppassword = "pass"

Oh and the big one is go to https://myaccount.google.com/lesssecureapps?pli=1 then enable access!!

It now works.

All comments

XanderBakker

I assume that in the future "Webhooks" will be the way to do this, in a similar way as recently implemented with surveys in Survey123: Webhooks—Survey123 for ArcGIS | ArcGIS

jskinner

I added a feature and then ran the following:

<SPAN class="keyword token">import</SPAN> urllib2<SPAN class="punctuation token">,</SPAN> json<SPAN class="punctuation token">,</SPAN> urllib<SPAN class="punctuation token">,</SPAN> datetime<SPAN class="punctuation token">,</SPAN> time<SPAN class="punctuation token">,</SPAN> smtplib
<SPAN class="keyword token">from</SPAN> datetime <SPAN class="keyword token">import</SPAN> timedelta

<SPAN class="comment token"># Variables</SPAN>
username <SPAN class="operator token">=</SPAN> <SPAN class="string token">'test'</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># AGOL Username</SPAN>
password <SPAN class="operator token">=</SPAN> <SPAN class="string token">'test'</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># AGOL Password</SPAN>

URL <SPAN class="operator token">=</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fservices8.arcgis.com%2FXWI9YRo0bQGkCetU%2Farcgis%2Frest%2Fservices%2Fservice_e543c2e23b6d40a6b3cc03bba146dc6d%2FFeatureServer%2F0%2Fquery" target="_blank">https://services8.arcgis.com/XWI9YRo0bQGkCetU/arcgis/rest/services/service_e543c2e23b6d40a6b3cc03bba146dc6d/FeatureServer/0/query</A><SPAN>'</SPAN></SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Feature Service URL</SPAN>
uniqueID <SPAN class="operator token">=</SPAN> <SPAN class="string token">'objectid'</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># i.e. OBJECTID</SPAN>
dateField <SPAN class="operator token">=</SPAN> <SPAN class="string token">'EditDate'</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Date field to query</SPAN>
hoursValue <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Number of hours to check when a feature was added</SPAN>

fromEmail <SPAN class="operator token">=</SPAN> <SPAN class="string token"><A class="jive-link-email-small" href="mailto:'test@esri.com" rel="nofollow noopener noreferrer" target="_blank">'test@esri.com</A><SPAN>'</SPAN></SPAN> <SPAN class="comment token"># Email sender</SPAN>
toEmail <SPAN class="operator token">=</SPAN> <SPAN class="string token"><A class="jive-link-email-small" href="mailto:'test@esri.com" rel="nofollow noopener noreferrer" target="_blank">'test@esri.com</A><SPAN>'</SPAN></SPAN>&nbsp;&nbsp; <SPAN class="comment token"># Email receiver</SPAN>
smtpServer <SPAN class="operator token">=</SPAN> <SPAN class="string token">'smtp.test.com'</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># SMPT Server Name</SPAN>
portNumber <SPAN class="operator token">=</SPAN> <SPAN class="number token">25</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># SMTP Server port</SPAN>

<SPAN class="comment token"># Create empty list for uniqueIDs</SPAN>
oidList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Generate AGOL token</SPAN>
<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Generating Token'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; tokenURL <SPAN class="operator token">=</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fwww.arcgis.com%2Fsharing%2Frest%2FgenerateToken" target="_blank">https://www.arcgis.com/sharing/rest/generateToken</A><SPAN>'</SPAN></SPAN>
&nbsp;&nbsp;&nbsp; params <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'f'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'pjson'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'username'</SPAN><SPAN class="punctuation token">:</SPAN> username<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> password<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'referer'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fwww.arcgis.com" target="_blank">http://www.arcgis.com</A><SPAN>'</SPAN></SPAN><SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp; req <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>Request<SPAN class="punctuation token">(</SPAN>tokenURL<SPAN class="punctuation token">,</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN>params<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; response <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>urlopen<SPAN class="punctuation token">(</SPAN>req<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; data <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>response<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; token <SPAN class="operator token">=</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'token'</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; token <SPAN class="operator token">=</SPAN> <SPAN class="string token">''</SPAN>

<SPAN class="comment token"># Query service and check if created_date time is within the last hour</SPAN>
params <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'f'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'pjson'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'where'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"1=1"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'outfields'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'{0}, {1}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>uniqueID<SPAN class="punctuation token">,</SPAN> dateField<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'returnGeometry'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'false'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'token'</SPAN> <SPAN class="punctuation token">:</SPAN> token<SPAN class="punctuation token">}</SPAN>
req <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>Request<SPAN class="punctuation token">(</SPAN>URL<SPAN class="punctuation token">,</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN>params<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
response <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>urlopen<SPAN class="punctuation token">(</SPAN>req<SPAN class="punctuation token">)</SPAN>
data <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>response<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> feat <SPAN class="keyword token">in</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'features'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; createDate <SPAN class="operator token">=</SPAN> feat<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>dateField<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; createDate <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>createDate<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; t <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>now<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> timedelta<SPAN class="punctuation token">(</SPAN>hours<SPAN class="operator token">=</SPAN>hoursValue<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; t <SPAN class="operator token">=</SPAN> time<SPAN class="punctuation token">.</SPAN>mktime<SPAN class="punctuation token">(</SPAN>t<SPAN class="punctuation token">.</SPAN>timetuple<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> createDate <SPAN class="operator token">></SPAN> t<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; oidList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>feat<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>uniqueID<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>oidList<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Email Info</SPAN>
FROM <SPAN class="operator token">=</SPAN> fromEmail
TO <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>toEmail<SPAN class="punctuation token">]</SPAN>
SUBJECT <SPAN class="operator token">=</SPAN> <SPAN class="string token">'New Features Added'</SPAN>
TEXT <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Features with {0}s {1} were added."</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>uniqueID<SPAN class="punctuation token">,</SPAN> oidList<SPAN class="punctuation token">)</SPAN>

message <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""\
From: %s
To: %s
Subject: %s

%s
"""</SPAN> <SPAN class="operator token">%</SPAN> <SPAN class="punctuation token">(</SPAN>FROM<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">", "</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>TO<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> SUBJECT<SPAN class="punctuation token">,</SPAN> TEXT<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># If new features exist, send email</SPAN>
<SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>oidList<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; smtpObj <SPAN class="operator token">=</SPAN> smtplib<SPAN class="punctuation token">.</SPAN>SMTP<SPAN class="punctuation token">(</SPAN>host<SPAN class="operator token">=</SPAN>smtpServer<SPAN class="punctuation token">,</SPAN> port<SPAN class="operator token">=</SPAN>portNumber<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; smtpObj<SPAN class="punctuation token">.</SPAN>sendmail<SPAN class="punctuation token">(</SPAN>FROM<SPAN class="punctuation token">,</SPAN> TO<SPAN class="punctuation token">,</SPAN> message<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Successfully sent email"</SPAN>
&nbsp;&nbsp;&nbsp; smtpObj<SPAN class="punctuation token">.</SPAN>quit<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I then received an e-mail:

Features with objectids [1034] were added.

joerodmey

No luck Jake

jskinner

Try changing your fields to the following:

uniqueID <SPAN class="">=</SPAN> <SPAN class="">'objectid'</SPAN>
dateField <SPAN class="">=</SPAN> <SPAN class="">'EditDate'</SPAN>

Anonymous User

You can also add your support and use case to this idea:

https://community.esri.com/ideas/10344

joerodmey

Sent invite

jskinner

Can you share the service to a Group and invite my user account (jskinner_CountySandbox)? I can take a look.

joerodmey

Error picture attached to my previous reply.

Updated code (with a few omissions):

</CODE></PRE><PRE class="lia-code-sample line-numbers language-none"><CODE><SPAN class="keyword token">import</SPAN> urllib2<SPAN class="punctuation token">,</SPAN> json<SPAN class="punctuation token">,</SPAN> urllib<SPAN class="punctuation token">,</SPAN> datetime<SPAN class="punctuation token">,</SPAN> time<SPAN class="punctuation token">,</SPAN> smtplib
<SPAN class="keyword token">from</SPAN> datetime <SPAN class="keyword token">import</SPAN> timedelta

<SPAN class="comment token"># Variables</SPAN>
username <SPAN class="operator token">=</SPAN> <SPAN class="string token">'OMIT'</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># AGOL Username</SPAN>
password <SPAN class="operator token">=</SPAN> <SPAN class="string token">'OMIT'</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># AGOL Password</SPAN>

URL <SPAN class="operator token">=</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fservices8.arcgis.com%2FXWI9YRo0bQGkCetU%2Farcgis%2Frest%2Fservices%2Fservice_OMIT6b3cc03bba146dc6d%2FFeatureServer%2F0%3Ftoken%3D_S4wrFEfVufazfz-WrYOMITkfEYttuqysvDW4vGTYmSB-U2llBo-jmho_VuL_mJHxZ0tozqggUjYruB4yrwNURIYIQx6GEyzqFkje5x71sKeRbOMITQQXhuDX3gGKjkdk5sBzDFe_EMv4YSNdWE_GQVVmWtZgnhtv27_wnOJ98pppE24KNi5ls68nRgqyrrp3EsEd_JzKgQk_XusMUAiFjeyjI73cNLyJpKwtvhH3ExSnlPMav9cCf0-lV9iobuGn_Tw" target="_blank">https://services8.arcgis.com/XWI9YRo0bQGkCetU/arcgis/rest/services/service_OMIT6b3cc03bba146dc6d/FeatureServer/0?token=_S4wrFEfVufazfz-WrYOMITkfEYttuqysvDW4vGTYmSB-U2llBo-jmho_VuL_mJHxZ0tozqggUjYruB4yrwNURIYIQx6GEyzqFkje5x71sKeRbOMITQQXhuDX3gGKjkdk5sBzDFe_EMv4YSNdWE_GQVVmWtZgnhtv27_wnOJ98pppE24KNi5ls68nRgqyrrp3EsEd_JzKgQk_XusMUAiFjeyjI73cNLyJpKwtvhH3ExSnlPMav9cCf0-lV9iobuGn_Tw</A><SPAN>..'</SPAN></SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Feature Service URL</SPAN>
uniqueID <SPAN class="operator token">=</SPAN> <SPAN class="string token">'OBJECTID'</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># i.e. OBJECTID</SPAN>
dateField <SPAN class="operator token">=</SPAN> <SPAN class="string token">'created_date'</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Date field to query</SPAN>
hoursValue <SPAN class="operator token">=</SPAN> <SPAN class="number token">1</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Number of hours to check when a feature was added</SPAN>

fromEmail <SPAN class="operator token">=</SPAN> <SPAN class="string token">'OMIT'</SPAN> <SPAN class="comment token"># Email sender</SPAN>
toEmail <SPAN class="operator token">=</SPAN> <SPAN class="string token">'OMIT'</SPAN>&nbsp;&nbsp; <SPAN class="comment token"># Email receiver</SPAN>
smtpServer <SPAN class="operator token">=</SPAN> <SPAN class="string token">'OMIT'</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># SMPT Server Name</SPAN>
portNumber <SPAN class="operator token">=</SPAN> <SPAN class="number token">25</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># SMTP Server port</SPAN>

<SPAN class="comment token"># Create empty list for uniqueIDs</SPAN>
oidList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Generate AGOL token</SPAN>
<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Generating Token'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; tokenURL <SPAN class="operator token">=</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fwww.arcgis.com%2Fsharing%2Frest%2FgenerateToken" target="_blank">https://www.arcgis.com/sharing/rest/generateToken</A><SPAN>'</SPAN></SPAN>
&nbsp;&nbsp;&nbsp; params <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'f'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'pjson'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'username'</SPAN><SPAN class="punctuation token">:</SPAN> username<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">:</SPAN> password<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'referer'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token"><SPAN>'</SPAN><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=http%3A%2F%2Fwww.arcgis.com" target="_blank">http://www.arcgis.com</A><SPAN>'</SPAN></SPAN><SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp; req <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>Request<SPAN class="punctuation token">(</SPAN>tokenURL<SPAN class="punctuation token">,</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN>params<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; response <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>urlopen<SPAN class="punctuation token">(</SPAN>req<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; data <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>response<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; token <SPAN class="operator token">=</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'token'</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; token <SPAN class="operator token">=</SPAN> <SPAN class="string token">''</SPAN>

<SPAN class="comment token"># Query service and check if created_date time is within the last hour</SPAN>
params <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'f'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'pjson'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'where'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"1=1"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'outfields'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'{0}, {1}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>uniqueID<SPAN class="punctuation token">,</SPAN> dateField<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'returnGeometry'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'false'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'token'</SPAN> <SPAN class="punctuation token">:</SPAN> token<SPAN class="punctuation token">}</SPAN>
req <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>Request<SPAN class="punctuation token">(</SPAN>URL<SPAN class="punctuation token">,</SPAN> urllib<SPAN class="punctuation token">.</SPAN>urlencode<SPAN class="punctuation token">(</SPAN>params<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
response <SPAN class="operator token">=</SPAN> urllib2<SPAN class="punctuation token">.</SPAN>urlopen<SPAN class="punctuation token">(</SPAN>req<SPAN class="punctuation token">)</SPAN>
data <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>load<SPAN class="punctuation token">(</SPAN>response<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> feat <SPAN class="keyword token">in</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'features'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; createDate <SPAN class="operator token">=</SPAN> feat<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>dateField<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; createDate <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>createDate<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; t <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>now<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> timedelta<SPAN class="punctuation token">(</SPAN>hours<SPAN class="operator token">=</SPAN>hoursValue<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; t <SPAN class="operator token">=</SPAN> time<SPAN class="punctuation token">.</SPAN>mktime<SPAN class="punctuation token">(</SPAN>t<SPAN class="punctuation token">.</SPAN>timetuple<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> createDate <SPAN class="operator token">></SPAN> t<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; oidList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>feat<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>uniqueID<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>oidList<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># Email Info</SPAN>
FROM <SPAN class="operator token">=</SPAN> fromEmail
TO <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>toEmail<SPAN class="punctuation token">]</SPAN>
SUBJECT <SPAN class="operator token">=</SPAN> <SPAN class="string token">'New Features Added'</SPAN>
TEXT <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Features with {0}s {1} were added."</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>uniqueID<SPAN class="punctuation token">,</SPAN> oidList<SPAN class="punctuation token">)</SPAN>

message <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""\
From: %s
To: %s
Subject: %s

%s
"""</SPAN> <SPAN class="operator token">%</SPAN> <SPAN class="punctuation token">(</SPAN>FROM<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">", "</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>TO<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> SUBJECT<SPAN class="punctuation token">,</SPAN> TEXT<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># If new features exist, send email</SPAN>
<SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>oidList<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; smtpObj <SPAN class="operator token">=</SPAN> smtplib<SPAN class="punctuation token">.</SPAN>SMTP<SPAN class="punctuation token">(</SPAN>host<SPAN class="operator token">=</SPAN>smtpServer<SPAN class="punctuation token">,</SPAN> port<SPAN class="operator token">=</SPAN>portNumber<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; smtpObj<SPAN class="punctuation token">.</SPAN>sendmail<SPAN class="punctuation token">(</SPAN>FROM<SPAN class="punctuation token">,</SPAN> TO<SPAN class="punctuation token">,</SPAN> message<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Successfully sent email"</SPAN>
&nbsp;&nbsp;&nbsp; smtpObj<SPAN class="punctuation token">.</SPAN>quit<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

jskinner

You didn't attach the error you are receiving. Can you also post your updated code?

joerodmey

Hi Jake,

Played around with it a bit but keep getting this error:

Capture.JPG

jskinner

Hey Joe,

Take a look at the following document:

https://community.esri.com/docs/DOC-10163-send-email-when-a-feature-is-added-to-a-arcgis-online-hosted-feature-service

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.