TryCF Gist

trycf-gist-1713507207364-e345be80-3008-d90b-ab4c-9c75093cf7de.cfm

<cfscript>
    function ConvertEmptyStringKeyValueToNull(data) {
         if (isStruct(arguments.data)) {
            for (local.key in arguments.data) {
                arguments.data[local.key] = ConvertEmptyStringKeyValueToNull(arguments.data[local.key]);
            }
        } else if (isArray(arguments.data)) {
            for (local.i = 1; local.i <= arrayLen(arguments.data); local.i++) {
                arguments.data[local.i] = ConvertEmptyStringKeyValueToNull(arguments.data[local.i]);
            }
        } else if (arguments.data eq "") {
            arguments.data = javaCast("null", "");
            writedump(arguments);abort;
        }
        return arguments.data;
}
</cfscript>


<!-- Sample data -->
<cfset data = {
    name = "",
    age = 25,
    address = {
        street = "",
        city = "New York",
        zip = ""
    },
    contacts = [
        { type = "email", value = "" },
        { type = "phone", value = "123-456-7890" }
    ]
}>

<!-- Convert empty strings to null -->
<cfset updatedData = ConvertEmptyStringKeyValueToNull(data)>

<!-- Display the updated data -->
<cfdump var="#updatedData#">