如何使用Python根据行值过滤REST API的行响应？

嘿，我帮你把这个Oracle Service Cloud的REST API POST请求响应整理得更清晰直观，方便你查看和解析：

原始响应内容 #

{"count":16,"name":"Report Name","columnNames":["Connection","Complete Name","Login ID","Login Time","Logout Time","IP Direction"],"rows":[["PGALICHI","Robert The IT Guy","3205","2018-01-25 08:52:23","2018-01-25 15:00:50","201.255.56.151"],["PGALICHI","Lucas The other IT Guy","3204","2018-01-25 08:52:21","2018-01-25 15:00:51","201.255.56.151"]],"links":[{"rel":...}]}

核心字段说明 #

• count: 报表返回的总记录数，这里是16条
• name: 当前报表的名称，示例中为Report Name
• columnNames: 定义了返回数据的列字段，对应每行数据的含义：
  • Connection
  • Complete Name
  • Login ID
  • Login Time
  • Logout Time
  • IP Direction
• rows: 具体的业务数据集合，每个子数组对应一条记录，和columnNames的顺序一一匹配
• links: 关联的API链接信息（示例内容被截断，通常包含self、next等关系标识，用于分页或访问相关资源）

转换为易读的表格格式 #

为了更直观查看数据，我把rows里的内容转换成了表格：

内容的提问来源于stack exchange，提问作者Gabriel Loyo