Python :没有定义名称'null‘

Question

在图片在这里输入图像描述中，json响应作为json列表中的字符串。

我试图在字符串中获取值，但输出显示了这个错误NameError: name 'null' is not defined，当json值是字符串在这里输入图像描述时，我无法读取它们。

这是我的密码：

 url = "https://api.pipedream.com/v1/sources/code/event_summaries? 
 expand=event"
 headers = {"Authorization": "Bearer hash "}
 response = requests.get(url, headers=headers)
 data = response.text
 datas = json.loads(data)
 darts = datas['data']
 for i in darts:
   trake = i['event']['body']
       for docz in trake:
         open_time = open_time = docz['open_time']
         print(open_time)

在这里输入图像描述

问题是json值是字符串，我无法检测值。

顺便说一句，只是一个演示

Answer 1

你需要的数据在一个丁字键里。因此，您需要使用.keys()属性检索它，然后必须使用json.loads()将其转换为字典。

请检查以下代码：

import requests
import http.client
import json
from ast import literal_eval as evall


url = "https://api.pipedream.com/v1/sources/code/event_summaries?expand=event"
headers = {"Authorization": "Bearer hash"}
response = requests.get(url, headers=headers)


data = response.text
datas = json.loads(data)

darts = datas['data']

for i in darts:
    trake = i['event']['body']
    for docz in trake:
        print(docz)


for tracks in darts:
    tracks = json.loads(list(tracks['event']['body'].keys())[0])
    print(tracks)
    
    open_time = tracks['event']['trade'].get('open_time', '')
    close_time = tracks['event']['trade'].get('close_time', '')
    Lots = tracks['event']['trade'].get('lots', '')
    balance = tracks['event']['account'].get('balance', '')
    symbol = tracks['event']['trade'].get('symbol', '')
    profit = tracks['event']['trade'].get('profit', '')
    total_profit = tracks['event']['trade'].get('total_profit', '')


    msg = """

      Open time :  """ +open_time + """
      Close time :  """ +close_time + """
      Symbol : """ +symbol + """
      lots : """ +Lots + """
      Balance : """ +balance + """
      """


    print(msg)
    print("success")