list array of objects using python flask

Question

i have a payload as shown below which is stored in mongodb

{ 
    "_id" : ObjectId("5865fbf5558b670ac091c81e"), 
    "sensors" : [
        {
            "sensorStatus" : "green ", 
            "sensorName" : "s1"
        }, 
        {
            "sensorStatus" : "red ", 
            "sensorName" : "s2"
        }
    ], 
    "camera" : [
        {
            "cameraName" : "cam1", 
            "cameraStatus" : "live"
        }, 
        {
            "cameraName" : "cam2", 
            "cameraStatus" : "live"
        }
    ], 
    "checkpoints" : [
        {
            "checkPointName" : "chk1"
        }
    ]
}

trying to write route to display this data as shown below

@gateway_bp.route('/gateway',methods=['GET'])
def list_gateWay():
    gateways = Gateway.query.all()
    print gateways
    return Response(json.dumps(gateways),  mimetype='application/json')

i am getting the error has

TypeError: <app.model.canvasmodel.Gateway object at 0x02E99D10> is not JSON serializable

the schema is as shown below

from app.dbconfig.extensions import db

class Sensors(db.Document):
    sensorName = db.StringField()
    sensorStatus = db.StringField()


class Camera(db.Document):
    cameraName = db.StringField()
    cameraStatus = db.StringField()

class Checkpoints(db.Document):
    checkPointName = db.StringField()

class Gateway(db.Document):
    sensors = db.ListField(db.DocumentField(Sensors), db_field='sensors')
    camera = db.ListField(db.DocumentField(Camera), db_field='camera')
    checkpoints = db.ListField(db.DocumentField(Checkpoints), db_field='checkpoints')

please help to correct the get request thanks

Where is the output of `print gateways`? Can you also `print type(gateways)`? — Mohammad Yusuf, Jan 02 '17 at 07:47
So it's a list of `Gateway` Objects. `json.dumps()` wont work on lists. It will take a JSON object as an argument. — Mohammad Yusuf, Jan 02 '17 at 07:57
please guide how to convert the list as objects but sensors in sampel is array of object not sure how do it please modify the query — dhana lakshmi, Jan 02 '17 at 07:59
Can you try this: `json.dumps(gateways[0])` and see if it prints valid json. — Mohammad Yusuf, Jan 02 '17 at 08:04
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/132065/discussion-between-mygz-and-dhana-lakshmi). — Mohammad Yusuf, Jan 02 '17 at 08:12
I think `_id` causing problem here. Try adding `_id` filed in `Gateway` class — Jyothi Babu Araja, Jan 02 '17 at 08:24

list array of objects using python flask

0 Answers0