Python3通过API批量导入主机到Infoblox失败问题排查

1. 核心问题 #

报错根源是请求体格式不匹配：

• 用requests.request()的data参数传递Python字典时，requests会自动将其编码为application/x-www-form-urlencoded格式的表单数据，但Infoblox API要求接收application/json格式的请求体，因此API无法解析，抛出JSON解码错误。
• 你之前写死的字符串payload是标准JSON格式，所以单条请求能正常执行；换成字典后用data传递就不符合API的格式要求了。

2. 修复后的单条循环代码 #

只需把data=payload替换为json=payload，requests会自动将字典序列化为JSON字符串，并正确适配API的格式要求：

import requests
import csv

# 补充你的Infoblox配置
url = "https://your-infoblox-wapi-url/wapi/v2.1/record:host"
username = "your-username"
password = "your-password"

with open("./ib/devices.csv","r") as f:
    csv_reader = csv.reader(f)
    # 跳过CSV表头（如果你的文件包含表头的话）
    next(csv_reader)
    for item in csv_reader:
        host = item[0]
        hostname = host + ".domain.com"
        ipv4 = item[1]
        payload = {"name": hostname,"ipv4addrs": [{"ipv4addr": ipv4}]}

        headers = {'content-type': "application/json"}
        # 关键修改：使用json参数传递请求体
        response = requests.request("POST", url, auth=(username, password), json=payload, headers=headers, verify=False)
        print(response.text)

3. 批量创建的优化方案 #

Infoblox WAPI支持一次性提交多条主机记录，无需循环调用API，能大幅提升效率：

import requests
import csv

url = "https://your-infoblox-wapi-url/wapi/v2.1/record:host"
username = "your-username"
password = "your-password"

host_records = []
with open("./ib/devices.csv","r") as f:
    csv_reader = csv.reader(f)
    next(csv_reader)  # 跳过表头
    for item in csv_reader:
        host = item[0]
        hostname = host + ".domain.com"
        ipv4 = item[1]
        host_records.append({
            "name": hostname,
            "ipv4addrs": [{"ipv4addr": ipv4}]
        })

# 批量提交请求，附加_return_fields参数可返回创建后的记录详情
response = requests.request(
    "POST", 
    f"{url}?_return_fields=name,ipv4addrs", 
    auth=(username, password), 
    json=host_records, 
    verify=False
)
print("批量创建结果：")
print(response.text)

批量方案的优势： #

• 减少HTTP请求次数，降低网络开销和API限流风险
• 统一处理所有记录的创建结果，便于后续校验和排查

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