How to convert to a Python datetime object with JSON.loads?

by

My solution so far:

>>> json_string = '{"last_updated": {"$gte": "Thu, 1 Mar 2012 10:00:49 UTC"}}'
>>> dct = json.loads(json_string, object_hook=datetime_parser)
>>> dct
{u'last_updated': {u'$gte': datetime.datetime(2012, 3, 1, 10, 0, 49)}}


def datetime_parser(dct):
    for k, v in dct.items():
        if isinstance(v, basestring) and re.search("\ UTC", v):
            try:
                dct[k] = datetime.datetime.strptime(v, DATE_FORMAT)
            except:
                pass
    return dct

For further reference on the use of object_hook: JSON encoder and decoder

In my case the json string is coming from a GET request to my REST API. This solution allows me to ‘get the date right’ transparently, without forcing clients and users into hardcoding prefixes like __date__ into the JSON, as long as the input string conforms to DATE_FORMAT which is:

DATE_FORMAT = '%a, %d %b %Y %H:%M:%S UTC'

The regex pattern should probably be further refined

PS: in case you are wondering, the json_string is a MongoDB/PyMongo query.

More Related Contents:

  1. Keep a datetime.date in ‘yyyy-mm-dd’ format when using Flask’s jsonify
  2. How to read a single object from a json file containing multiple objects using python? [closed]
  3. Split / Explode a column of dictionaries into separate columns with pandas
  4. Converting between datetime, Timestamp and datetime64
  5. How to get string objects instead of Unicode from JSON?
  6. How to JSON serialize sets?
  7. How to construct a timedelta object from a simple string
  8. Combine Date and Time columns using python pandas
  9. json.dumps vs flask.jsonify
  10. Parsing date with timezone from an email?
  11. How to increment datetime by custom months in python without using library [duplicate]
  12. Find the closest date to a given date
  13. Python read JSON file and modify
  14. Datetime Timezone conversion using pytz
  15. How to get current time in python and break up into year, month, day, hour, minute?
  16. flattening nested Json in pandas data frame
  17. Pythonic difference between two dates in years?
  18. Get the Olson TZ name for the local timezone?
  19. Saving UTF-8 texts with json.dumps as UTF-8, not as a \u escape sequence
  20. Plotting dates on the x-axis
  21. How to parse somewhat wrong JSON with Python?
  22. Convert numpy type to python
  23. How to customise error response in FastAPI?
  24. Accessing dictionary by key in Django template
  25. Python pandas integer YYYYMMDD to datetime
  26. How can I serialize a numpy array while preserving matrix dimensions?
  27. Why does “%-d”, or “%-e” remove the leading space or zero?
  28. Python: Matplotlib avoid plotting gaps
  29. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  30. urllib2 and json

Leave a Comment