topic Re: Sending email on feature service edit in ArcGIS Online Questions

Sending email on feature service edit

joerodmey — Tue, 17 Jul 2018 13:55:20 GMT

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?

Re: Sending email on feature service edit

JakeSkinner — Tue, 17 Jul 2018 14:42:42 GMT

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

Re: Sending email on feature service edit

joerodmey — Tue, 17 Jul 2018 15:24:22 GMT

Hi Jake,

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

Re: Sending email on feature service edit

JakeSkinner — Tue, 17 Jul 2018 15:35:46 GMT

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

Re: Sending email on feature service edit

joerodmey — Sat, 11 Dec 2021 15:16:52 GMT

Error picture attached to my previous reply.

Updated code (with a few omissions):

import urllib2, json, urllib, datetime, time, smtplib
from datetime import timedelta

# Variables
username = 'OMIT'        # AGOL Username
password = 'OMIT'    # AGOL Password

URL = '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..'       # Feature Service URL
uniqueID = 'OBJECTID'           # i.e. OBJECTID
dateField = 'created_date'      # Date field to query
hoursValue = 1                  # Number of hours to check when a feature was added

fromEmail = 'OMIT' # Email sender
toEmail = 'OMIT'   # Email receiver
smtpServer = 'OMIT'    # SMPT Server Name
portNumber = 25                 # SMTP Server port

# Create empty list for uniqueIDs
oidList = []

# Generate AGOL token
try:
    print('Generating Token')
    tokenURL = 'https://www.arcgis.com/sharing/rest/generateToken'
    params = {'f': 'pjson', 'username': username, 'password': password, 'referer': 'http://www.arcgis.com'}
    req = urllib2.Request(tokenURL, urllib.urlencode(params))
    response = urllib2.urlopen(req)
    data = json.load(response)
    token = data['token']
except:
    token = ''

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

print(oidList)

# Email Info
FROM = fromEmail
TO = [toEmail]
SUBJECT = 'New Features Added'
TEXT = "Features with {0}s {1} were added.".format(uniqueID, oidList)

message = """\
From: %s
To: %s
Subject: %s

%s
""" % (FROM, ", ".join(TO), SUBJECT, TEXT)

# If new features exist, send email
if len(oidList) > 0:
    smtpObj = smtplib.SMTP(host=smtpServer, port=portNumber)
    smtpObj.sendmail(FROM, TO, message)
    print "Successfully sent email"
    smtpObj.quit()

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Sending email on feature service edit

JakeSkinner — Tue, 17 Jul 2018 16:54:45 GMT

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

Re: Sending email on feature service edit

joerodmey — Tue, 17 Jul 2018 16:59:17 GMT

Sent invite

Re: Sending email on feature service edit

Anonymous User — Tue, 22 Jun 2021 08:29:38 GMT

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

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

Re: Sending email on feature service edit

JakeSkinner — Sat, 11 Dec 2021 15:16:55 GMT

Try changing your fields to the following:

uniqueID = 'objectid'
dateField = 'EditDate'

Re: Sending email on feature service edit

joerodmey — Tue, 17 Jul 2018 17:32:04 GMT

No luck Jake

Re: Sending email on feature service edit

JakeSkinner — Sat, 11 Dec 2021 15:16:57 GMT

I added a feature and then ran the following:

import urllib2, json, urllib, datetime, time, smtplib
from datetime import timedelta

# Variables
username = 'test'        # AGOL Username
password = 'test'    # AGOL Password

URL = 'https://services8.arcgis.com/XWI9YRo0bQGkCetU/arcgis/rest/services/service_e543c2e23b6d40a6b3cc03bba146dc6d/FeatureServer/0/query'       # Feature Service URL
uniqueID = 'objectid'           # i.e. OBJECTID
dateField = 'EditDate'      # Date field to query
hoursValue = 1                  # Number of hours to check when a feature was added

fromEmail = 'test@esri.com' # Email sender
toEmail = 'test@esri.com'   # Email receiver
smtpServer = 'smtp.test.com'    # SMPT Server Name
portNumber = 25                 # SMTP Server port

# Create empty list for uniqueIDs
oidList = []

# Generate AGOL token
try:
    print('Generating Token')
    tokenURL = 'https://www.arcgis.com/sharing/rest/generateToken'
    params = {'f': 'pjson', 'username': username, 'password': password, 'referer': 'http://www.arcgis.com'}
    req = urllib2.Request(tokenURL, urllib.urlencode(params))
    response = urllib2.urlopen(req)
    data = json.load(response)
    token = data['token']
except:
    token = ''

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

print(oidList)

# Email Info
FROM = fromEmail
TO = [toEmail]
SUBJECT = 'New Features Added'
TEXT = "Features with {0}s {1} were added.".format(uniqueID, oidList)

message = """\
From: %s
To: %s
Subject: %s

%s
""" % (FROM, ", ".join(TO), SUBJECT, TEXT)

# If new features exist, send email
if len(oidList) > 0:
    smtpObj = smtplib.SMTP(host=smtpServer, port=portNumber)
    smtpObj.sendmail(FROM, TO, message)
    print "Successfully sent email"
    smtpObj.quit()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I then received an e-mail:

Features with objectids [1034] were added.

Re: Sending email on feature service edit

joerodmey — Tue, 17 Jul 2018 18:48:54 GMT

Get further. Able to see that feature 1034 was added. Get error when trying to send email via gmail:

Generating Token
[1034]

Traceback (most recent call last):
File "H:/Custom_WebApp_Code/Send_Email.py", line 64, in <module>
    smtpObj = smtplib.SMTP(host=smtpServer, port=portNumber)
