No-Code Automation · 课时

解析 JSON 和 XML 响应

掌握从 API 调用返回的复杂 JSON 和 XML 数据中提取相关信息的技巧。

解析 JSON 和 XML 响应 是 CoddyKit 上的免费 No-Code Automation 课时。这是第 3 节课，共 4 节。你可以在下方免费阅读本课时的完整内容 — 然后在浏览器中使用内置代码编辑器和全天候 AI 导师进行实践。这是 No-Code Automation 学习路径的一部分，你的进度在网页和 CoddyKit 应用中同步。 No-Code Automation 课程共包含 4 节课。

本课时的部分内容尚未翻译，以英文显示。

Why Parse API Responses?

When you make an API call or receive a webhook, the data often comes in a structured format like JSON or XML. To use this data in your automation, you need to "parse" it.

Parsing means extracting specific pieces of information from a larger block of structured data. It's like finding a specific ingredient in a recipe. Without parsing, all you have is a raw string of text, which isn't very useful.

What is JSON?

JSON (JavaScript Object Notation) is a lightweight data-interchange format. It's human-readable and easy for machines to parse and generate.

It's built on two structures:

Objects: Collections of name/value pairs, like a dictionary or map. Surrounded by curly braces {}.
Arrays: Ordered lists of values, like a list. Surrounded by square brackets [].

Here's a simple JSON object:

{
  "name": "Coddy",
  "age": 3,
  "isStudent": true
}

Common JSON Data Types

JSON supports several data types:

Strings: Text enclosed in double quotes (e.g., "Hello")
Numbers: Integers or floating-point (e.g., 123, 3.14)
Booleans: true or false
Null: Represents an empty or non-existent value (null)
Objects: Nested {} structures
Arrays: Nested [] lists

Understanding these types helps you know what kind of data to expect.

Extracting Values from JSON

To get a value from a JSON object, you typically refer to its "key" (the name). In no-code tools, this often looks like a field selector.

Let's say we want the "name" and "age" from our previous example. We'd target these keys.

import json

data_string = '{"name": "Coddy", "age": 3, "isStudent": true}'
data = json.loads(data_string)

print(data["name"])
print(data["age"])

Working with Nested JSON

JSON can have objects inside objects, creating a "nested" structure. To access data in nested objects, you chain the keys.

Imagine a user object with an address object inside it:

{
  "user": {
    "firstName": "Jane",
    "lastName": "Doe",
    "address": {
      "street": "123 Main St",
      "city": "Anytown"
    }
  }
}

Accessing Nested Data

To get the "city" from the nested example, you'd go through user, then address, then city. No-code platforms often represent this with dot notation (e.g., user.address.city) or nested selectors.

import json

nested_data_string = '''
{
  "user": {
    "firstName": "Jane",
    "lastName": "Doe",
    "address": {
      "street": "123 Main St",
      "city": "Anytown"
    }
  }
}
'''
data = json.loads(nested_data_string)

print(data["user"]["address"]["city"])

Handling JSON Arrays (Lists)

JSON arrays are ordered lists of values. These values can be strings, numbers, or even other objects! When an API returns a list of items, it's often in an array.

You often need to loop through arrays to process each item. In no-code tools, this is handled by "Iterator" or "Loop" modules.

{
  "products": [
    {"id": 1, "name": "Laptop"},
    {"id": 2, "name": "Mouse"},
    {"id": 3, "name": "Keyboard"}
  ]
}

Understanding XML

XML (Extensible Markup Language) is another popular format for data exchange, especially in older systems or specific industries. It uses tags to define elements, similar to HTML.

XML documents have a hierarchical structure, starting with a root element. Each element can have attributes (like properties) and child elements.

Here's a basic XML example:

<root>
  <item id="1">
    <name>Product A</name>
    <price>19.99</price>
  </item>
  <item id="2">
    <name>Product B</name>
    <price>29.99</price>
  </item>
</root>

Accessing XML Data

Extracting data from XML involves navigating its tree-like structure. You identify elements by their tag names and can access their text content or attributes.

No-code platforms provide specific modules to parse XML, allowing you to select elements by path or iterate through child elements.

import xml.etree.ElementTree as ET

xml_string = '''
<root>
  <item id="1">
    <name>Product A</name>
    <price>19.99</price>
  </item>
  <item id="2">
    <name>Product B</name>
    <price>29.99</price>
  </item>
</root>
'''
root = ET.fromstring(xml_string)

# Find the first item's name
first_item_name = root.find('item/name').text
print(f"First item name: {first_item_name}")

# Find an attribute
second_item_id = root.findall('item')[1].get('id')
print(f"Second item ID: {second_item_id}")

Quick Check: Data Extraction

Consider the following JSON response from an API:

{
  "order": {
    "orderId": "XYZ789",
    "customer": {
      "id": 101,
      "email": "test@example.com"
    },
    "items": [
      {"itemId": "A1", "quantity": 2},
      {"itemId": "B2", "quantity": 1}
    ]
  }
}

Recap: Parsing API Responses

We've covered the essentials of parsing JSON and XML data, which are crucial for working with APIs and webhooks.

JSON uses objects {} and arrays [], accessed by keys or indices.
XML uses tags <element> and attributes, accessed by navigating its hierarchical structure.
No-code platforms provide specialized modules (like "Parse JSON" or "XML Parser") to help you extract the data you need for your automations.

Mastering parsing allows you to unlock the full potential of integrated applications!

常见问题解答

「解析 JSON 和 XML 响应」课时是免费的吗？

是的 — 「解析 JSON 和 XML 响应」的完整文本可在网页上免费阅读。要进行交互式练习（内置代码编辑器和全天候 AI 导师）并解锁 No-Code Automation 课程的其余内容，请升级到 CoddyKit PRO。 No-Code Automation 课程共包含 4 节课。

「解析 JSON 和 XML 响应」这节课中我会学到什么？

掌握从 API 调用返回的复杂 JSON 和 XML 数据中提取相关信息的技巧。你通过在浏览器中直接运行的动手代码来练习 No-Code Automation，全天候 AI 导师会在你学习这节课的过程中回答你的问题。

学习 No-Code Automation 需要有经验吗？

无需任何先前经验。CoddyKit 上的 No-Code Automation 课程适合初学者到高级学习者，你可以从这里开始或从头开始，按照自己的节奏学习。这是第 3 节课，共 4 节。

「解析 JSON 和 XML 响应」课时需要多长时间？

大多数 CoddyKit 课程大约需要 5–10 分钟。每节课都很精短且互动，所以你能稳步进步，并在网页和应用中从离开的地方继续。

我能在这节 No-Code Automation 课中编写并运行代码吗？

能。每节 No-Code Automation 课都包含内置代码编辑器，你可以在浏览器中直接编写并运行真实代码，并获得即时 AI 反馈 — 无需本地设置。

此课程中的所有课时

← 返回 No-Code Automation