Clay Icon

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?

  • Avatar of Channeled
    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.

  • Avatar of Louie
    Louie
    ·
    ·

    Do you have a sample JSON code?

  • Avatar of Channeled
    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.

  • Avatar of Louie
    Louie
    ·
    ·

    Here's the screenshot of the body

  • Avatar of Channeled
    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.

  • Avatar of Louie
    Louie
    ·
    ·

    not getting body error,

  • Avatar of Louie
    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 }}" }

  • Avatar of Summiya B.
    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.

  • Avatar of Summiya B.
    Summiya B.
    ·
    ·
  • Avatar of Louie
    Louie
    ·
    ·

    Weird, issue keeps reoccuring, this time it's different, Failed to parse formula for "body" with error: {"offset":60,"token":{"value":"["}}

  • Avatar of Summiya B.
    Summiya B.
    ·
    ·

    Share screen shot of the body

  • Avatar of Daniel K.
    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!

  • Avatar of Daniel K.
    Daniel K.
    ·
    ·
    (273 kB)
    Image
  • Avatar of Louie
    Louie
    ·
    ·

    I reverted it back and it fixed it

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·
  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback ​Louie​!