Hi there @blocktec,

Welcome to the Community!

Before we dig deeper into this, would you mind sharing some additional information? It would be really helpful if you could provide a detailed screenshot of how your Zap is configured. Additionally, if you could include a screenshot of the error message and the specific step where you're encountering the error, that would be great! This will allow us to better understand the issue and provide you with the most accurate assistance.

Thanks! 

Im connecting chatbot to Odoo Self Hosted CRM. I successfully connected the chatbot but there’s an error on Odoo Self Hosted CRM. 

The error:

Fault (code operator does not exist: integer = boolean LINE 1: SELECT COALESCE(password, '') FROM res_users WHERE id=false ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. ) occurred. Message: Traceback (most recent call last): File "/opt/odoo12/odoo/odoo/addons/base/controllers/rpc.py", line 60, in xmlrpc_1 response = self._xmlrpc(service) File "/opt/odoo12/odoo/odoo/addons/base/controllers/rpc.py", line 49, in _xmlrpc result = dispatch_rpc(service, method, params) File "/opt/odoo12/odoo/odoo/http.py", line 120, in dispatch_rpc result = dispatch(method, params) File "/opt/odoo12/odoo/odoo/service/model.py", line 36, in dispatch security.check(db,uid,passwd) File "/opt/odoo12/odoo/odoo/service/security.py", line 16, in check return res_users.check(db, uid, passwd) File "/opt/odoo12/odoo/odoo/addons/base/models/res_users.py", line 663, in check self._check_credentials(passwd) File "/opt/odoo12/odoo/odoo/addons/base/models/res_users.py", line 312, in _check_credentials self.env.cr.execute( File "/opt/odoo12/odoo/odoo/sql_db.py", line 148, in wrapper return f(self, *args, **kwargs) File "/opt/odoo12/odoo/odoo/sql_db.py", line 225, in execute res = self._obj.execute(query, params) psycopg2.errors.UndefinedFunction: operator does not exist: integer = boolean LINE 1: SELECT COALESCE(password, '') FROM res_users WHERE id=false ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

Hi @blocktec,

It seems like the issue you're experiencing could be connected to the version of Odoo you're using. Our current support extends up to version 7. Are you perhaps using a higher version? If so, please let me know, and I'll gladly include you in our feature request to add support for version 8 and above.

Please keep us posted! 

We are using this version. Thank you @ken.a !

Hi @blocktec,

Thank you for the screenshot!

It looks like any version from 8 onwards is not yet supported by the Zapier Odoo integration. It's something other users have asked for and is currently logged as a Feature request. What I've done is added your vote for this Feature request. That does a few things:

• Bring this to the attention of the integration developers
• Help track interest in this feature being implemented
• Allows us to notify you via email if this feature becomes available in the future

While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!

I apologize if we don’t support Odoo version 8 above at the moment. If you have any other questions, please don’t hesitate to ask in the Community. We’re always happy to help!