Hi James
Yes it is. I am using a script originally posted by John Stowell in 2019, which I have amended to loop through a set of queries and output to different local folders.
The relevant part of the code is below. As I said, it works fine of there is one record returned by the "where_filter". If more than one is returned, the reports are generated into a zip file, but not downloaded. Having just pasted the code below, I am wondering whether it is because the zip file is not found by survey.reports? However, until recently the whole thing was working, and was downloading doc files regardless of how many there were.
Thanks
Simon
interval = today-datetime.timedelta(seconds = 3600)
reportCount = 0
# Try/except/finally block to workaround the KeyError: 'results' bug in the generate_report method
# SJG: Think this bug has been fixed, but have left try/except in just in case
try:
print('Generating report(s) for submissions from last hour', file=open(log, "a"))
print('')
survey.generate_report(template, where_filter, utc_offset, report_title)
except Exception as e:
print('>> ERROR: KeyError: ',e,' (related to ESRI BUG-000119057)', file=open(log, "a"))
print('>> Continuing...', file=open(log, "a"))
print('')
pass
finally:
print('Downloading relevant report(s) to: ',output_folder, file=open(log, "a"))
print('')
for x in survey.reports:
# Find the creation date (Unix epoch) and convert to local time
creationdate = datetime.datetime.fromtimestamp(x.created / 1e3)
# Only find and download AGOL reports created in the last half hour (specified in "interval" variable)
if (creationdate > interval):
reportCount += 1
id = x.id # Get ID of each Word doc AGOL item
print('Report number: ', reportCount, file=open(log, "a"))
data_item = agol_login.content.get(id)
data_item.download(save_path = output_folder) # Download each Word doc to specified location
time.sleep(15)
data_item.delete() # Delete the item in AGOL folder after download
# Finally block end
