Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
apixmlrpcpython3
2 Odgovori
11983 Prikazi
Avatar
Community Question

I'm working with the xmlrpc api using Python 3.
I'm having some trouble understanding the syntax for creating or updating a one2many or many2many type.
I've figured out the basic create and read commands for generic data types, but I can't seem to wrap my head around the documentation for the others, nor can I find much external help on the matter.

Avatar
Opusti
Avatar
Ray Carnes (ray)
Best Answer

Here is a code snippet that will create a new Partner, a new Contact, then update the Contact.

import xmlrpc.client

#connection details
server_url = 'http://localhost:8069'
db = 'database_name'
login = 'admin'
password = 'admin'

#endpoints
common_ep = xmlrpc.client.ServerProxy(server_url+'/xmlrpc/2/common')
object_ep = xmlrpc.client.ServerProxy(server_url+'/xmlrpc/2/object')

#login
uid = common_ep.authenticate(db, login, password,{})

#define new Partner
new_partner = {
  'name': 'Joe Smith',
  'ref': '12345',
}
 
#create New Partner 
new_partner_id = object_ep.execute_kw(db, uid, password, 'res.partner', 'create', [new_partner])

#define New Contact
new_contact = {
  'name': 'Jane Smith',
  'ref': '54321',
  'parent_id': new_partner_id,
}

#create New Contact, under New Partner
new_contact_id = object_ep.execute_kw(db, uid, password, 'res.partner', 'create', [new_contact])

#define update for New Contact

updated_information = {
  'phone': '555 123 1234',
}

#find New Contact
existing_contact_id = object_ep.execute_kw(db, uid, password, 'res.partner', 'search', [[['ref','=','54321']]])

object_ep.execute_kw(db, uid, password, 'res.partner', 'write', [existing_contact_id, updated_information])
Avatar
Opusti
Avatar
Florent
Best Answer

There's documentation on the "write" method for the special syntax for these o2m and m2m fields: https://www.odoo.com/documentation/12.0/reference/orm.html#model-reference

However, I would suggest using a library to wrap the XML-RPC or JSON-RPC calls with a simpler syntax.

For example you can use either \Odooly or OdooRPC libs (available on PyPI and Github).

Sample code with odooly (doing the same stuff as the comment above):

 
import odooly

client = odooly.Client('http://localhost:8069/jsonrpc', 'database_name', 'admin', 'admin')

env = client.env

# define new Partner
partner_data = {
    'name': 'Joe Smith',
    'ref': '12345',
}

# create New Partner 
new_partner = env['res.partner'].create(partner_data)

# define New Contact
contact_data = {
    'name': 'Jane Smith',
    'ref': '54321',
    'parent_id': new_partner.id,
}

new_contact = env['res.partner'].create(contact_data)

updated_information = {
    'phone': '555 123 1234',
}

#find New Contact
existing_contact = env['res.partner'].search(['ref = 54321'])

existing_contact.write(updated_information)

----


Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
[Odoo 11] @api.constrains method triggering 3 times when creating a record.
api xmlrpc python3 odoo11.0
Avatar
Avatar
1
jul. 18
7966
XML-RPC API search_read method 100 records' limitation
api xmlrpc
Avatar
Avatar
Avatar
3
jan. 23
9569
XMLRPC API Search and Read - How to Supply Multiple Filters Solved
api xmlrpc
Avatar
1
mar. 22
6611
(\'Error, a partner cannot follow twice the same object.\', None)\n'>
api xmlrpc
Avatar
Avatar
1
feb. 22
6740
Logging XML RPC requests and responses into another log file Solved
api xmlrpc
Avatar
Avatar
1
jul. 20
10447