Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Checkbox value true/false json webhook

J

I’m setting up a webhook from an Unbounce form to our CRM. I’m able to all our standard information from the form into the CRM except a checkbox asking if someone opts into marketing materials. The CRM API works with json and only accepts values for that opt-in field as true/false. I tried two different set ups.

Adding the data as I would normally thinking that it would automatically send it as true/false since there is only one box. However, the value isn’t considered true but the value of the checkbox itself. 

 

I then tried the Formatter by Zapier to change the value of the checkbox field. I set it up as a Utility and then selected Lookup Table. I put the full checkbox answer in the left and true on the right.  

 

From there, I was able to add the Formatter field to the webhook and the value does say true. Yet, it will not load in the CRM. 

 

Any help would be greatly appreciated! 

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @jordanjacoby 

We would need the link to the CRM API endpoint docs you are referencing as well as more screenshots that show how your entire Webhook Zap step is configured. (e.g. Method, URL, Headers)

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

Ok update - The field was not published for the API and it’s now pushing through however it’s causing a 400 error of “Illegal assignment from string to Boolean.” The last issue I’m running into is the formatting of that text opt-in field. The value needs to be true without quotes but the webhook is sending it with quotes as a string. The rest of the data is loading correctly with the quotes, as a string.

 

Method is POST with headers of Content-Type:Application/JSON. Here’s a section of the API Instructions:

 

I have the value in the Formatter as true but I’m wondering, do I need to set it up differently so it’s not a value creating a string or is there a way to modify that specific value so it isn’t a string? 

 

 

Sorry, not a developer, just a marketing person so I have limited knowledge on the subject. I’m connecting into a Salesforce based platform.

 

Here’s the screenshot of the log: 

 

Troy Tessalone
Forum|alt.badge.img+14

@jordanjacoby 

There are quotes around the “true”, but it expects without quotes like this.

 

You may want to try creating a custom action with the help of AI.

 

Otherwise, you can use a Custom Request to do the HTTP request and use JSON to format the Body Data.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

Thank you! I was able to achieve it with the Custom Request. 

Troy Tessalone
1 person likes this
  • Troy Tessalone
    Troy Tessalone
Terms & Conditions