Odoo RESTFUL API

I have win10 and Odoo12 on it, I can't found your app on the app store on Odoo, I tried to download your app/ put it into C:\Program Files (x86)\Odoo 12.0\server\addons /restart my Odoo server and activate developer mode but nothing happens.

I have followed your exact code from your Github post and ran it. I can authenticate perfectly, but when I do a search read, I always get all database lines from that particular model in return. The limit field doesn't work, etc. Odoo 12 Enterprise. What to do?

When I'm doing a PUT request is having an issue because all the fields are taken as strings and we have this output Database fetch misses ids (('2',)) and has extra ids ((2,)), may be caused by a type incoherence in a previous request"}

Traceback (most recent call last): File "/home/surendra/isha/sushumna/odoo/odoo/service/wsgi_server.py", line 142, in application return application_unproxied(environ, start_response) File "/home/surendra/isha/sushumna/odoo/odoo/service/wsgi_server.py", line 117, in application_unproxied result = odoo.http.root(environ, start_response) File "/home/surendra/isha/sushumna/odoo/odoo/http.py", line 1281, in __call__ return self.dispatch(environ, start_response) File "/home/surendra/isha/sushumna/odoo/odoo/http.py", line 1251, in __call__ return self.app(environ, start_wrapped) File "/home/surendra/isha/sushumna/env/lib/python3.7/site-packages/werkzeug/wsgi.py", line 766, in __call__ return self.app(environ, start_response) File "/home/surendra/isha/sushumna/odoo/odoo/http.py", line 1450, in dispatch result = ir_http._dispatch() File "/home/surendra/isha/sushumna/odoo/addons/auth_signup/models/ir_http.py", line 19, in _dispatch return super(Http, cls)._dispatch() File "/home/surendra/isha/sushumna/odoo/addons/web_editor/models/ir_http.py", line 22, in _dispatch return super(IrHttp, cls)._dispatch() File "/home/surendra/isha/sushumna/odoo/addons/http_routing/models/ir_http.py", line 516, in _dispatch result = super(IrHttp, cls)._dispatch() File "/home/surendra/isha/sushumna/odoo/odoo/addons/base/models/ir_http.py", line 233, in _dispatch return cls._handle_exception(e) File "/home/surendra/isha/sushumna/odoo/addons/http_routing/models/ir_http.py", line 607, in _handle_exception return super(IrHttp, cls)._handle_exception(exception) File "/home/surendra/isha/sushumna/odoo/odoo/addons/base/models/ir_http.py", line 198, in _handle_exception raise exception File "/home/surendra/isha/sushumna/odoo/odoo/addons/base/models/ir_http.py", line 229, in _dispatch result = request.dispatch() File "/home/surendra/isha/sushumna/odoo/odoo/http.py", line 803, in dispatch r = self._call_function(**self.params) File "/home/surendra/isha/sushumna/odoo/odoo/http.py", line 345, in _call_function return checked_call(self.db, *args, **kwargs) File "/home/surendra/isha/sushumna/odoo/odoo/service/model.py", line 93, in wrapper return f(dbname, *args, **kwargs) File "/home/surendra/isha/sushumna/odoo/odoo/http.py", line 338, in checked_call result = self.endpoint(*a, **kw) File "/home/surendra/isha/sushumna/odoo/odoo/http.py", line 909, in __call__ return self.method(*args, **kw) File "/home/surendra/isha/sushumna/odoo/odoo/http.py", line 510, in response_wrap response = f(*args, **kw) File "/home/surendra/isha/sushumna/custom_addons/restful/controllers/token.py", line 94, in token access_token = _token.find_one_or_create_token(user_id=uid, create=True) File "/home/surendra/isha/sushumna/custom_addons/restful/models/access_token.py", line 50, in find_one_or_create_token access_token = self.env["api.access_token"].sudo().create(vals) File "", line 2, in create File "/home/surendra/isha/sushumna/odoo/odoo/api.py", line 343, in _model_create_multi return create(self, [arg]) File "/home/surendra/isha/sushumna/odoo/odoo/models.py", line 3666, in create vals = self._add_missing_default_values(vals) File "/home/surendra/isha/sushumna/odoo/odoo/models.py", line 1731, in _add_missing_default_values defaults = self.default_get(list(missing_defaults)) File "/home/surendra/isha/sushumna/odoo/odoo/models.py", line 1179, in default_get ir_defaults = self.env['ir.default'].get_model_defaults(self._name) File "", line 2, in get_model_defaults File "/home/surendra/isha/sushumna/odoo/odoo/tools/cache.py", line 90, in lookup value = d[key] = self.method(*args, **kwargs) File "/home/surendra/isha/sushumna/odoo/odoo/addons/base/models/ir_default.py", line 144, in get_model_defaults cr.execute(query, params) File "/home/surendra/isha/sushumna/odoo/odoo/sql_db.py", line 163, in wrapper return f(self, *args, **kwargs) File "/home/surendra/isha/sushumna/odoo/odoo/sql_db.py", line 240, in execute res = self._obj.execute(query, params) psycopg2.ProgrammingError: operator does not exist: integer = boolean LINE 6: ... AND (d.company_id IS NULL OR d.company_id=false) ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

