Odoo XML-RPC BOM Export Python Script Generator

import csv
import getpass
import xmlrpc.client

URL = 'https://mycompany.odoo.com'
DB = 'mycompany'
USER = 'api.user@example.com'
API_KEY = getpass.getpass('Odoo API key: ')

common = xmlrpc.client.ServerProxy(URL + '/xmlrpc/2/common')
uid = common.authenticate(DB, USER, API_KEY, {})
if not uid:
    raise SystemExit('Authentication failed: check database, login and API key')

models = xmlrpc.client.ServerProxy(URL + '/xmlrpc/2/object')

boms = models.execute_kw(
    DB, uid, API_KEY, 'mrp.bom', 'search_read',
    [[['type', '=', 'normal']]],
    {'fields': ['id', 'product_tmpl_id', 'product_qty', 'type', 'bom_line_ids'], 'limit': 500}
)

line_ids = [lid for b in boms for lid in b['bom_line_ids']]
lines = models.execute_kw(
    DB, uid, API_KEY, 'mrp.bom.line', 'read',
    [line_ids],
    {'fields': ['bom_id', 'product_id', 'product_qty', 'product_uom_id']}
)
lines_by_bom = {}
for ln in lines:
    lines_by_bom.setdefault(ln['bom_id'][0], []).append(ln)

with open('odoo_bom_export.csv', 'w', newline='', encoding='utf-8') as f:
    w = csv.writer(f)
    w.writerow(['bom_id', 'parent_item', 'parent_qty', 'component', 'component_qty', 'uom'])
    for b in boms:
        for ln in lines_by_bom.get(b['id'], []):
            w.writerow([b['id'], b['product_tmpl_id'][1], b['product_qty'], ln['product_id'][1], ln['product_qty'], ln['product_uom_id'][1]])

print('Exported', len(boms), 'BOMs and', len(lines), 'lines to odoo_bom_export.csv')