How to Push Incomplete Contacts to Zoho CRM Using Zapier

Hi, I am runngin http api with zapier to push contacts into our CRM (Zoho), however, some of the cells in clay table are missing, such as no phone number available or no city..etc. but you still want to push them with the zap. I'm getting some inputs missing, how do I instruct clay to push it still without those data?

16 comments

Channeled
APP
·
·
To push data from Clay to your CRM via Zapier even with missing information, you can use the HTTP API enrichment in Clay. Here's how: 1. Set up a Zapier webhook to receive data from Clay. 2. In your Clay table, add a new HTTP API enrichment. 3. Set the Method to POST and use the Zapier webhook URL as the endpoint. 4. In the "Body" section, format your data as JSON, including all fields you want to send, even if some are empty. 5. Use dynamic column names to ensure each row is sent separately. If you're experiencing any JSON formatting issues, please copy and paste your JSON into the chat so we can troubleshoot further. Remember, you can conditionally add only new contacts to prevent duplicates in your CRM. Consider setting up a check for existing contacts before adding new ones to maintain clean data.
Sources: Guide: How to send your Clay table data to Zapier with HTTP API Push Data To Your CRM [Clay 101] - Clay University
Louie
·
·
Do you have a sample JSON code?
Channeled
APP
·
·
Here's a sample JSON code for pushing data from Clay to a CRM via Zapier, including handling missing fields: LBKS{ "email": "{{email}}", "firstName": "{{first_name}}", "lastName": "{{last_name}}", "company": "{{company}}", "phone": "{{phone}}", "city": "{{city}}" }LBKSThis format allows you to send data even if some fields are missing. Clay will automatically handle empty fields, so you don't need to worry about them. If you're experiencing any JSON formatting issues, please copy and paste your exact JSON into the chat so we can troubleshoot further.
Source: Guide: How to send your Clay table data to Zapier with HTTP API
Louie
·
·
Here's the screenshot of the body
Channeled
APP
·
·
To format your JSON body correctly for pushing data from Clay to your CRM via Zapier, even with missing fields: 1. Use double quotes for keys and string values. 2. Don't use quotes for numbers or booleans. 3. Include all fields you want to send, even if some are empty. 4. Use dynamic column names with double curly braces. Here's a sample format: LBKS{ "email": "{{email}}", "firstName": "{{first_name}}", "lastName": "{{last_name}}", "company": "{{company}}", "phone": "{{phone}}", "age": {{age}} }LBKSClay will handle empty fields automatically. If you're still experiencing issues, please copy and paste your exact JSON into the chat so we can troubleshoot further.
Sources: HTTP API with Clay HTTP API with JWT authentication | Documentation | Clay University
Louie
·
·
not getting body error,
Louie
·
·
{ "First_Name":" Firstname ", "Last_Name":" Lastname ", "LinkedIn_Url":"{{ linkedin_url "}}, "Company": " Company Name ", "Domain": " Domain ", "Job_Title":"{{ title }}", "Email":"{{ Work Email (Enterprise) }}", "Mobile_Phone":"{{ Mobile Phone (Global) }}", "Country":"{{ Country }}", "City":"{{ City }}", "State":"{{ States }}" }
Summiya B.
·
·
Louie in your HHT API body section hover over to the mobile phone global and city also keep it off . So when you turn it on it needs to have a value for all of them? And when off it will use for wherever the info is available? so it will continue run if someinput is missing.
Summiya B.
·
·
👍1
Louie
·
·
Weird, issue keeps reoccuring, this time it's different, Failed to parse formula for "body" with error: {"offset":60,"token":{"value":"["}}
Summiya B.
·
·
Share screen shot of the body
Daniel K.
·
·
Hey there, sorry for the delay! Could you try reverting to your old JSON body? You can toggle off any inputs that don’t need to be pushed directly within the prompt by switching the toggle off. Let me know if that resolves it—if not, feel free to share your table, and I’d be happy to take a look!
Daniel K.
·
·
(273 kB)
Louie
·
·
I reverted it back and it fixed it
Channeled
APP
·
·
Channeled
APP
·
·
Thank you so much for sharing your feedback Louie!