File "C:\Python27\ArcGIS10.6\lib\smtplib.py", line 256, in __init__
    (code, msg) = self.connect(host, port)
File "C:\Python27\ArcGIS10.6\lib\smtplib.py", line 318, in connect
    (code, msg) = self.getreply()
File "C:\Python27\ArcGIS10.6\lib\smtplib.py", line 369, in getreply
    raise SMTPServerDisconnected("Connection unexpectedly closed")
SMTPServerDisconnected: Connection unexpectedly closed

Re: Sending email on feature service edit

JakeSkinner — Wed, 18 Jul 2018 12:38:23 GMT

This issue appears to be with GMAIL's SMTP server. I haven't had much luck using GMAIL. Are you able to use your Organizations SMTP?

Re: Sending email on feature service edit

joerodmey — Wed, 18 Jul 2018 19:10:07 GMT

Don't think I'll be able to get my hands on the email server details

Re: Sending email on feature service edit

DougBrowning — Wed, 18 Jul 2018 19:46:07 GMT

Looks like your code is assuming port 25 but gmail usese a different port. First hit on google so it may be old.

Gmail Free SMTP Server Information

You can use Gmail’s SMTP server information in a number of different places. You can use this in your local email client like Microsoft Outlook or within your WordPress site with a plugin like Gmail SMTP or SendGrid. Check out our tutorial on how to send emails from within WordPress.

Outgoing Mail (SMTP) Server: smtp.gmail.com
Use Authentication: Yes
Use Secure Connection: Yes (this can be TLS or SSL depending on your mail client)
Username: GMail account (email@gmail.com)
Password: GMail password
Port: 465 or 587

Re: Sending email on feature service edit

joerodmey — Wed, 18 Jul 2018 20:11:41 GMT

Still nothing

Re: Sending email on feature service edit

DougBrowning — Sat, 11 Dec 2021 15:17:00 GMT

Your email code looks different than mine. This one worked for years for me.

'''-------------------------------------------------------------------------------
Name:       How to Send Email with Attachment.py


HTML and Attachemnt are turned off in this sample
-------------------------------------------------------------------------------'''

import arcpy
import smtplib
import mimetypes
from email.mime.multipart import MIMEMultipart
from email import encoders
from email.message import Message
from email.mime.audio import MIMEAudio
from email.mime.base import MIMEBase
from email.mime.image import MIMEImage
from email.mime.text import MIMEText

# May work
#emailSMTP = "smtp.gmail.com:587"
# Will work
emailSMTP = "yoursmtp.com"
smtpusername = "username@onmicrosoft.com"
smtppassword = "pass"


# Set To and From
emailfrom = "username@something.com"
# Weird but the msg["To"] must be a string but the call to the smtp server must be a list see line 71.  not easy to figrue out
# List can be a single text also but easier to just always be a list so that split code works
# This is who it will send to.  Always make this a list so that the split and join below work
emailRecList = ["someone@yahoo.com","someotherguy@test.com"]      # or  emailRecList = ["justoneguy@test.com"]
# this is a text list it needs for the to
emailto = ','.join(emailRecList)

# give a path to a file or set a flag by setting = no
#fileToSend = r"c:\temp\temp.pdf"
fileToSend = "no"

msg = MIMEMultipart()
msg["From"] = emailfrom
msg["To"] = emailto
# Can set any Subject here
msg["Subject"] = "Form Attached"
# No Idea where this goes
msg.preamble = "Where is this"

# For text - plain or HTML
# Plain Sample
text = "Hi!\nHow are you?\nHere is the text you wanted."

# HTML sample
html = """\
<html>
  <head></head>
  <body>
    <p>Hi!<br>
       How are you?<br>
       Here is the <a href="https://www.python.org">link</a> you wanted.
    </p>
  </body>
</html>
"""


part1 = MIMEText(text, 'plain')
part2 = MIMEText(html, 'html')
msg.attach(part1)
# Uncomment out to send HTML
#msg.attach(part2)

# For attachement
if fileToSend != "no":
    ctype, encoding = mimetypes.guess_type(fileToSend)
    if ctype is None or encoding is not None:
        ctype = "application/octet-stream"
    maintype, subtype = ctype.split("/", 1)
    fp = open(fileToSend, "rb")
    attachment = MIMEBase(maintype, subtype)
    attachment.set_payload(fp.read())
    fp.close()
    encoders.encode_base64(attachment)
    attachment.add_header("Content-Disposition", "attachment", filename=fileToSend)
    msg.attach(attachment)

# Send section
server = smtplib.SMTP(emailSMTP)
server.starttls()
server.login(smtpusername,smtppassword)   # password not needed for me but you may
# Weird but the msg["To"] must be a string but the call to the smtp server must be a list
server.sendmail(emailfrom, emailRecList, msg.as_string())
server.quit()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Sending email on feature service edit

joerodmey — Thu, 19 Jul 2018 13:51:16 GMT

Got some errors (attached)

Re: Sending email on feature service edit

DougBrowning — Thu, 19 Jul 2018 14:04:27 GMT

This looks like it is failing on import arcpy? Is this running on a machine with arc installed? Are you maybe trying to run it on a server? What are you running scripts in? Just Idle or command line? Get PyScripter i you can. Then just do a import arcpy to see if that works. Your python may not be setup correctly.

Sorry not sure how familiar you are with python but this seems to show it is not even trying the script. Does a 1 line script with just import arcpy in it work?

Re: Sending email on feature service edit

DougBrowning — Thu, 19 Jul 2018 14:13:31 GMT

Wait looking at your script you don't use any arcpy stuff so you can just get rid of the import arcpy line.