Matthew A.

DONE 🤙

You can close this. I've figured it out.

What do I select with the yellow caution triangles?

WOW... I'll try this right now.

I have to force a value such as N/A or no@searchresults.com as an empty email address. I shouldn't have to do this with "Remove empty values" checked.

It works.. However, if there's a blank COLUMN in a particular row, I want the rest of the data to still be sent. The "Remove empty values" doesn't work as it's supposed to. I should be able to do normal JSON and if a work phone is missing, but I found a mobile phone, the API should still push to Zapier even with the work phone missing.

There are many times when I might have a BLANK column of data on a specific row, and I still want the API to write the rest of the existing data. Right now I have the following: 'no@searchresults.com') + "\",\n \"Alternate_Email_1\": \"" + Clay.formatForJSON({{Alternate Email 1}} || If an email doesn't exist, I don't want to be forced to write no@searchresults.com just to get the API to write. Does that make sense?

https://app.clay.com/workspaces/428660/tables/t_0swf2fdSpcvRY7qAq8p/views/gv_w9Z4Ks58pKKC