烧瓶request.json命令 [英] flask request.json order

查看：126
本文介绍了烧瓶request.json命令的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我得到JSON数据提交给我的api（使用Flask构建）端点，我需要这些数据导出到Excel，但问题是，一旦我的api接收到数据，并加载它的请求.json em>数据的body部分是乱码的，而不是按照相同的顺序收到它，这完全破坏了我的表格标题，而没有提到输出excel格式的必要。



包括下面的原始JSON数据我收到我的api 

  {
data：{
 header：[
date，group.groupname，user.NameSurname，forwarding_number，reciver_number，CallerNameSurname，alert，connection，call_summ
]，
body：[
 
date：2013-01-08，
group.groupname：customerService，
user.NameSurname：RomānsTiščenko，
forwarding_number：66055002，
reciver_number：66055002，
CallerNameSurname：false，
a lert：00:00:14，
连接：00:00:53，
call_summ：00:01:07
}，
 $bdate：2013-01-08，
group.groupname：customerService，
user.NameSurname：RomānsTiščenko，
forwarding_number：66055002，
reciver_number：66055002，
CallerNameSurname：false，
alert：00:00:27，
connection：00:00:25，
call_summ：00:00:52
}，
 {
date：2013 -01-08，
group.groupname：customerService，
user.NameSurname：RomānsTiščenko，
forwarding_number：66055002，
reciver_number：66055002，
CallerNameSurname：false，
alert：00:00:16，
connection：00:01:00 ，
call_summ：00:01:16
 $ b $ date $：2013-01-08，
group.groupname：customerService，
user.NameSurname： ArvīdsBoļesko，
forwarding_number：66055001，
reciver_number：66055001，
CallerNameSurname：false，
alert： 00:22，
connection：00:00:52，
call_summ：00:01:14
}，
 {
date：2013-01-08，
group.groupname：customerService，
user.NameSurname：RomānsTiščenko，
forwarding_number： 66055002，
reciver_number：66055002，
CallerNameSurname：false，
alert：00:00:18，
连接： 00:00:09，
call_summ：00:00:27
}，
 {
date：2013-01-08， 
group.groupname： customerService，
user.NameSurname：RomānsTiščenko，
forwarding_number：66055002，
reciver_number：66055002，
CallerNameSurname： false，
alert：00:00:09，
connection：00:01:59，
call_summ：00:02:08
 $ b $ date $：2013-01-08，
group.groupname：customerService，
user.NameSurname： RomānsTiščenko，
forwarding_number：66055002，
reciver_number：66055002，
CallerNameSurname：false，
alert：00： 00:08，
connection：00:02:14，
call_summ：00:02:22
}，
 {
date：2013-01-08，
group.groupname：customerService，
user.NameSurname：Roberts Neijs，
forwarding_num ber：66055003，
reciver_number：66055003，
CallerNameSurname：false，
alert：00:00:04，
连接：00:00:01，
call_summ：00:00:05
}，
 {
date：2013-01- 08，
group.groupname：customerService，
user.NameSurname：ArvīdsBoļesko，
forwarding_number：66055001，
reciver_number ：66055001，
CallerNameSurname：false，
alert：00:00:57，
connection：00:01:26，
call_summ：00:02:23
}，
 {
date：2013-01-08，
group.groupname： customerService，
user.NameSurname：Roberts Neijs，
forwarding_number：66055003，
reciver_number：66055003，
CallerNameSurname ：false，
alert：00:00:05，
connection：00:02:23，
call_summ：00:02:28
 }，
 {
date：2013-01-08，
group.groupname：customerService，
user.NameSurname：Roberts Neijs ，
forwarding_number：66055003，
reciver_number：66055003，
CallerNameSurname：false，
alert：00:00:06 ，
connection：00:00:44，
call_summ：00:00:50
}，
 {
date ：2013-01-08，
group.groupname：customerService，
user.NameSurname：RomānsTiščenko，
forwarding_number：66055002 ，
reciver_number：66055002，
CallerNameSurname：false，
alert：00:00:08，
connection：00： 02:43，
call_summ： 00:02:51
}，
 {
date：2013-01-08，
group.groupname：customerService，
user.NameSurname：Roberts Neijs，
forwarding_number：66055003，
reciver_number：66055003，
CallerNameSurname：false，
alert：00:00:05，
connection：00:01:13，
call_summ：00:01:18
}， 
 {
date：2013-01-08，
group.groupname：customerService，
user.NameSurname：Roberts Neijs， 
forwarding_number：66055003，
reciver_number：66055003，
CallerNameSurname：false，
alert：00:00:09， 
connection：00:00:01，
call_summ：00:00:10
}，
 {
date： 2013-01-08，
group.groupnam e：administration，
user.NameSurname：IevaSproģe，
forwarding_number：67783165，
reciver_number：67783165，
 CallerNameSurname：false，
alert：00:00:06，
connection：00:01:30，
call_summ：00:01 ：36
，
 {
date：2013-01-08，
group.groupname：customerService，
user .NameSurname：Roberts Neijs，
forwarding_number：66055003，
reciver_number：66055003，
CallerNameSurname：false，
alert ：00:00:06，
连接：00:00:50，
call_summ：00:00:56
}，
 {
date：2013-01-08，
group.groupname：administration，
user.NameSurname：IevaSproģe，
 forwarding_number：67 783165，
reciver_number：67783165，
CallerNameSurname：false，
alert：00:00:04，
connection： 00:02:00，
call_summ：00:02:04
}，
 {
date：2013-01-08，
group.groupname：customerService，
user.NameSurname：Roberts Neijs，
forwarding_number：66055003，
reciver_number：66055003 ，
CallerNameSurname：false，
alert：00:00:07，
connection：00:00:26，
call_summ ：00:00:33
}，
 {
date：2013-01-08，
group.groupname：administration， 
user.NameSurname：IevaSproģe，
forwarding_number：67783165，
reciver_number：67783165，
CallerNameSurname：false，
 alert：00:00:04，
connection：00:00:13，
call_summ：00:00:17
} 
 $ bfooter：[
,,,,,, 7,8,9
]，
filename：outGoingAnswered.xls
 
 
 
 
 
 
正如我所说，一旦读入api中 request.json body的每个row中的数据被加密 - 订单被破坏。它应该是写在头文件。
 
 
我试图加载它使用不同的json库，但结果是相同的，加载的数据不在与其给出的顺序相同。我完全不知道为什么会发生这种情况，这让我的生活变得非常困难，因为我相对比较新的Python。
 
 
 
我应该提到，我不能匹配标题列的键，因为标题可能比bodyrow中的键少。 
 
 
作为一个输出示例，我可以提供scrambled version发布的JSON数据略有不同：
  {
data：{
body：[ 
$ group $groupService$ customer $ $ $ $ $connection：00:01:28，
call_summ：00:01:42 ，
CallerNameSurname：false，
forwarding_number：66055002，
user.NameSurname：Arnolds Apels，
date：2012 -12-13，
reciver_number：66055002，
alert：00:00:14
}，
 {
 .groupname：customerService，
connec 00:01:33，
call_summ：00:01:45，
CallerNameSurname：false，
forwarding_number：66055002 ，
user.NameSurname：Arnolds Apels，
date：2012-12-13，
reciver_number：66055002，
alert ：00:00:12
}，
 {
group.groupname：administration，
connection：00:00:30， 
call_summ：00:00:33，
CallerNameSurname：false，
forwarding_number：67783165，
user.NameSurname： IevaSproģe，
date：2012-12-13，
reciver_number：67783165，
alert：00:00:03
 $ bheader：[
date，group.groupname，user.NameSurname，forwarding_number，reciver_number，CallerNameSurname，alert，connection，call_summ
] ，
footer：[
 
，
文件名：[
asdasda.xls
]false，false，user.NameSurname，forwarding_number，reciver_number，CallerNameSurname，alert，connection，call_summ 
 
 
 
 
 
 
 
为了更好的衡量，添加了excel导出代码： / b> 
 
 
  r = request.json 
 data = r ['data'] 
 if data：
＃初始化excel导出
 excel = Workbook（）
 sheet = excel.add_sheet（'Report'）
 
 ## Excel header 
 
＃Setup字体样式
 font = Font（）
 font.name ='Arial'
 font.bold = True 
 
＃设置单元格边框样式
 borders = Borders（）
 borders.bottom = 1 
 borders.right = 1 
 
＃安装格式化样式
 style = XFSt​​yle（）
 style.font =字体
 style.borders =边界
 
＃写入标题
 header = data ['header'] [0] 
 headers = header.split（'，'） 
 h = 0 
在col中的标题：
如果col =='false'：
 col =''
 sheet.write（0，h，col，style）
h + = 1 
 
＃写入主体
行= data ['body'] 
i = 1 
行中的行：
x = sheet。 row（i）
y = 0 
 for key，value in row.iteritems（）：
 x.write（y，value）
y + = 1 
i + = 1 
 
＃写脚注
脚注= data ['footer'] [0] 
 footers = footer.split（'，'）
f = 0 $ b $如果col =='false'：
 col =''
 sheet.write（i，f，col）
f + = 1 
 
＃设置栏宽度
 if h> f：
 cols = h 
 else：
 cols = f 
 a = 0 
 while a< cols：
 sheet.col（a）.width = 5000 
a + = 1 
 
＃获取报告文件名称
 filename = data ['filename'] [0] 
 $ b $设置报告路径
 path =/ path / to / exports /+文件名
 
＃保存报告
 excel.save（path ）
  
 
 
解决方案
 Python字典是 unordered ，和JSON对象一样。您看到的行为是正常的。
 
 
 
如果您需要保留排序，请不要使用 dict（）而是一个列表元组，而不是：
 
 
  [
 [date，2013-01-08]， 
 [group.groupname，customerService]，
 [user.NameSurname，RomānsTiščenko]，
 [forwarding_number，66055002]，
 [reciver_number，66055002]，
 [CallerNameSurname，false]，
 [alert，00:00:14]，
 [connection， 00:00:53]，
 [call_summ，00:01:07] 
]，
＃...等等
  data ['header'] [0] <$ c $> 
 
 
  / code>字符串按顺序读取正文 dict（）的值，因为已经为您订购了：
 
 $ b $对于行中的行，
 $ $ $ $ $ $ $ $ $ $ $ $ $ by = 0 
用于列标题：
 x.write（y，row.get（col，'' ））
 y + = 1 
 i + = 1 
  
 
I get JSON data submitted to my api (built with Flask) endpoint and I need that data to be exported to excel but the problem is that once my api receives the data and loads it with request.json the the "body" part of data is scrambled - not in the same order I receive it which completely breaks my table headings not to mention the needed ouput excel format.



Including below the raw JSON data I receive to my api
{
"data": {
    "header": [
        "date,group.groupname,user.NameSurname,forwarding_number,reciver_number,CallerNameSurname,alert,connection,call_summ"
    ],
    "body": [
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Romāns Tiščenko",
            "forwarding_number": "66055002",
            "reciver_number": "66055002",
            "CallerNameSurname": false,
            "alert": "00:00:14",
            "connection": "00:00:53",
            "call_summ": "00:01:07"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Romāns Tiščenko",
            "forwarding_number": "66055002",
            "reciver_number": "66055002",
            "CallerNameSurname": false,
            "alert": "00:00:27",
            "connection": "00:00:25",
            "call_summ": "00:00:52"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Romāns Tiščenko",
            "forwarding_number": "66055002",
            "reciver_number": "66055002",
            "CallerNameSurname": false,
            "alert": "00:00:16",
            "connection": "00:01:00",
            "call_summ": "00:01:16"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Arvīds Boļesko",
            "forwarding_number": "66055001",
            "reciver_number": "66055001",
            "CallerNameSurname": false,
            "alert": "00:00:22",
            "connection": "00:00:52",
            "call_summ": "00:01:14"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Romāns Tiščenko",
            "forwarding_number": "66055002",
            "reciver_number": "66055002",
            "CallerNameSurname": false,
            "alert": "00:00:18",
            "connection": "00:00:09",
            "call_summ": "00:00:27"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Romāns Tiščenko",
            "forwarding_number": "66055002",
            "reciver_number": "66055002",
            "CallerNameSurname": false,
            "alert": "00:00:09",
            "connection": "00:01:59",
            "call_summ": "00:02:08"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Romāns Tiščenko",
            "forwarding_number": "66055002",
            "reciver_number": "66055002",
            "CallerNameSurname": false,
            "alert": "00:00:08",
            "connection": "00:02:14",
            "call_summ": "00:02:22"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Roberts Neijs",
            "forwarding_number": "66055003",
            "reciver_number": "66055003",
            "CallerNameSurname": false,
            "alert": "00:00:04",
            "connection": "00:00:01",
            "call_summ": "00:00:05"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Arvīds Boļesko",
            "forwarding_number": "66055001",
            "reciver_number": "66055001",
            "CallerNameSurname": false,
            "alert": "00:00:57",
            "connection": "00:01:26",
            "call_summ": "00:02:23"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Roberts Neijs",
            "forwarding_number": "66055003",
            "reciver_number": "66055003",
            "CallerNameSurname": false,
            "alert": "00:00:05",
            "connection": "00:02:23",
            "call_summ": "00:02:28"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Roberts Neijs",
            "forwarding_number": "66055003",
            "reciver_number": "66055003",
            "CallerNameSurname": false,
            "alert": "00:00:06",
            "connection": "00:00:44",
            "call_summ": "00:00:50"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Romāns Tiščenko",
            "forwarding_number": "66055002",
            "reciver_number": "66055002",
            "CallerNameSurname": false,
            "alert": "00:00:08",
            "connection": "00:02:43",
            "call_summ": "00:02:51"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Roberts Neijs",
            "forwarding_number": "66055003",
            "reciver_number": "66055003",
            "CallerNameSurname": false,
            "alert": "00:00:05",
            "connection": "00:01:13",
            "call_summ": "00:01:18"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Roberts Neijs",
            "forwarding_number": "66055003",
            "reciver_number": "66055003",
            "CallerNameSurname": false,
            "alert": "00:00:09",
            "connection": "00:00:01",
            "call_summ": "00:00:10"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "administration",
            "user.NameSurname": "Ieva Sproģe",
            "forwarding_number": "67783165",
            "reciver_number": "67783165",
            "CallerNameSurname": false,
            "alert": "00:00:06",
            "connection": "00:01:30",
            "call_summ": "00:01:36"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Roberts Neijs",
            "forwarding_number": "66055003",
            "reciver_number": "66055003",
            "CallerNameSurname": false,
            "alert": "00:00:06",
            "connection": "00:00:50",
            "call_summ": "00:00:56"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "administration",
            "user.NameSurname": "Ieva Sproģe",
            "forwarding_number": "67783165",
            "reciver_number": "67783165",
            "CallerNameSurname": false,
            "alert": "00:00:04",
            "connection": "00:02:00",
            "call_summ": "00:02:04"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "customerService",
            "user.NameSurname": "Roberts Neijs",
            "forwarding_number": "66055003",
            "reciver_number": "66055003",
            "CallerNameSurname": false,
            "alert": "00:00:07",
            "connection": "00:00:26",
            "call_summ": "00:00:33"
        },
        {
            "date": "2013-01-08",
            "group.groupname": "administration",
            "user.NameSurname": "Ieva Sproģe",
            "forwarding_number": "67783165",
            "reciver_number": "67783165",
            "CallerNameSurname": false,
            "alert": "00:00:04",
            "connection": "00:00:13",
            "call_summ": "00:00:17"
        }
    ],
    "footer": [
        ",,,,,,7,8,9"
    ],
    "filename": "outGoingAnswered.xls"
}
}

As I said, once this is read into the api with request.json the data within each "row" of "body" is scrambled - the order is broken. It should be as written in the header.



I've tried to load it using a different json library but the outcome is the same, the loaded data in not in the same order as it was given. I'm completely clueless as to why it would happen that way and it's making my life really difficult as I'm relatively new to Python.



I should mention that I cannot match the keys to header columns as the headers could have less keys than in the "body" "row".



As an example output I can offer the "scrambled version" of slightly different posted JSON data:
{
"data": {
    "body": [
        {
            "group.groupname": "customerService",
            "connection": "00:01:28",
            "call_summ": "00:01:42",
            "CallerNameSurname": "false",
            "forwarding_number": "66055002",
            "user.NameSurname": "Arnolds Apels",
            "date": "2012-12-13",
            "reciver_number": "66055002",
            "alert": "00:00:14"
        },
        {
            "group.groupname": "customerService",
            "connection": "00:01:33",
            "call_summ": "00:01:45",
            "CallerNameSurname": "false",
            "forwarding_number": "66055002",
            "user.NameSurname": "Arnolds Apels",
            "date": "2012-12-13",
            "reciver_number": "66055002",
            "alert": "00:00:12"
        },
        {
            "group.groupname": "administration",
            "connection": "00:00:30",
            "call_summ": "00:00:33",
            "CallerNameSurname": "false",
            "forwarding_number": "67783165",
            "user.NameSurname": "Ieva Sproģe",
            "date": "2012-12-13",
            "reciver_number": "67783165",
            "alert": "00:00:03"
        }
    ],
    "header": [
        "date,group.groupname,user.NameSurname,forwarding_number,reciver_number,CallerNameSurname,alert,connection,call_summ"
    ],
    "footer": [
        "false,false,user.NameSurname,forwarding_number,reciver_number,CallerNameSurname,alert,connection,call_summ"
    ],
    "filename": [
        "asdasda.xls"
    ]
}
}

And for good measure adding the excel exporting code:
r = request.json
data = r['data']
if data:
    # Initialize excel export
    excel = Workbook()
    sheet = excel.add_sheet('Report')

    ## Excel headers

    # Setup font styling
    font = Font()
    font.name = 'Arial'
    font.bold = True

    # Setup cell border styling
    borders = Borders()
    borders.bottom = 1
    borders.right = 1

    # Setup formating style
    style = XFStyle()
    style.font = font
    style.borders = borders

    # Write headers
    header = data['header'][0]
    headers = header.split(',')
    h = 0
    for col in headers:
        if col == 'false':
            col = ''
        sheet.write(0, h, col, style)
        h += 1

    # Write body
    rows = data['body']
    i = 1
    for row in rows:
        x = sheet.row(i)
        y = 0
        for key, value in row.iteritems():
            x.write(y, value)
            y += 1
        i += 1

    # Write footer
    footer = data['footer'][0]
    footers = footer.split(',')
    f = 0
    for col in footers:
        if col == 'false':
            col = ''
        sheet.write(i, f, col)
        f += 1

    # Setup column widths
    if h > f:
        cols = h
    else:
        cols = f
    a = 0
    while a < cols:
        sheet.col(a).width = 5000
        a += 1

    # Get report filename
    filename = data['filename'][0]

    # Setup report path
    path = "/path/to/exports/" + filename

    # Save the report
    excel.save(path)



 解决方案 
Python dictionaries are unordered, as are JSON objects. The behaviour you see is normal.



If you need to retain ordering, don't use a dict() but a list up tuples instead:
   [
       ["date", "2013-01-08"],
       ["group.groupname", "customerService"],
       ["user.NameSurname", "Romāns Tiščenko"],
       ["forwarding_number", "66055002"],
       ["reciver_number", "66055002"],
       ["CallerNameSurname", false],
       ["alert", "00:00:14"],
       ["connection", "00:00:53"],
       ["call_summ", "00:01:07"]
   ],
   # ... etc.

Or you could also use the data['header'][0] string to read the body dict() values in order, since that is already ordered for you:
rows = data['body']
i = 1
for row in rows:
    x = sheet.row(i)
    y = 0
    for col in headers:
        x.write(y, row.get(col, ''))
        y += 1
    i += 1



                        
这篇关于烧瓶request.json命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
相关文章
Python最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