topic Re: Error with Dates when Adding Features with Python API in ArcGIS Online Questions

Error with Dates when Adding Features with Python API

mpboyle — Thu, 27 Feb 2025 18:41:48 GMT

I'm getting the errors shown in the first screenshot below when trying to add features to a hosted feature layer using the Python API.

The features throwing the error all seem to have dates at or prior to 1/1/1900.

When constructing the JSON for the features to add, I'm assigning our local time zone to the datetime object. Is there a different approach I should be taking to avoid these errors? The second screenshot shows a sample of the dictionary key and value being used when trying to add features.

If I set any dates at or prior to the year 1900 to NoneType objects, the features are written to the hosted feature layer without errors.

'DateField': datetime.datetime(1900, 1, 1, 12, 0, tzinfo=tzlocal())

Re: Error with Dates when Adding Features with Python API

CodyPatterson — Fri, 28 Feb 2025 12:09:50 GMT

Hey @mpboyle

Could try this function here to just return any date earlier than 1/1/1900 to None, as that's the normal null value in a DB for date columns:

from datetime import datetime def safe_datetime(date): return date if date >= datetime(1900, 1, 1) else None 'DateField': safe_datetime(datetime(1899, 12, 31))

In this case DateField will be None.

I think just setting to None will be one of the best bets here.

Cody

Re: Error with Dates when Adding Features with Python API

mpboyle — Fri, 28 Feb 2025 14:02:19 GMT

I'm already handling the dates if they're prior to 1900 (code below). I'm really wondering why I'm getting an error at all when trying to insert a feature with a date prior to 1900...are these dates not supported by the Python API?

def format_date(input_value): if isinstance(input_value, datetime.datetime): if input_value.year <= 1900: return None else: return input_value else: return None

Re: Error with Dates when Adding Features with Python API

JohnEvans6 — Tue, 04 Mar 2025 17:22:24 GMT

Came across this looking for something else doing something similar. I don't know if something that says "works on my machine" is helpful but everything seemed to upload for me doing the following:

Maybe there's something up with tzlocal() not producing a timezone object?