is not JSON serializable

It’s worth noting that the QuerySet.values_list() method doesn’t actually return a list, but an object of type django.db.models.query.ValuesListQuerySet, in order to maintain Django’s goal of lazy evaluation, i.e. the DB query required to generate the ‘list’ isn’t actually performed until the object is evaluated.

Somewhat irritatingly, though, this object has a custom __repr__ method which makes it look like a list when printed out, so it’s not always obvious that the object isn’t really a list.

The exception in the question is caused by the fact that custom objects cannot be serialized in JSON, so you’ll have to convert it to a list first, with…

my_list = list(self.get_queryset().values_list('code', flat=True))

…then you can convert it to JSON with…

json_data = json.dumps(my_list)

You’ll also have to place the resulting JSON data in an HttpResponse object, which, apparently, should have a Content-Type of application/json, with…

response = HttpResponse(json_data, content_type='application/json')

…which you can then return from your function.

Related Posts:

  1. NumPy array is not JSON serializable
  2. Why am I seeing “TypeError: string indices must be integers”?
  3. How to prettyprint a JSON file?
  4. pandas read_json: “If using all scalar values, you must pass an index”
  5. JSONDecodeError: Expecting value: line 1 column 1 (char 0)
  6. Converting dictionary to JSON
  7. JSONDecodeError: Expecting value: line 1 column 1 (char 0)
  8. JSONDecodeError: Expecting value: line 1 column 1 (char 0)
  9. How to parse data in JSON format?
  10. Where does pip install its packages?
  11. django: TypeError: ‘tuple’ object is not callable
  12. json.dumps vs flask.jsonify
  13. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  14. Can’t fix “zipimport.ZipImportError: can’t decompress data; zlib not available” when I type in “python3.6 get-pip.py”
  15. TypeError: unhashable type: ‘dict’, when dict used as a key for another dict
  16. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  17. No module named MySQLdb
  18. How to check Django version
  19. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  20. How to make a class JSON serializable
  21. Convert a python dict to a string and back
  22. TypeError: Object of type ‘bytes’ is not JSON serializable
  23. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  24. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  25. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  26. No module named pkg_resources
  27. Django upgrading to 1.9 error “AppRegistryNotReady: Apps aren’t loaded yet.”
  28. Python ValueError: No JSON object could be decoded
  29. How to POST JSON data with Python Requests?
  30. Python error load JSON code of google API
  31. Can’t compare naive and aware datetime.now() <= challenge.datetime_end
  32. Return JSON response from Flask view
  33. How to overcome “datetime.datetime not JSON serializable”?
  34. Python/Json:Expecting property name enclosed in double quotes
  35. django import error – No module named core.management
  36. Forbidden (403) CSRF verification failed. Request aborted. Even using the {% csrf_token %}
  37. Displaying better error message than “No JSON object could be decoded”
  38. JSON to pandas DataFrame
  39. Django 2.1.3 Error: __init__() takes 1 positional argument but 2 were given
  40. Setting Django up to use MySQL
  41. Python error load JSON code of google API
  42. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  43. Displaying better error message than “No JSON object could be decoded”
  44. OSError – Errno 13 Permission denied
  45. Displaying better error message than “No JSON object could be decoded”
  46. Pylint “unresolved import” error in Visual Studio Code
  47. Converting XML to JSON using Python?
  48. Django – no such table exception
  49. django MultiValueDictKeyError error, how do I deal with it
  50. Django – no such table exception
  51. Is there a list of Pytz Timezones?
  52. How to get JSON from webpage into Python script
  53. Django – “no module named django.core.management”
  54. Loading a file with more than one line of JSON into Pandas
  55. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  56. What is the difference between json.load() and json.loads() functions
  57. How to convert an XML string to a dictionary?
  58. You are trying to add a non-nullable field ‘new_field’ to userprofile without a default
  59. pip install -r requirements.txt [Errno 2] No such file or directory: ‘requirements.txt’
  60. ValueError: Expected object or value when reading json as pandas dataframe
  61. super(type, obj): obj must be an instance or subtype of type
  62. Django Rest Framework — no module named rest_framework
  63. Error: “dictionary update sequence element #0 has length 1; 2 is required” on Django 1.4
  64. Python Django: You’re using the staticfiles app without having set the STATIC_ROOT setting
  65. sqlite3.OperationalError: unable to open database file
  66. TypeError: int() argument must be a string, a bytes-like object or a number, not ‘list’
  67. ImportError: No module named ‘django.core.urlresolvers’
  68. How to fix error “ERROR: Command errored out with exit status 1: python.” when trying to install django-heroku using pip
  69. How to set environment variables in PyCharm?
  70. H14 error in heroku – “no web processes running”
  71. What does this Django regular expression mean? `?P`
  72. how to read json object in python
  73. JSON object must be str, bytes or bytearray, not dict
  74. OperationalError: database is locked
  75. Is it better to use path() or url() in urls.py for django 2.0?
  76. How to prettyprint a JSON file?
  77. What is a “slug” in Django?
  78. TemplateDoesNotExist at /
  79. TypeError: expected str, bytes or os.PathLike object, not _io.TextIOWrapper
  80. What is the easiest way to clear a database from the CLI with manage.py in Django?
  81. What does on_delete do on Django models?
  82. Check if an object exists
  83. Find object in list that has attribute equal to some value (that meets any condition)
  84. How to check if a user is logged in (how to properly use user.is_authenticated)?
  85. The view didn’t return an HttpResponse object. It returned None instead
  86. CSV new-line character seen in unquoted field error
  87. gunicorn.errors.HaltServer: django
  88. set object is not JSON serializable
  89. coercing to Unicode: need string or buffer, NoneType found when rendering in django admin
  90. dump() missing 1 required positional argument: ‘fp’ in python json
  91. coercing to Unicode: need string or buffer, NoneType found when rendering in django admin
  92. How to query as GROUP BY in django?
  93. TypeError: the JSON object must be str, not ‘bytes’
  94. Error loading MySQLdb module: No module named ‘MySQLdb’
  95. What is related_name used for?
  96. TypeError: ManyRelatedManager object is not iterable
  97. How to get POSTed JSON in Flask?
  98. What is the most efficient way to store a list in the Django models?
  99. Line is too long. Django PEP8
  100. __init__() got an unexpected keyword argument ‘user’

Leave a Comment