is it possible to add a "null" value to a merge column to send null to Attio API instead of a empty value?
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?
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?
yes, add a formula in the merge condition - return null if the /column is empty
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]
Is that what you were looking for?
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?
For the reverse case, use this formula structure:
IF(/column_name == null) THEN "" ELSE /column_name
Did that answer your question?
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?
