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][SQL Server]Operand type clash: image is incompatible with nvarchar(max) (206) (SQLParamData)')".
Any ideas?
Best answer by Ian Davies
Sounds like it was an issue Zapier end and it seems to be fixed now.
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!
+6Hi
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.
