<pre>@DATAQU.route('/start_date-end_date', methods=['GET']) def subscription_date(): subscription_id = request.args.get('subscription_id') email = request.args.get('email') update_query = ''' select rmdata.subscription.id, start_date, end_date, column_name, column_value, display_text from rmdata.subscription join rmdata.subscription_user on rmdata.subscription_user.subscription_id=rmdata.subscription.id join account on public.account.id =rmdata.subscription_user.account_id join rmdata.market_filter on market_filter.subscription_id=rmdata.subscription.id where email = :a and rmdata.subscription.active is true limit 1 ''' result = db.session.execute(text(update_query), {'a':email}) final = [dict(i) for i in result] return{"sub_start_date_end_date":final}
Quote:How to convert json to excel
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)