我正在进行API调用,并为每个ID返回嵌套JSON响应
如果我运行一个ID的API调用,JSON看起来像这样。u'{"id":26509,"name":"ORD.00001","order_type":"sales","consumer_id":415372,"order_source":"in_store","is_submitted":0,"fulfillment_method":"in_store","order_total":150,"balance_due":150,"tax_total":0,"coupon_total":0,"order_status":"cancelled","payment_complete":null,"created_at":"2017-12-02 19:49:15","updated_at":"2017-12-02 20:07:25","products":[{"id":48479,"item_master_id":239687,"name":"QA_FacewreckHaze","quantity":1,"pricing_weight_id":null,"category_id":1,"subcategory_id":8,"unit_price":"150.00","original_unit_price":"150.00","discount_total":"0.00","created_at":"2017-12-02 19:49:45","sold_weight":10,"sold_weight_uom":"GR"}],"payments":[],"coupons":[],"taxes":[],"order_subtotal":150}'
我可以使用以下代码行成功地将这一JSON字符串解析为数据帧:
^{pr2}$
我可以使用以下代码通过API迭代所有ID:
^{pr3}$
现在,我的JSON响应都存储在列表中。如何将所有元素写入列表中,以数据帧?
我一直在尝试的代码是:
^{pr4}$
我得到错误:AttributeError: 'unicode' object has no attribute 'itervalues'
我知道这是在第一线发生的:order_detail = json_normalize(x)
为什么这行对单个JSON字符串有效,但对于列表不工作?我怎样才能将嵌套JSON列表放入数据框架中?
提前感谢您的帮助。
编辑:
^{pr7}$