Skip to Content
This question has been flagged
apixmlrpckeyerrorreceivables
2 Respostes
4851 Vistes
Avatar
Joren 's Jongers

I am building an API integration for customers of Odoo online, for which i have to retrieve the aged receivables. When fetching data from the model account.aged.receivable using xml-rpc, I get the error: KeyError: 'report_options’.


NodeJS code to reproduce the call:


import Odoo from 'async-odoo-xmlrpc';
const odoo = new Odoo({

  url: {{url}},

  db: {{db}},

  username: {{username}},

  password: {{password}},

});
await odoo.connect();
const receivables = await odoo.execute_kw('account.aged.receivable', 'search', [[]]);

Stack trace:

[ERROR] 11:59:29 Error: XML-RPC fault: Traceback (most recent call last):

File "/home/odoo/src/odoo/saas-15.2/odoo/addons/base/controllers/rpc.py", line 93, in xmlrpc_2

response = self._xmlrpc(service)

File "/home/odoo/src/odoo/saas-15.2/odoo/addons/base/controllers/rpc.py", line 73, in _xmlrpc

result = dispatch_rpc(service, method, params)

File "/home/odoo/src/odoo/saas-15.2/odoo/http.py", line 141, in dispatch_rpc

result = dispatch(method, params)

File "/home/odoo/src/odoo/saas-15.2/odoo/service/model.py", line 41, in dispatch

res = fn(db, uid, *params)

File "/home/odoo/src/odoo/saas-15.2/odoo/service/model.py", line 169, in execute_kw

return execute(db, uid, obj, method, *args, **kw or {})

File "/home/odoo/src/odoo/saas-15.2/odoo/service/model.py", line 94, in wrapper

return f(dbname, *args, **kwargs)

File "/home/odoo/src/odoo/saas-15.2/odoo/service/model.py", line 176, in execute

res = execute_cr(cr, uid, obj, method, *args, **kw)

File "/home/odoo/src/odoo/saas-15.2/odoo/service/model.py", line 160, in execute_cr

result = odoo.api.call_kw(recs, method, args, kw)

File "/home/odoo/src/odoo/saas-15.2/odoo/api.py", line 457, in call_kw

result = _call_kw_model(method, model, args, kwargs)

File "/home/odoo/src/odoo/saas-15.2/odoo/api.py", line 430, in _call_kw_model

result = method(recs, *args, **kwargs)

File "/home/odoo/src/odoo/saas-15.2/odoo/models.py", line 1812, in search

res = self._search(args, offset=offset, limit=limit, order=order, count=count)

File "/home/odoo/src/odoo/saas-15.2/odoo/models.py", line 4759, in _search

query = self._where_calc(args)

File "/home/odoo/src/odoo/saas-15.2/odoo/models.py", line 4517, in _where_calc

return Query(self.env.cr, self._table, self._table_query)

File "/home/odoo/src/enterprise/saas-15.2/account_reports/models/account_accounting_report.py", line 83, in _table_query

query = self._get_sql()

File "/home/odoo/src/enterprise/saas-15.2/account_reports/models/account_aged_partner_balance.py", line 95, in _get_sql

options = self.env.context['report_options']

KeyError: 'report_options'


Since self.env.context is being queried for ‘report_options’, I think something might be wrong with the configuration of the Odoo environment.

Does anyone know how to solve this issue?


Thanks in advance!


Avatar
Descartar
Joren 's Jongers
Autor


const contextParam = {
'context': {
'report_options': {
'date': {
'date_from': 'YYYY-MM-DD',
'date_to': 'YYYY-MM-DD'
},
'account_type_aml_sign': -1
}
}
}

Unfortunately, the library async-odoo-xmlrpc does not support the extra paramater. A PR has been opened to add this in, but at the time of writing it is not yet merged.
I used the library xmlrpc, on which async-odoo-xmlrpc is based, directly to get the request to work in nodeJS, like so:

client.methodCall(
'execute_kw',
[db, uid, password, 'account.aged.receivable', 'search_read', [[]], contextParam],
(err, val) => {
// Handle response here
}

Avatar
Jort de Vreeze
Best Answer

That's because account.aged.receivable inherits the account.aged.partner (i.e., account_aged_partner_balance) model which in turn requires context values to query the data for the report.

Inspecting the source code for 'account_aged_partner_balance' shows that this method '_get_sql'  needs at least:

  • options['date']['date_to']
  • options['filter_account_type']

For Odoo RPC you can set the context values (see also https://stackoverflow.com/questions/46586281/alter-odoo-xmlrpc-context-to-use-a-specific-language):

odoo.execute_kw(
  'account.aged.receivable', 
  'search_read', 
  [[]], 
  {
    'context': {
      'report_options': {
        'data': {
          'date_to': value
        },
        'filter_account_type': 'receivable',
      }
    }
  }
); 

I haven't tested this, but I hope it helps.

Avatar
Descartar
Avatar
Joren 's Jongers
Autor Best Answer

@jort, indeed, that does the trick, thanks!

Avatar
Descartar
Related Posts Respostes Vistes Activitat
External API Aged Payable/ Receivable
api xmlrpc payables receivables aging
Avatar
0
d’oct. 23
1906
XML-RPC API search_read method 100 records' limitation
api xmlrpc
Avatar
Avatar
Avatar
3
de gen. 23
10222
XMLRPC API Search and Read - How to Supply Multiple Filters Solved
api xmlrpc
Avatar
1
de març 22
6982
(\'Error, a partner cannot follow twice the same object.\', None)\n'>
api xmlrpc
Avatar
Avatar
1
de febr. 22
7276
Logging XML RPC requests and responses into another log file Solved
api xmlrpc
Avatar
Avatar
1
de jul. 20
10900