I'm at python and try to export datas from an API to a csv import requests import pandas as pd url = "https://api.bexio.com/2.0/article" #r = requests.get('https://api.bexio.com/2.0/article') headers = { 'Accept': "application/json", 'Content-Type': "application/json", 'Authorization': "Bearer xxx} That works fine. [{"id":34,"user_id":1,"article_type_id":1,"contact_id":null,"deliverer_code":"","deliverer_name":"","deliverer_description":"","intern_code":"TEXLINE-SOLD","intern_name":"TEXLINE Sold out","intern_description":"","purchase_price":"0.900000","sale_price":"2.450000","purchase_total":null,"sale_total":null,"currency_id":1,"tax_income_id":16,"tax_id":16,"tax_expense_id":22,"unit_id":1,"is_stock":true,"stock_id":null,"stock_place_id":null,"stock_nr":0,"stock_min_nr":0,"stock_reserved_nr":0,"stock_available_nr":0,"stock_picked_nr":0,"stock_disposed_nr":0,"stock_ordered_nr":0,"width":null,"height":null,"weight":null,"volume":null,"html_text":null,"remarks":" the problem here is, i want to export this data to csv where is then nicely listed in a table. I tried with from pandas.io.json import json_normalize dic = response.json() df = pandas.DataFrame(dic) df.to_csv('detections.csv', index=False, sep="\t") or with pandas as pd. But that dosen't work. Continue reading...
