Adding Null Values to Merge Columns for Attio API Integration

Garrett W. · 2026-01-18T02:58:09.121Z

is it possible to add a "null" value to a merge column to send null to Attio API instead of a empty value?

Adding Null Values to Merge Columns for Attio API Integration | Clay

10 comments

· Sorted by Oldest

Clay Support
APP
·
·
Based on our merge column functionality, you can create a formula that includes any columns you want to add with / syntax. [1] However, the documentation doesn't specifically cover how to explicitly send null values versus empty values to APIs through merge columns.
For HTTP API integrations, there's a "Remove empty fields from request" toggle that excludes empty, null, or undefined fields from your request to prevent overwriting existing data with blank values. [2] This suggests Clay handles null and empty values differently in API requests.
Could you share the specific JSON structure you're trying to send to the Attio API so I can help troubleshoot the merge column setup?
Clay Support
APP
·
·
If you still need help with sending null values to the Attio API through merge columns, I’m here to assist. Would you like to provide more details about the JSON structure or the specific issue you’re encountering?
Muhammad S.
·
·
yes, add a formula in the merge condition - return null if the /column is empty
Clay Support
APP
·
·
You can use a conditional formula in your merge column to return null for empty values. Try this formula structure:
IF(/column_name == "") THEN null ELSE /column_name
This checks if the column is empty and returns null instead of an empty string. [1]
When setting up the merge column, write your formula including the column reference with / and use the conditional logic to handle empty cases. [2] [3]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you need any more help with setting up your merge column formula or have other questions, I’m here to assist. Would you like to share more details about what you’re trying to achieve or any issues you’re facing?
Taimoor A.
·
·
use formula and write return empty if it null
1
Clay Support
APP
·
·
For the reverse case, use this formula structure:
IF(/column_name == null) THEN "" ELSE /column_name
This checks if the column is null and returns an empty string instead. [1] You can generate this formula using our AI Formula Generator by typing your instructions and using / to reference your column. [2]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help with your merge column formula or have any other questions, I’m here to assist. Would you like to provide more details about what you’re trying to resolve or understand?

Clay Support
APP
·
·
Based on our merge column functionality, you can create a formula that includes any columns you want to add with / syntax. [1] However, the documentation doesn't specifically cover how to explicitly send null values versus empty values to APIs through merge columns.
For HTTP API integrations, there's a "Remove empty fields from request" toggle that excludes empty, null, or undefined fields from your request to prevent overwriting existing data with blank values. [2] This suggests Clay handles null and empty values differently in API requests.
Could you share the specific JSON structure you're trying to send to the Attio API so I can help troubleshoot the merge column setup?
Clay Support
APP
·
·
If you still need help with sending null values to the Attio API through merge columns, I’m here to assist. Would you like to provide more details about the JSON structure or the specific issue you’re encountering?
Muhammad S.
·
·
yes, add a formula in the merge condition - return null if the /column is empty
Clay Support
APP
·
·
You can use a conditional formula in your merge column to return null for empty values. Try this formula structure:
IF(/column_name == "") THEN null ELSE /column_name
This checks if the column is empty and returns null instead of an empty string. [1]
When setting up the merge column, write your formula including the column reference with / and use the conditional logic to handle empty cases. [2] [3]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you need any more help with setting up your merge column formula or have other questions, I’m here to assist. Would you like to share more details about what you’re trying to achieve or any issues you’re facing?
Taimoor A.
·
·
use formula and write return empty if it null
1
Clay Support
APP
·
·
For the reverse case, use this formula structure:
IF(/column_name == null) THEN "" ELSE /column_name
This checks if the column is null and returns an empty string instead. [1] You can generate this formula using our AI Formula Generator by typing your instructions and using / to reference your column. [2]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help with your merge column formula or have any other questions, I’m here to assist. Would you like to provide more details about what you’re trying to resolve or understand?