CODEWITHSUNDEEP
pythonodooodoo-10
Andy
Andy

Reputation: 31

Odoo External API Search and read not working

Currently, I am working with external API but the code in odoo website "https://www.odoo.com/documentation/11.0/webservices/odoo.html" is not working for me.

from xmlrpc import client

username = "admin"

pwd = "admin"

dbname = "testim17-11-19"

comp =0

sock_common = client.ServerProxy("http://localhost:8075/xmlrpc/common")

uid = sock_common.login(dbname, username, pwd)

sock = client.ServerProxy("http://localhost:8075/xmlrpc/object")

sock.execute_kw(dbname, uid, pwd,
'res.partner', 'search_read',
[[['is_company', '=', True], ['customer', '=', True]]],
{'fields': ['name', 'country_id', 'comment'], 'limit': 5})

But i get this error:

Traceback (most recent call last):
  File "get_csv2.py", line 20, in <module>
    {'fields': ['name', 'country_id', 'comment'], 'limit': 5})
  File "C:\Program Files (x86)\Python37-32\lib\xmlrpc\client.py", line 1112, in __call__
    return self.__send(self.__name, args)
  File "C:\Program Files (x86)\Python37-32\lib\xmlrpc\client.py", line 1452, in __request
    verbose=self.__verbose
  File "C:\Program Files (x86)\Python37-32\lib\xmlrpc\client.py", line 1154, in request
    return self.single_request(host, handler, request_body, verbose)
  File "C:\Program Files (x86)\Python37-32\lib\xmlrpc\client.py", line 1170, in single_request
    return self.parse_response(resp)
  File "C:\Program Files (x86)\Python37-32\lib\xmlrpc\client.py", line 1342, in parse_response
    return u.close()
  File "C:\Program Files (x86)\Python37-32\lib\xmlrpc\client.py", line 656, in close
    raise Fault(**self._stack[0])
xmlrpc.client.Fault: <Fault ERREUR:  l'opérateur n'existe pas : integer = boolean
LINE 1: SELECT COALESCE(password, '') FROM res_users WHERE id=false
                                                             ^
HINT:  Aucun opérateur ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.
: 'Traceback (most recent call last):\n  File "c:\\program files (x86)\\odoo 12.0\\server\\odoo\\addons\\base\\controllers\\rpc.py", line 54, in xmlrpc_1\n    response = self._xmlrpc(service)\n  File "c:\\program files (x86)\\odoo 12.0\\server\\odoo\\addons\\base\\controllers\\rpc.py", line 43, in _xmlrpc\n    result = dispatch_rpc(service, method, params)\n  File "C:\\Program Files (x86)\\Odoo 12.0\\server\\odoo\\http.py", line 120, in dispatch_rpc\n    result = dispatch(method, params)\n  File "C:\\Program Files (x86)\\Odoo 12.0\\server\\odoo\\service\\model.py", line 35, in dispatch\n    security.check(db,uid,passwd)\n  File "C:\\Program Files (x86)\\Odoo 12.0\\server\\odoo\\service\\security.py", line 16, in check\n    return res_users.check(db, uid, passwd)\n  File "c:\\program files (x86)\\odoo 12.0\\server\\odoo\\addons\\base\\models\\res_users.py", line 612, in check\n    self._check_credentials(passwd)\n  File "c:\\program files (x86)\\odoo 12.0\\server\\odoo\\addons\\base\\models\\res_users.py", line 309, in _check_credentials\n    [self.env.user.id]\n  File "C:\\Program Files (x86)\\Odoo 12.0\\server\\odoo\\sql_db.py", line 148, in wrapper\n    return f(self, *args, **kwargs)\n  File "C:\\Program Files (x86)\\Odoo 12.0\\server\\odoo\\sql_db.py", line 225, in execute\n    res = self._obj.execute(query, params)\npsycopg2.ProgrammingError: ERREUR:  l\'opérateur n\'existe pas : integer = boolean\nLINE 1: SELECT COALESCE(password, \'\') FROM res_users WHERE id=false\n                                                             ^\nHINT:  Aucun opérateur ne correspond au nom donné et aux types d\'arguments.\nVous devez ajouter des conversions explicites de type.\n\n'>

Upvotes: 1

Views: 1098

Answers (1)

Andy
Andy

Reputation: 31

The error was that I write a wrong username, so the uid give False. I fixed it and it work perfectly.

uid = sock_common.login(dbname, username, pwd)
print(uid)

Upvotes: 1

Related Questions