Hi, I'm getting the following error while getting the token using the below api. curl -X GET http://localhost:8069/api/auth/token -H 'cache-control: no-cache' -H 'charset: utf-8' -H 'content-type: application/x-www-form-urlencoded' -H 'postman-token: 98010ca0-2f81-52e5-91c1-3985761d9903' -d 'login=admin&password=admin&db=odoo' It is internally generating a bad SQL query like the below. Any help is appreciated. 2019-12-28 10:40:40,553 20407 ERROR odoo odoo.sql_db: bad query: SELECT f.name, d.json_value FROM ir_default d JOIN ir_model_fields f ON d.field_id=f.id WHERE f.model='api.access_token' AND (d.user_id IS NULL OR d.user_id=NULL) AND (d.company_id IS NULL OR d.company_id=false) AND d.condition IS NULL ORDER BY d.user_id, d.company_id, d.id Full stack trace below.

mail.message model POST request show 401UNAUTHORIZED. I send access-token correctly. so, I am not able to post message via mail.message model.

hi bro @ajepe how to fixed { "jsonrpc": "2.0", "id": null, "error": { "code": 200, "message": "Odoo Server Error", "data": { "name": "werkzeug.exceptions.BadRequest", "debug": "Traceback (most recent call last):\n File \"/usr/lib/python3/dist-packages/odoo/http.py\", line 653, in _handle_exception\n return super(JsonRequest, self)._handle_exception(exception)\n File \"/usr/lib/python3/dist-packages/odoo/http.py\", line 312, in _handle_exception\n raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])\n File \"/usr/lib/python3/dist-packages/odoo/tools/pycompat.py\", line 87, in reraise\n raise value\n File \"/usr/lib/python3/dist-packages/odoo/http.py\", line 695, in dispatch\n result = self._call_function(**self.params)\n File \"/usr/lib/python3/dist-packages/odoo/http.py\", line 320, in _call_function\n raise werkzeug.exceptions.BadRequest(msg % params)\nwerkzeug.exceptions.BadRequest: 400 Bad Request: , /api/res.partner/: Function declared as capable of handling request of type 'http' but called with a request of type 'json'\n", "message": "400 Bad Request: , /api/res.partner/: Function declared as capable of handling request of type 'http' but called with a request of type 'json'", "arguments": [], "exception_type": "internal_error" } } } i'm use odoo 11 and testing use postman, only GET cant call, parameter json { "limit" : 10, "domain":[ { }, { } ], "order":"name asc", "offset":"10" } please help me bro

I used this model in odoo12 enterprise version, in the "/api/product.template" API, I always got the "image": null, "image_medium": null, "image_small": null,

Hello Ajepe, I have an issue with *2many fields when I create new records. I used the same example in the module documentation. """Create a new record. Basic sage: import requests headers = { 'content-type': 'application/x-www-form-urlencoded', 'charset': 'utf-8', 'access-token': 'access_token' } data = { 'name': 'Babatope Ajepe', 'country_id': 105, 'child_ids': [ { 'name': 'Contact', 'type': 'contact' }, { 'name': 'Invoice', 'type': 'invoice' } ], 'category_id': [{'id': 9}, {'id': 10}] } req = requests.post('%s/api/res.partner/' % base_url, headers=headers, data=data) """ The record is created but child_ids and category_id are not there.

have you an example with java code please that use restfull api

who can help me how to use this modul .. some steps useful .. thank you

req = requests.get('{}/api/crm.lead'.format(base_url), headers=headers, data={'limit': 1, 'domain': []}) ``` File "/media/ricardo/Dados/Codidos/Python/odoo/custom_addons/restful/common.py", line 22, in valid_response response=json.dumps(data, default=datetime.datetime.isoformat), File "/media/ricardo/Dados/Codidos/Python/odoo/venv/lib/python3.5/site-packages/simplejson/__init__.py", line 399, in dumps **kw).encode(obj) File "/media/ricardo/Dados/Codidos/Python/odoo/venv/lib/python3.5/site-packages/simplejson/encoder.py", line 296, in encode chunks = self.iterencode(o, _one_shot=True) File "/media/ricardo/Dados/Codidos/Python/odoo/venv/lib/python3.5/site-packages/simplejson/encoder.py", line 378, in iterencode return _iterencode(o, 0) TypeError: descriptor 'isoformat' requires a 'datetime.datetime' object but received a 'datetime.date' - - - ```

Object of type datetime is not JSON serializable error is now fixed

Hello Ajepe, I got an error after url/api/res.partner search: File "/odoo/custom/addons/restful/controllers/main.py", line 26, in wrap "access_token_not_found", "missing access token in request header", 401 File "/odoo/custom/addons/restful/common.py", line 33, in invalid_response response=json.dumps( NameError: name 'json' is not defined - - - Please help to sort this issue? My regards.

This is work for me

Here is the answer for the previous issue: https://stackoverflow.com/questions/45466814/odoo-url-not-found-if-not-auth Regards.

Hi, (checking this https://ajepe.github.io/posts/restful-api-for-odoo/). It throws 404 if not session_id is specified. What is the correct way to connect without needing to include sessino_id? Thank you.

Hi, good module. I'm trying to test this module but it never connects to the url. It only connects if I include 'Cookie': 'session_id=a40de38883ddbf04ab9d070ab950d0216f710a67'. What is the correct way to use this module, I don't want to spedify a session_id into the header. Thank you.

@ibyref and @Otto Kalme Can you describe what you are trying to achieve that is giving you an error with the code snippets with that I should be able to help you guys.