Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Бухгалтерия
Склад
PoS
Проекты
MRP

All apps

Все посты Люди Значки

Теги (Смотреть все)

odoo accounting v14 pos v15

Об этом форуме

Помощь

How do you create and update One2Many and Many2Many records with Python 3?

api xmlrpc python3

2 Ответы

11978 Представления

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.

Ray Carnes (ray)

Лучший ответ

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])

Florent

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)

----

Не оставайтесь в стороне – присоединяйтесь к обсуждению!

Создайте аккаунт сегодня, чтобы получить доступ к эксклюзивным функциям и стать частью нашего замечательного сообщества!

Регистрация

Похожие посты	Ответы	Просмотры
[Odoo 11] @api.constrains method triggering 3 times when creating a record. api xmlrpc python3 odoo11.0	1 июл. 18	7961
XML-RPC API search_read method 100 records' limitation api xmlrpc	3 янв. 23	9558
XMLRPC API Search and Read - How to Supply Multiple Filters Решено api xmlrpc	1 мар. 22	6603
(\'Error, a partner cannot follow twice the same object.\', None)\n'> api xmlrpc	1 февр. 22	6732
Logging XML RPC requests and responses into another log file Решено api xmlrpc	1 июл. 20	10444

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!