how to save api output json as csv file

kaushik guru

I have an API output as follows

{ "sub_start_date_end_date": [

{ "account_id": "10996fd6-a708-4d70-b65e-50620d8fbbdf",

"country": "'USA'",

"end_date": "Fri, 03 Sep 2021 00:00:00 GMT",

"start_date": "Thu, 03 Sep 2020 00:00:00 GMT" } ] }

I need to save it as create and save it as a csv file

@final.route('/start_date-end_datess', methods=['GET'])

def subscription_datess():

subscription_id = request.args.get('subscription_id')

email = request.args.get('email')

update_query = '''

some query '''

result = db.session.execute(text(update_query), {'a':email})

final = [dict(i) for i in result]

excel = json.load(final)

files = csv.writer(open("test.csv", "wb+"))

files.writerow(["account_id", "country", "end_date", "start_date"])

for excel in excel:

files.writerow([excel["account_id"],

excel["country"],

excel["end_date"],

excel["start_date"]])

return{"sub_start_date_end_date":final}

when executing this end point I am getting the following error list' object has no attribute 'read'

Kindly guide

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

kaushik guru6y ago
create a seperate function to write csv file and call it after the dict function

@final.route('/start_date-end_datess', methods=['GET'])
def subscription_datess():
subscription_id = request.args.get('subscription_id')
email = request.args.get('email')
update_query = '''
some query
'''
result = db.session.execute(text(update_query), {'a':email})
final = [dict(i) for i in result]
for items in final:
write_csv(items)
return{"sub_start_date_end_date":final}
def write_csv(data):
with open('excel.csv', 'a') as file:
writer = csv.writer(file)
writer.writerow([data['account_id'],
data['country'],
data['end_date'],
data['start_date']])
kaushik guru6y ago
thanks for the suggestions mam , but all your reference are for c# and i am trying python api
Ronika Jency6y ago
Hi,

Please refer below links,

https://www.aspsnippets.com/Articles/Dynamically-create-and-download-CSV-file-in-ASPNet-using-C-and-VBNet.aspx

http://www.vickram.me/download-csv-using-asp-net-web-api

https://stackoverflow.com/questions/29948809/web-api-return-csv-file/29951751