How do I return single object with JSON in Python with Flask

Question

I have the below code which is trying to return an object back to JSON. I'm trying to return back the MenuItem object to the caller

#Make JSON API
@app.route('/restaurant/<int:restaurant_id>/menu/<int:menu_id>/JSON')
def restaurantMenuJSONONE(restaurant_id,menu_id):
    item = session.query(MenuItem).filter_by(id = menu_id).one()
    return jsonify(MenuItems=item)

Error I'm getting:

TypeError: <database_setup.MenuItem object at 0xb6071d8c> is not JSON serializable

database_setup.py snips

class MenuItem(Base):
    __tablename__ = 'menu_item'

    name = Column(String(80), nullable=False)
    id = Column(Integer, primary_key=True)
    description = Column(String(250))
    price = Column(String(8))
    course = Column(String(250))
    restaurant_id = Column(Integer, ForeignKey('restaurant.id'))
    restaurant = relationship(Restaurant)

#JSON
    @property
    def serialize(self):
        #return object
        return {
            'name' : self.name,
            'description' : self.description,
            'id' : self.id,
            'price' : self.price,
            'course' : self.course,
        }

import json and return data before using json.dumps()

Kir Chou
– Kir Chou

2016-04-03 04:37:06 +00:00
Commented Apr 3, 2016 at 4:37 — Kir Chou
– Kir Chou, Commented Apr 3, 2016 at 4:37

Tikkaty · Accepted Answer · 2016-04-03 11:30:03Z

2

Solved it with:

return jsonify(MenuItem=item.serialize)

I also solved it with by creating a list and passing the list in, but its a lot more work than using serialize :)

edited Apr 3, 2016 at 11:30

answered Apr 3, 2016 at 11:07

Tikkaty

8021 gold badge9 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

YnkDK Over a year ago

You can also have a look at stackoverflow.com/a/21411576/4620080 if you need a general way of solving this

Collectives™ on Stack Overflow

How do I return single object with JSON in Python with Flask

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related