How to get JSON data in an Odoo controller using type='json'?

20,596

Solution 1

You have just forgotten to put your data inside the params keywords:

Use this correct syntax :

data = {"params": dict(key="value")}

data = {
    "params": {
        "name":"prakashsharma",
        "email":"[email protected]",
        "phone":"+917859884833"
    }
}

Please don't forget to use json.dumps(data) and 'Content-Type': 'application/json' while requesting a resource in json format.

I am damn sure your issue will be solved after using this one my friend... cheers :)!!

Solution 2

You can use below format for a POST request

{
"params" : {
    "name" : "Order/1/18",
    "session_id" : 1,
    "customer_count" : 2,
    "partner_id" : 9,
    "lines": [
        {
            "product_id": 37,
            "qty" : 2,
            "price_unit" : 2,
            "discount" : 10
        }
        ],
    "pos_reference" : 2,
    "note" : "This is a test note"
}
}

Content type must be application/json

How odoo route will handle request ?

Route will help creating a POS order in odoo [POST]

@http.route(['/api/v1/resources/<string:api_key>/pos_order'], 
            auth="public",
            website=False,
            type="json",
            csrf=False,
            methods = ['POST'])
def create_update_pos_order(self, api_key=None, **kwargs):
    print(kwargs.get('name')) -> Order/1/18
Share:
20,596
forvas
Author by

forvas

Currently working with Python, XML, Bootstrap, Odoo framework, PostgreSQL and more. I am a developer who likes learning and helping. One of my fun Odoo modules: https://www.odoo.com/apps/modules/10.0/anb_russia_2018_sweepstake/

Updated on July 09, 2022

Comments

  • forvas
    forvas almost 2 years

    A few days ago I did a similar question here: How to get JSON data in an Odoo controller?

    But now, I need to create a controller which receives only JSON data. So, I am doing the request from a Python console, this way:

    import requests
    import json
    
    url = 'http://localhost:8069/odoo/test'
    headers = {'Content-Type': 'application/json'}
    data = {
        'name': 'Jane',
        'email': '[email protected]',
    }
    data_json = json.dumps(data)
    r = requests.post(url=url, data=data_json, headers=headers)
    

    I have created a controller which listens to http://localhost:8069/odoo/test, this way:

    import openerp.http as http
    from openerp.http import Response
    import logging
    _logger = logging.getLogger(__name__)
    
    
    class WebFormController(http.Controller):
    
        @http.route('/odoo/test', type='json',
                    auth='public', methods=['POST'], website=True)
        def index(self, **args):
            _logger.info('CONNECTION SUCCESSFUL')
            _logger.info(args)
            name = args.get('name', False)
            email = args.get('email', False)
            _logger.info(name)
            _logger.info(email)
            if not name:
                Response.status = '400 Bad Request'
            return '{"response": "OK"}'
    

    The problem is that I am receiving an empty JSON in the controller. I can read CONNECTION SUCCESFUL in the log, with no error, but when I show args, I get {}, and obviously due to that, False when writing name and email.

    If I pass the data as a Python dictionary or as a string, I get the following error:

    Invalid JSON data: 'name=Jane&email=jane.doe%40gmail.com' or Invalid JSON data: "{'name': 'Jane', 'email': '[email protected]'}" respectively.

    If I modify type='json' and I write type='http' instead, I get the following error:

    Function declared as capable of handling request of type 'http' but called with a request of type 'json'.

    I have read that may be this could be solved if the request is sent using the parameter json instead of data, this way:

    r = requests.post(url=url, json=data_json, headers=headers)
    

    Unfortunately, the server which is going to make the request has an old operating system which cannot update the python-requests package, so I cannot use json parameter since it did not exist at the version installed in that server.

    Please, can anyone help me? I need get JSON data in the controller, not a string neither Python dictionaries.

  • forvas
    forvas about 8 years
    that was exactly the problem! You have helped me a lot! Thank you very much my friend!!
  • Muneer Muhammed
    Muneer Muhammed over 6 years
    @forvas: Is it possible to access this from another platform? whenever I try to access this url from Postman it was returning 404. But possible to access from the browser in which the user logged in.
  • forvas
    forvas over 6 years
    @MuneerMuhammed yes, it is, in fact, a website of a customer was sending these JSON data to my Odoo.