通过VBScript从JSON字符串提取信息遇阻，请求排查问题

Hey there! Let's walk through the most common reasons you might be getting an empty output.txt when pulling data from a JSON string, along with easy fixes for each scenario.

It's super easy to misnavigate JSON's nested layers or misspell a key name—this is the #1 culprit for empty outputs.

For example, if your JSON looks like this:

{
  "api_response": {
    "results": [
      {"id": 1, "name": "Bob"},
      {"id": 2, "name": "Charlie"}
    ]
  }
}

Trying to grab data["results"] directly will fail because you skipped the api_response parent layer.

Fix it with proper navigation:

import json

# Load the JSON
with open("input.json", "r") as infile:
    json_data = json.load(infile)

# Correct path to the data
target_data = json_data["api_response"]["results"]

# Write to output
with open("output.txt", "w") as outfile:
    for item in target_data:
        outfile.write(f"{item['name']}\n")

If your JSON has syntax errors (like Chinese quotation marks, trailing commas in arrays/objects, or missing closing brackets), the parser will fail silently (or throw an error you're not catching), and your code won't reach the writing step.

• Quick check: Add error handling to catch parsing issues:

import json

try:
    with open("input.json", "r") as infile:
        json_data = json.load(infile)
except json.JSONDecodeError as e:
    print(f"Whoops, JSON is broken: {e}")
    exit()

# Rest of your extraction logic...

Fix any syntax errors before trying again.

Sometimes the JSON is valid, but the field you're targeting is an empty array, null, or empty string. For example, if json_data["api_response"]["results"] is an empty list [], your loop won't run, leaving output.txt blank.

• Debug tip: Print the data before writing to confirm it has content:

target_data = json_data["api_response"]["results"]
print(f"Found {len(target_data)} items to extract")  # If this says 0, that's the issue!

if target_data:
    with open("output.txt", "w") as outfile:
        for item in target_data:
            outfile.write(f"{item['name']}\n")
else:
    print("No valid data found—so output.txt is empty!")

You might be writing to a directory you don't have access to, or your code is saving the file in a different location than you expect.

• Fixes:
  • Use an absolute file path (e.g., C:\Users\YourName\Documents\output.txt on Windows, /home/YourName/output.txt on Linux/macOS) to avoid confusion.
  • Check your current working directory to see where files are being saved:

    import os
    print(f"Current working directory: {os.getcwd()}")
    

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