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
Error Message; The app returned "Incorrect integer value: 'Birth Day26' for column 'birthday' at row 1". What does this mean?W
- Beginner
Best answer by Troy Tessalone
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.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
Can you please provide screenshots of how your Zap steps are configured along with the error that is being returned, thanks.
- Beginner
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- Zapier Orchestrator & Solution Partner
- Answer
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- Community Manager
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 E-mail address. We'll send you an e-mail with instructions to reset your password.