Error has just start to occur the last couple of weeks. We have a fairly basic application form in Formidable Form and Zapier seems to think its an image datatype when it should be an nvarchar.
This is the error:
The app returned "(pyodbc.DataError) ('22018', ' 22018] ]FreeTDS]SSQL Server]Operand type clash: image is incompatible with nvarchar(max) (206) (SQLParamData)')".
Any ideas?
Hi!
Were you able to find a solution to this?
Having the same issue
It looks like the error is happening because Zapier is trying to send a file (like an image) into a text field in your database. Usually, this happens when a file upload field is used in a form, and Zapier sends the file itself instead of just the URL or filename.
To fix it, check your Zap and make sure you're passing plain text (like a file URL) into your SQL field—not the file or image object. You might need to adjust the field mapping in your Zap or use a formatter step to extract just the text you need.
Let me know if that helps or if you want me to take a quick look!
Sounds like it was an issue Zapier end and it seems to be fixed now.
Hi
Thank you for confirming that the issue is already resolved. This will help our members with the same issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.