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.

I’m pulling donation data from Givebutter into Salesforce with these two steps:

  1. Webhook: https://api.givebutter.com/v1/transactions/{transaction_ID}
  2. Formatter (Line-item to Text) 

When all the custom fields are filled in on the donation form, all is good in Salesforce, but when some fields are not, things get out of alignment. Here’s what it looks like. I’ve added blue column headers to clarify what they are, and blurred the last 4 digits of phone numbers (framed in red).

The 4 rows framed in green are the only ones where all custom fields were filled in.

Any thoughts?  Thanks.

This post has been edited by a moderator to remove personally identifiable information (PII). Please remember that this is a public forum and avoid sharing personal or potentially sensitive details.

Hi ​@Scott_HANT 

For us to have more context about what you are referring to, post screenshots showing:

  • how your Zap steps are outlined
  • how your Zap steps are configured in the CONFIGURE tab in EDIT mode with the field mappings visible

Hey ​@Scott_HANT,

It’s happening because when there are missing fields in the form, the data changes in the Webhook and as you are applying a simple formatter line item to text, it doesn’t take into account those changes and maps them incorrectly in Salesforce. 

If you are not to able to map the values directly from Webhook data, you may want to look into Code by Zapier action to normalize the response so that you can map a key to the data rather than relying on the position of the data. See more about Code by Zapier action here- https://zapier.com/blog/code-by-zapier-guide/. You can also try to do this using Formatter → Utilities → Pick from list or text to line items but it might require multiple Zap steps depending on the data. Hope it helps!

Hey ​@Scott_HANT, just checking in 👋 Did Sparsh’s reply help to point you in the right direction?

Let us know how it goes, want to make sure this gets sorted. 🙂

Terms & ConditionsAccessibility statement