如何处理JSON中的缺失数据以获得合规有效的JSON结构？

首先明确：包含null值的JSON本身就是格式合法的，JSON规范允许用null表示缺失或未定义的值。如果业务场景可以接受null，直接保留即可，无需修改。

如果需要对这些null值做处理，以下是几种常见方案：

一、移除含null值的字段 #

若要剔除所有值为null的字段，可通过编程语言的JSON工具递归遍历处理，以下是主流语言的实现示例：

Python实现 #

import json

# 修正示例JSON的语法错误（原示例中"hash":"${hash}":"Service.Application"应为"hash":"${hash}","type":"Service.Application"）
raw_json = '''{"action":"executeaction","params":{"actionname":"Service.ACT_Show_LanguagePage","applyto":"selection","guids":"${guid}"},"changes":{},"objects":[{"attributes":{"PassportType":{"value":null},"AppType":{"readonly":true,"value":null},"AppDate":{"readonly":true,"value":null},"PayTime":{"value":null},"Service.Application_CaptchaImage":{"readonly":true,"value":null},"Relation":{"value":null},"IsCaptchaMatched":{"readonly":true,"value":false},"LOV.GeneralInstructions_Application":{"readonly":true,"value":null},"TotalFees":{"readonly":true,"value":null},"Service.Application_Person_Guardian":{"readonly":true,"value":null},"EndorsementInd":{"value":false},"Service.PaymentOrder_Application":{"readonly":true,"value":null},"Service.Barcode_Application":{"readonly":true,"value":null},"AppNo":{"readonly":true,"value":null},"Service.FormDocument_Application":{"readonly":true,"value":null},"FeesPaid":{"readonly":true,"value":"No"},"Service.Application_Person":{"value":null},"RenewReason":{"value":null},"Accredited":{"readonly":true,"value":false},"ServiceCategory":{"value":null},"IsApproved":{"value":false},"ApplicantAge":{"value":"0"},"SubmittedLocation":{"value":null},"Service.Application_Instrument":{"value":null},"LOV.SupportingDocuments_Application":{"readonly":true,"value":null},"PaymentMethod":{"readonly":true,"value":null},"CaptchaInput":{"value":null}},"guid":"${guid}","hash":"${hash}","type":"Service.Application"}],"context":[],"profiledata":{"1673510999499-1":61,"1673510999884-2":24,"1673510999911-3":12}}'''
data = json.loads(raw_json)

# 递归移除值为null的字段
def remove_null_fields(obj):
    if isinstance(obj, dict):
        return {k: remove_null_fields(v) for k, v in obj.items() if v is not None and (not isinstance(v, dict) or remove_null_fields(v) != {})}
    elif isinstance(obj, list):
        return [remove_null_fields(item) for item in obj if item is not None]
    else:
        return obj

cleaned_data = remove_null_fields(data)
cleaned_json = json.dumps(cleaned_data, indent=2)
print(cleaned_json)

JavaScript实现 #

// 修正语法错误后的原始JSON
const rawJson = `{"action":"executeaction","params":{"actionname":"Service.ACT_Show_LanguagePage","applyto":"selection","guids":"${guid}"},"changes":{},"objects":[{"attributes":{"PassportType":{"value":null},"AppType":{"readonly":true,"value":null},"AppDate":{"readonly":true,"value":null},"PayTime":{"value":null},"Service.Application_CaptchaImage":{"readonly":true,"value":null},"Relation":{"value":null},"IsCaptchaMatched":{"readonly":true,"value":false},"LOV.GeneralInstructions_Application":{"readonly":true,"value":null},"TotalFees":{"readonly":true,"value":null},"Service.Application_Person_Guardian":{"readonly":true,"value":null},"EndorsementInd":{"value":false},"Service.PaymentOrder_Application":{"readonly":true,"value":null},"Service.Barcode_Application":{"readonly":true,"value":null},"AppNo":{"readonly":true,"value":null},"Service.FormDocument_Application":{"readonly":true,"value":null},"FeesPaid":{"readonly":true,"value":"No"},"Service.Application_Person":{"value":null},"RenewReason":{"value":null},"Accredited":{"readonly":true,"value":false},"ServiceCategory":{"value":null},"IsApproved":{"value":false},"ApplicantAge":{"value":"0"},"SubmittedLocation":{"value":null},"Service.Application_Instrument":{"value":null},"LOV.SupportingDocuments_Application":{"readonly":true,"value":null},"PaymentMethod":{"readonly":true,"value":null},"CaptchaInput":{"value":null}},"guid":"${guid}","hash":"${hash}","type":"Service.Application"}],"context":[],"profiledata":{"1673510999499-1":61,"1673510999884-2":24,"1673510999911-3":12}}`;
const data = JSON.parse(rawJson);

// 递归移除值为null的字段
function removeNullFields(obj) {
  if (typeof obj === 'object' && obj !== null) {
    if (Array.isArray(obj)) {
      return obj.map(item => removeNullFields(item)).filter(item => item !== null && Object.keys(item).length !== 0);
    } else {
      return Object.fromEntries(
        Object.entries(obj)
          .map(([k, v]) => [k, removeNullFields(v)])
          .filter(([k, v]) => v !== null && (typeof v !== 'object' || Object.keys(v).length !== 0))
      );
    }
  }
  return obj;
}

const cleanedData = removeNullFields(data);
const cleanedJson = JSON.stringify(cleanedData, null, 2);
console.log(cleanedJson);

二、替换null为业务默认值 #

如果需要将null替换为符合业务逻辑的默认值（比如空字符串""、数字0、布尔值false等），可通过递归遍历实现：

Python示例（替换所有value: null为空字符串） #

def replace_null_with_default(obj, default=""):
    if isinstance(obj, dict):
        for k, v in obj.items():
            if v is None:
                obj[k] = default
            else:
                replace_null_with_default(v, default)
        return obj
    elif isinstance(obj, list):
        return [replace_null_with_default(item, default) for item in obj]
    else:
        return obj

filled_data = replace_null_with_default(data.copy(), default="")
filled_json = json.dumps(filled_data, indent=2)
print(filled_json)

三、关键注意事项 #

• 优先确认业务需求：是保留null、移除还是替换，不同场景选择对应方案。
• 处理嵌套结构：示例JSON存在多层嵌套，必须用递归遍历才能覆盖所有层级的字段。
• 修正原始JSON语法错误：你提供的示例中"hash":"${hash}":"Service.Application"存在语法问题，需改为"hash":"${hash}","type":"Service.Application"才能正常解析。

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