I am new to Zapier and trying to set-up my first zap. I got the Error Message; The app returned "Incorrect integer value: 'Birth Day26' for column 'birthday' at row 1" on my test case. What do I need to do to fix this?
Best answer by Troy Tessalone
View original
+14
Hi
Can you please provide screenshots of how your Zap steps are configured along with the error that is being returned, thanks.
These are the error messages that I’ve received. There may be a couple more that I deleted.
BannerSeason: Required field "Street Address" (street) is missing.
BannerSeason: Required field "First Name" (firstname) is missing
BannerSeason: Required field "Street Address" (street) is missing.
BannerSeason: The app returned "Incorrect integer value: 'Birth Day26' for column 'birthday' at row 1".
Thank you for your help.
The attachments on this post have been edited to remove private information. The Zapier Community is a public forum, please do not include private or personal information in your posts.
+14
For example, the Country field.
The mapped data point “Contact information: Country/Region” has ‘No data’, meaning when you try to manually test it will return an error since this is a (required) field that expects a value, so try to use a sample record from the trigger that has those data points populated.
You should remove the hardcoded “country” before the dynamic value.
Any field marked as (required) need to have a populated value, which is different than simply having a mapped value.
+11
Hi
Just circling back in here to check whether you saw Troy’s reply. Did you manage to get this working?
If you are still experiencing any issues, please let us know. We’re here to help!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
