External API xmlrpc error: KeyError: 'report_options'

api xmlrpc keyerror receivables

2 Svar

5401 Vyer

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!

Joren 's Jongers

Författare

Test

Joren 's Jongers

Författare

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
}

Jort de Vreeze

Bästa svar

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.

Joren 's Jongers

Författare

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

Njuter du av diskussionen? Läs inte bara, delta också!

Skapa ett konto idag för att ta del av exklusiva funktioner och engagera dig i vår fantastiska community!

Registrera dig

Relaterade inlägg	Svar	Vyer
External API Aged Payable/ Receivable api xmlrpc payables receivables aging	0 okt. 23	2320
XML-RPC API search_read method 100 records' limitation api xmlrpc	3 jan. 23	11448
XMLRPC API Search and Read - How to Supply Multiple Filters Löst api xmlrpc	1 mars 22	7922
(\'Error, a partner cannot follow twice the same object.\', None)\n'> api xmlrpc	1 feb. 22	8297
Logging XML RPC requests and responses into another log file Löst api xmlrpc	1 juli 20	11786

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!