PHP CodeIgniter 3对接NetSuite API创建供应商时地址簿字段无法保存问题

问题场景 #

使用PHP CodeIgniter 3对接NetSuite REST API创建供应商，API请求返回成功，供应商已创建，但地址未同步到NetSuite的「地址簿（Address Book）」板块。

预期行为 #

供应商地址应正常显示在NetSuite的地址簿板块。

实际行为 #

供应商创建成功，但地址簿中无任何地址信息，其他字段（如companyName、phone等）均可正常保存。

补充背景 #

• 已尝试添加NetSuite文档提及的override参数，问题未解决；
• 基于CodeIgniter 3开发。

当前请求载荷 #

$payload = [
    "companyName" => "Vendor Test for Address 103",
    "subsidiary" => $info['primary_subsidiary_id'],
    "category" => $info['product_category_id'],
    "defaultShippingAddress" => "9161",
    "email" => $info['supplier_email_address'],
    "phone" => "0917223333",
    "isperson" => $info['type'] == 1 ? false : true,
    "firstname" => $firstname,
    "lastname" => $lastname,
    "printOnCheckAs" => $info['print_check_on_as'],
    "custentity4" => 1,
    "defaultAddress" => "B13 L7 Walnt Street Calendola Village San Pedro, Laguna PH WF2",
    "addressBookCollection" => [
        "items" => [
            [
                "addressBookElement" => [
                    "defaultBilling" => "T",
                    "defaultShipping" => "F",
                    "addressBookAddress_text" => "1234 Main St San Pedro, Laguna 4023 PH WF2!",
                    "addressBookAddress" => [
                        "addr1" => "1234 Main St",
                        "addr2" => "Suite 101",
                        "city" => "Los Angeles",
                        "state" => "CA",
                        "zip" => "90001"
                    ]
                ]
            ]
        ]
    ]
];

问题原因与修复方案 #

你的请求载荷里的地址簿结构存在错误，NetSuite REST API对addressBookCollection的格式有严格要求，具体问题和修复点如下：

1. 多余的层级嵌套
   原payload中addressBookElement是冗余的嵌套层级，正确结构应直接在items数组的元素中定义defaultBilling、defaultShipping和addressBookAddress字段，无需包裹在addressBookElement内。

2. 布尔值格式错误
   defaultBilling和defaultShipping需传入布尔值true/false，而非字符串"T"/"F"。

3. 冗余字段干扰
   addressBookAddress_text是NetSuite自动生成的格式化地址文本，无需手动传入，手动赋值可能导致解析冲突，建议移除。

4. 无效的默认发货地址值
   defaultShippingAddress应对应地址簿中某条地址的内部ID，你传入的"9161"看起来是无效值，若无需设置默认发货地址可直接移除该字段，否则需确保值为有效地址ID。

修复后的请求载荷示例 #

$payload = [
    "companyName" => "Vendor Test for Address 103",
    "subsidiary" => $info['primary_subsidiary_id'],
    "category" => $info['product_category_id'],
    "email" => $info['supplier_email_address'],
    "phone" => "0917223333",
    "isperson" => $info['type'] == 1 ? false : true,
    "firstname" => $firstname,
    "lastname" => $lastname,
    "printOnCheckAs" => $info['print_check_on_as'],
    "custentity4" => 1,
    "addressBookCollection" => [
        "items" => [
            [
                "defaultBilling" => true,
                "defaultShipping" => false,
                "addressBookAddress" => [
                    "addr1" => "1234 Main St",
                    "addr2" => "Suite 101",
                    "city" => "Los Angeles",
                    "state" => "CA",
                    "zip" => "90001",
                    "country" => "US" // 建议添加国家字段，避免地址解析失败
                ]
            ]
        ]
    ]
];

额外注意事项 #

• 确保subsidiary字段的值为有效子公司ID，地址簿的保存依赖正确的子公司关联；
• 若NetSuite账户启用多地址验证，需确保addressBookAddress中的字段（如country、state）符合系统值格式；
• 可通过NetSuite REST API浏览器验证请求结构，确保字段名和格式完全匹配。

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