Odoo Help


How to search HR Expense with XMLRPC API ?

Luc Vanwaelscappel
on 9/20/13, 4:17 PM 1,769 views

Hello all,

I'm using a lot xmlrpclib in python to generate automatically a lot of stuff in my openerp.

I have now a problem with the expenses, HR expenses.

In the database, it is in hr.expense.expense.

and when I do a search like that :

#Config for API
openErpUser = 'User'
openErpPassword = 'password'
openErpBase = 'openerpbase' 
openErpCommon = 'localhost:8069/xmlrpc/common' #the xmlrpc common URL
openErpObject = 'localhost:8069/xmlrpc/object' #the xmlrpc object URL

#Connect to API
sock_common = xmlrpclib.ServerProxy (openErpCommon)
uid = sock_common.login(openErpBase, openErpUser, openErpPassword)
sock = xmlrpclib.ServerProxy(openErpObject)

#Search all the expenses that have been done after January 1st 2013
searchArgs = [('date', '>', '2013-01-01'),]
expenseIds = sock.execute(openErpBase, uid, openErpPassword, 'hr.expense.expense', 'search', searchArgs)

And the expenseIds is empty (and I have at least 10 exepenses done after this date).

When I do this with invoices, it works perfectly, but, whith these expenses. So far, I'm stuck :/

Who can help me ?

Where can I get the API list of all the objects like hr.expense.expense?

on 10/22/13, 8:48 PM

What I do is to look at the tables names in the database and I replace the _ by a dot and that's it !

Luc Vanwaelscappel
on 10/22/13, 11:29 PM
Luc Vanwaelscappel
On 9/23/13, 11:51 AM

I've found the problem.

It is because the user I was using to connect with the script didn't have the access rights in Configuration-->Users-->Users-->HR. You have to put him as a manager instead of an employee (as it was by default).

Hope it will help other people

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/20/13, 4:17 PM
Seen: 1769 times
Last updated: 3/16/15, 8:10 AM