leboncoin | Little leboncoin parser | Parser library

The call to serialise is coming from finalize_request->save_session. So this is post-processing by the framework. Some frameworks save session content to disk, to free memory. (There could be a setting to control this). You have probably stored the Row object in session, so its trying to serialise that, and hence the error. Solution is to not save Row in the session, or make Row serializable. See https://pynative.com/make-python-class-json-serializable/

The way you connect to your database using mysql_connection.cursor(dictionary=True) returns rows as dicts. The property of a dict is that it can have unique keys, in your case all the columns have the same name in the table name. So there can only be one key of that name.

To overcome this you need to alias your column names like so

SELECT tasks.id, tasks.name as tname, tasks.introduction, platforms.name as pname, type_tasks.name as ttname, categories.name as cname ....

data[0].annonces is an object, so you can use forin loop, e.g:

You are making a get request with axios. The parameters sent with get request are available in req.query.

Parameters passed with post request are received in req.body.