34 lines
1.3 KiB
Python
34 lines
1.3 KiB
Python
import json
|
||
import re
|
||
|
||
def process(input_strings: list) -> list:
|
||
"""解析 JSON 数组，提取用户指定的字段并按模板拼接"""
|
||
json_str, template = input_strings[0], input_strings[1]
|
||
try:
|
||
# 解析 JSON
|
||
data = json.loads(json_str)
|
||
if not isinstance(data, dict) or "data" not in data or not isinstance(data["data"], list):
|
||
return ["错误：JSON 格式无效，缺少 'data' 数组或不是数组"]
|
||
|
||
# 提取模板中的字段名（形如 $field$）
|
||
fields = re.findall(r'\$([^\$]+)\$', template)
|
||
if not fields:
|
||
return ["错误：模板中未找到有效字段（格式如 $field$）"]
|
||
|
||
# 拼接结果
|
||
result = []
|
||
for item in data["data"]:
|
||
# 替换模板中的字段
|
||
formatted = template
|
||
for field in fields:
|
||
# 获取字段值，缺失时用 "N/A"
|
||
value = str(item.get(field, "N/A"))
|
||
formatted = formatted.replace(f"${field}$", value)
|
||
result.append(formatted)
|
||
|
||
# 返回拼接字符串
|
||
return [",".join(result)] if result else ["无有效数据"]
|
||
except json.JSONDecodeError:
|
||
return ["错误：无效的 JSON 字符串"]
|
||
except Exception as e:
|
||
return [f"错误：{str(e)}"] |