Pass 2 parameters in url for app.route (python with flask )

Question

Try to pass two parameters but seems like I'm missing something with syntax here , can someone help me on this?

@app.route('/BotMetrics/<int:fromdate>/<int:todate>')
def user(fromdate, todate):
     print("connecting")
     con = Get_hdb()
     cursor1 = con.cursor(pymysql.cursors.DictCursor)
     cursor1.execute("select * from order_details where date between '%s' and '%s'",(fromdate,todate,))
     row = cursor1.fetchall()
     resp = jsonify(row)
     resp.status_code = 200
     return resp

Trying to access URL , here I want to pass two parameters FromDate and ToDate in URL ,

http://127.0.0.1:5000/BotMetrics/?FromDate?Todate

Does this answer your question? Multiple parameters in Flask approute — Jake Jackson
– Jake Jackson, Commented Mar 10, 2021 at 10:29

Rk5 · Accepted Answer · 2021-03-10 05:11:31Z

1

Updated the code to below and it worked

@app.route('/BotMetrics/<fromdate>/<todate>')
def user(fromdate=None, todate=None):
     print("connecting")
     con = Get_hdb()
     cursor1 = con.cursor(pymysql.cursors.DictCursor)
     cursor1.execute("select * from order_details where date between %s and %s",(fromdate,todate,))
     row = cursor1.fetchall()
     resp = jsonify(row)
     resp.status_code = 200
     return resp

URL

http://127.0.0.1:5000/BotMetrics/2021-02-01/2021-02-27

answered Mar 10, 2021 at 5:11

Rk5

3251 gold badge5 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Pass 2 parameters in url for app.route (python with flask )

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related