Visual Studio C#如何解析并列出JSON Web服务的每条记录/字段

Hey there! Let's walk through how to parse that JSON and display each record's fields—here are examples using two popular languages to cover different scenarios:

在JavaScript中（浏览器/Node.js通用） #

First, you'll convert the JSON string into a JavaScript object, then loop through the records array to extract each field.

示例代码： #

// 先补全原始JSON的语法错误（末尾的不完整字段）
const jsonData = `{"records":[{"id":"10","email":"bcomecomaaacomea@myhost.om","name":"Dot"},{"id":"855","email":"webcastpoa0@myhost","name":"name_0"},{"id":"856","email":"webcastpoa1@myhost","name":"name_1"},{"id":"857","email":"webcastpoa2@myhost","name":"name_2"},{"id":"858","email":"webcastpoa3@myhost","name":"name_3"},{"id":"859","email":"webcastpoa4@myhost","name":"name_4"},{"id":"860","email":"webcastpoa5@myhost","name":"name_5"}]}`;

// 解析JSON字符串为JS对象
const parsedData = JSON.parse(jsonData);

// 遍历数组，输出每个记录的字段
parsedData.records.forEach(record => {
  console.log(`ID: ${record.id}, Name: ${record.name}, Email: ${record.email}`);
  
  // 如果是浏览器端，还可以把内容渲染到页面上：
  // document.querySelector('#record-container').innerHTML += `
  //   <div class="record">
  //     <p>ID: ${record.id}</p>
  //     <p>Name: ${record.name}</p>
  //     <p>Email: ${record.email}</p>
  //   </div>
  // `;
});

控制台输出效果： #

ID: 10, Name: Dot, Email: bcomecomaaacomea@myhost.om
ID: 855, Name: name_0, Email: webcastpoa0@myhost
ID: 856, Name: name_1, Email: webcastpoa1@myhost
...

在Python中 #

Python has a built-in json module that makes parsing straightforward.

示例代码： #

import json

# 补全语法错误后的JSON字符串
json_str = '''{"records":[{"id":"10","email":"bcomecomaaacomea@myhost.om","name":"Dot"},{"id":"855","email":"webcastpoa0@myhost","name":"name_0"},{"id":"856","email":"webcastpoa1@myhost","name":"name_1"},{"id":"857","email":"webcastpoa2@myhost","name":"name_2"},{"id":"858","email":"webcastpoa3@myhost","name":"name_3"},{"id":"859","email":"webcastpoa4@myhost","name":"name_4"},{"id":"860","email":"webcastpoa5@myhost","name":"name_5"}]}'''

# 解析JSON为Python字典
data = json.loads(json_str)

# 遍历records列表，打印每个字段
for record in data['records']:
    print(f"ID: {record['id']}, Name: {record['name']}, Email: {record['email']}")

终端输出效果： #

ID: 10, Name: Dot, Email: bcomecomaaacomea@myhost.om
ID: 855, Name: name_0, Email: webcastpoa0@myhost
ID: 856, Name: name_1, Email: webcastpoa1@myhost
...

关键注意点： #

• JSON语法合法性：你的原始JSON末尾有"emai..."，这是不完整的，必须补全为合法JSON（比如补充完整的键值对），否则解析时会抛出语法错误。
• API场景优化：如果是从Web服务接口获取JSON，大多数HTTP客户端库（比如JS的fetch、Python的requests）会自动帮你解析成对象/字典，不需要手动调用JSON.parse()或json.loads()。

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