Connexion Odoo pour LinkyFlow

LinkyFlow connecte Excel a Odoo pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

319

Workflows a ramener dans Excel

Chaque ressource ci-dessous correspond a un workflow tableur concret. Les lectures ramenent des colonnes utiles dans Excel; les creations et modifications indiquent ce qui peut etre relu en lignes avant envoi.

Accounting

Bank Statement Lines

The transactions of the bank and cash journals (account.bank.statement.line), and whether each is reconciled.

Lecture

Bank Statement Lines

The transactions of the bank and cash journals (account.bank.statement.line), and whether each is reconciled.

Route: GET /bankStatementLines

Formule Excel: =LF.odoo.bankStatementLines("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`journal_id`	id	No	Only the records of this journal: one ID, or several comma-separated.
`partner_id`	id	No	Only the records of this partner: one ID, or several comma-separated.
`is_reconciled`	boolean	No	Only the reconciled (true) or open (false) lines.
`payment_ref`	string	No	Only the records whose label contains this text (case-insensitive).
`date_from`	date	No	On or after this date (YYYY-MM-DD).
`date_to`	date	No	On or before this date (YYYY-MM-DD).
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`date` default	date	—	-
`payment_ref` default	string	—	-
`amount` default	number	—	-
`partner_id_name` default	string	—	-
`is_reconciled` default	boolean	—	-

Creation

Create Bank Statement Line

Route: POST /mutation/bankStatementLines

Entrees configurables

Name	Type	Required	Description
`account_number`	string	No	-
`amount`	number	Yes	-
`date`	date	Yes	-
`journal_id`	id	Yes	-
`partner_id`	id	No	-
`partner_name`	string	No	-
`payment_ref`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Bank Statement Line

Route: PATCH /mutation/bankStatementLines

Entrees configurables

Name	Type	Required	Description
`account_number`	string	No	-
`amount`	number	Yes	-
`date`	date	Yes	-
`journal_id`	id	Yes	-
`partner_id`	id	No	-
`partner_name`	string	No	-
`payment_ref`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Bank Statement Line

Route: DELETE /mutation/bankStatementLines

Entrees configurables

Name	Type	Required	Description
`account_number`	string	No	-
`amount`	number	Yes	-
`date`	date	Yes	-
`journal_id`	id	Yes	-
`partner_id`	id	No	-
`partner_name`	string	No	-
`payment_ref`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Cancel Invoice

Cancels a draft invoice or bill, which is then never posted.

Creation

Cancel Invoice

Route: POST /mutation/invoiceCancel

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Cancel Journal Entry

Cancels a draft journal entry, which is then never posted.

Creation

Cancel Journal Entry

Route: POST /mutation/journalEntryCancel

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Cancel Payment

Cancels a draft payment, which is then never confirmed.

Creation

Cancel Payment

Route: POST /mutation/paymentCancel

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Confirm Payment

Confirms a draft payment: Odoo numbers it and books its journal entry, awaiting its bank line.

Creation

Confirm Payment

Route: POST /mutation/paymentPost

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Credit Notes

Reverses a posted invoice or bill by a draft credit note (or refund) of the same amount, which answers; post it to settle the invoice.

Creation

Create Credit Note

Route: POST /mutation/invoiceReverse

Entrees configurables

Name	Type	Required	Description
`date`	date	No	-
`id`	id	Yes	-
`reason`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Invoices

Customer invoices and credit notes, vendor bills and refunds (account.move): their state, payment state, partner, dates and totals.

Utilise comme filtre par

Journal Items · move_id

Lecture

Invoices

Customer invoices and credit notes, vendor bills and refunds (account.move): their state, payment state, partner, dates and totals.

Route: GET /invoices

Formule Excel: =LF.odoo.invoices("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`move_type`	enum	No	Only these types: out_invoice, out_refund (customers), in_invoice, in_refund (vendors). Values: out_invoice, out_refund, in_invoice, in_refund
`state`	enum	No	Only these statuses. Values: draft, posted, cancel
`payment_state`	enum	No	Only these payment statuses: not_paid and partial for what is still due. Values: not_paid, in_payment, paid, partial, reversed
`partner_id`	id	No	Only the records of this partner: one ID, or several comma-separated.
`journal_id`	id	No	Only the records of this journal: one ID, or several comma-separated.
`name`	string	No	Only the records whose number contains this text (case-insensitive).
`ref`	string	No	Only the records whose reference contains this text (case-insensitive).
`invoice_date_from`	date	No	On or after this date (YYYY-MM-DD).
`invoice_date_to`	date	No	On or before this date (YYYY-MM-DD).
`invoice_date_due_from`	date	No	On or after this date (YYYY-MM-DD).
`invoice_date_due_to`	date	No	On or before this date (YYYY-MM-DD).
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`move_type` default	enum	—	-
`state` default	enum	—	-
`payment_state` default	enum	—	-
`partner_id_name` default	string	—	-
`invoice_date` default	date	—	-
`currency_id_name` default	string	—	-
`amount_total` default	number	—	-
`amount_residual` default	number	—	-

Creation

Create Invoice

Route: POST /mutation/invoices

Entrees configurables

Name	Type	Required	Description
`currency_id`	id	No	-
`invoice_date`	date	No	-
`invoice_date_due`	date	No	-
`invoice_payment_term_id`	id	No	-
`journal_id`	id	No	-
`lines`	string	Yes	-
`move_type`	enum	Yes	Values: out_invoice, out_refund, in_invoice, in_refund
`partner_id`	id	Yes	-
`payment_reference`	string	No	-
`ref`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Invoice

Route: PATCH /mutation/invoices

Entrees configurables

Name	Type	Required	Description
`currency_id`	id	No	-
`invoice_date`	date	No	-
`invoice_date_due`	date	No	-
`invoice_payment_term_id`	id	No	-
`journal_id`	id	No	-
`lines`	string	Yes	-
`move_type`	enum	Yes	Values: out_invoice, out_refund, in_invoice, in_refund
`partner_id`	id	Yes	-
`payment_reference`	string	No	-
`ref`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Invoice

Route: DELETE /mutation/invoices

Entrees configurables

Name	Type	Required	Description
`currency_id`	id	No	-
`invoice_date`	date	No	-
`invoice_date_due`	date	No	-
`invoice_payment_term_id`	id	No	-
`journal_id`	id	No	-
`lines`	string	Yes	-
`move_type`	enum	Yes	Values: out_invoice, out_refund, in_invoice, in_refund
`partner_id`	id	Yes	-
`payment_reference`	string	No	-
`ref`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Journal Entries

Miscellaneous journal entries (account.move of type entry): accruals, adjustments, opening balances — each a set of balanced debit and credit lines.

Lecture

Journal Entries

Miscellaneous journal entries (account.move of type entry): accruals, adjustments, opening balances — each a set of balanced debit and credit lines.

Route: GET /journalEntries

Formule Excel: =LF.odoo.journalEntries("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`journal_id`	id	No	Only the records of this journal: one ID, or several comma-separated.
`state`	enum	No	Only these statuses. Values: draft, posted, cancel
`name`	string	No	Only the records whose number contains this text (case-insensitive).
`ref`	string	No	Only the records whose reference contains this text (case-insensitive).
`date_from`	date	No	On or after this date (YYYY-MM-DD).
`date_to`	date	No	On or before this date (YYYY-MM-DD).
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`ref` default	string	—	-
`date` default	date	—	-
`journal_id_name` default	string	—	-
`state` default	enum	—	-
`amount_total` default	number	—	-

Creation

Create Journal Entry

Route: POST /mutation/journalEntries

Entrees configurables

Name	Type	Required	Description
`date`	date	No	-
`journal_id`	id	No	-
`lines`	string	Yes	-
`ref`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Journal Entry

Route: PATCH /mutation/journalEntries

Entrees configurables

Name	Type	Required	Description
`date`	date	No	-
`journal_id`	id	No	-
`lines`	string	Yes	-
`ref`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Journal Entry

Route: DELETE /mutation/journalEntries

Entrees configurables

Name	Type	Required	Description
`date`	date	No	-
`journal_id`	id	No	-
`lines`	string	Yes	-
`ref`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Journal Items

The lines of the general ledger (account.move.line): each debit or credit on an account, with its entry, partner, product and reconciliation.

Lecture

Journal Items

The lines of the general ledger (account.move.line): each debit or credit on an account, with its entry, partner, product and reconciliation.

Route: GET /journalItems

Formule Excel: =LF.odoo.journalItems("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`move_id`	id	No	Only the records of this invoice: one ID, or several comma-separated.
`account_id`	id	No	Only the records of this account: one ID, or several comma-separated.
`account_type`	enum	No	Only the lines on accounts of these types: asset_receivable and liability_payable for what customers and vendors owe. Values: asset_receivable, asset_cash, asset_current, asset_non_current, asset_prepayments
`partner_id`	id	No	Only the records of this partner: one ID, or several comma-separated.
`journal_id`	id	No	Only the records of this journal: one ID, or several comma-separated.
`product_id`	id	No	Only the records of this product: one ID, or several comma-separated.
`parent_state`	enum	No	Only the lines of entries in these statuses: posted for the ledger. Values: draft, posted, cancel
`display_type`	string	No	Only these line types: product for the lines of an invoice.
`reconciled`	boolean	No	Only the reconciled (true) or open (false) lines.
`date_from`	date	No	On or after this date (YYYY-MM-DD).
`date_to`	date	No	On or before this date (YYYY-MM-DD).
`date_maturity_from`	date	No	On or after this date (YYYY-MM-DD).
`date_maturity_to`	date	No	On or before this date (YYYY-MM-DD).
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`move_name` default	string	—	-
`date` default	date	—	-
`account_id_name` default	string	—	-
`partner_id_name` default	string	—	-
`name` default	string	—	-
`debit` default	number	—	-
`credit` default	number	—	-
`parent_state` default	enum	—	-

Payments

Customer and vendor payments (account.payment): amount, partner, journal, state and whether they are matched.

Lecture

Payments

Customer and vendor payments (account.payment): amount, partner, journal, state and whether they are matched.

Route: GET /payments

Formule Excel: =LF.odoo.payments("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`partner_id`	id	No	Only the records of this partner: one ID, or several comma-separated.
`journal_id`	id	No	Only the records of this journal: one ID, or several comma-separated.
`payment_type`	enum	No	inbound: received; outbound: sent. Values: inbound, outbound
`partner_type`	enum	No	customer or supplier. Values: customer, supplier
`state`	enum	No	Only these statuses. Values: draft, in_process, paid, canceled, rejected
`memo`	string	No	Only the records whose memo contains this text (case-insensitive).
`date_from`	date	No	On or after this date (YYYY-MM-DD).
`date_to`	date	No	On or before this date (YYYY-MM-DD).
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`date` default	date	—	-
`payment_type` default	enum	—	-
`partner_id_name` default	string	—	-
`amount` default	number	—	-
`currency_id_name` default	string	—	-
`state` default	enum	—	-

Creation

Create Payment

Route: POST /mutation/payments

Entrees configurables

Name	Type	Required	Description
`amount`	number	Yes	-
`currency_id`	id	No	-
`date`	date	No	-
`journal_id`	id	No	-
`memo`	string	No	-
`partner_id`	id	No	-
`partner_type`	enum	Yes	Values: customer, supplier
`payment_type`	enum	Yes	Values: inbound, outbound

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Payment

Route: PATCH /mutation/payments

Entrees configurables

Name	Type	Required	Description
`amount`	number	Yes	-
`currency_id`	id	No	-
`date`	date	No	-
`journal_id`	id	No	-
`memo`	string	No	-
`partner_id`	id	No	-
`partner_type`	enum	Yes	Values: customer, supplier
`payment_type`	enum	Yes	Values: inbound, outbound

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Payment

Route: DELETE /mutation/payments

Entrees configurables

Name	Type	Required	Description
`amount`	number	Yes	-
`currency_id`	id	No	-
`date`	date	No	-
`journal_id`	id	No	-
`memo`	string	No	-
`partner_id`	id	No	-
`partner_type`	enum	Yes	Values: customer, supplier
`payment_type`	enum	Yes	Values: inbound, outbound

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Post Invoice

Posts a draft invoice or bill: Odoo numbers it and books its journal entry, and it becomes payable.

Creation

Post Invoice

Route: POST /mutation/invoicePost

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Post Journal Entry

Posts a draft journal entry: Odoo numbers it and books its lines in the ledger.

Creation

Post Journal Entry

Route: POST /mutation/journalEntryPost

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Register Payment

Records a payment of a posted invoice or bill — the whole amount due, or part of it — and reconciles it: the invoice becomes paid (or partially). It moves no money: it books one received or made.

Creation

Register Payment

Route: POST /mutation/invoiceRegisterPayment

Entrees configurables

Name	Type	Required	Description
`amount`	number	No	-
`communication`	string	No	-
`id`	id	Yes	-
`journal_id`	id	No	-
`payment_date`	date	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Reset Invoice to Draft

Puts a posted or cancelled invoice or bill back to draft, its journal entry unposted.

Creation

Reset Invoice to Draft

Route: POST /mutation/invoiceResetToDraft

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Reset Journal Entry to Draft

Puts a posted or cancelled journal entry back to draft, unposted.

Creation

Reset Journal Entry to Draft

Route: POST /mutation/journalEntryResetToDraft

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Reset Payment to Draft

Puts a confirmed, cancelled or rejected payment back to draft, its journal entry unposted.

Creation

Reset Payment to Draft

Route: POST /mutation/paymentResetToDraft

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Reverse Journal Entry

Reverses a posted journal entry by an entry of opposite lines, on its journal, which answers.

Creation

Reverse Journal Entry

Route: POST /mutation/journalEntryReverse

Entrees configurables

Name	Type	Required	Description
`date`	date	No	-
`id`	id	Yes	-
`reason`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Accounting Reports

Partner Balances

What each customer owes and what is owed to each vendor (the open receivable and payable items, summed by partner), overdue as of a date when asked, in the company’s currency.

Lecture

Partner Balances

What each customer owes and what is owed to each vendor (the open receivable and payable items, summed by partner), overdue as of a date when asked, in the company’s currency.

Route: GET /partnerBalances

Formule Excel: =LF.odoo.partnerBalances("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`account_type`	enum	No	asset_receivable: what customers owe; liability_payable: what is owed to vendors. Values: asset_receivable, liability_payable
`date_maturity_from`	date	No	On or after this date (YYYY-MM-DD).
`date_maturity_to`	date	No	On or before this date (YYYY-MM-DD).
`partner_id`	id	No	Only the records of this partner: one ID, or several comma-separated.
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`partner_id`	id	→ partners	-
`partner_id_name` default	string	—	-
`amount_residual` default	number	—	-
`balance`	number	—	-
`count`	number	—	-

Trial Balance

The posted journal items summed by account (a trial balance): debit, credit and balance of each account over the period asked, in the company’s currency.

Lecture

Trial Balance

The posted journal items summed by account (a trial balance): debit, credit and balance of each account over the period asked, in the company’s currency.

Route: GET /accountBalances

Formule Excel: =LF.odoo.accountBalances("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`date_from`	date	No	On or after this date (YYYY-MM-DD).
`date_to`	date	No	On or before this date (YYYY-MM-DD).
`account_type`	enum	No	Only accounts of these types: income and expense for a result, the others for a balance sheet. Values: asset_receivable, asset_cash, asset_current, asset_non_current, asset_prepayments
`account_id`	id	No	Only the records of this account: one ID, or several comma-separated.
`journal_id`	id	No	Only the records of this journal: one ID, or several comma-separated.
`partner_id`	id	No	Only the records of this partner: one ID, or several comma-separated.
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`account_id`	id	→ accounts	-
`account_id_name` default	string	—	-
`debit` default	number	—	-
`credit` default	number	—	-
`balance` default	number	—	-
`count`	number	—	-

Accounting Setup

Accounts

The chart of accounts (account.account): code, name, type and current balance.

Utilise comme filtre par

Trial Balance · account_id

Journal Items · account_id

Lecture

Accounts

The chart of accounts (account.account): code, name, type and current balance.

Route: GET /accounts

Formule Excel: =LF.odoo.accounts("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`code`	string	No	Only the accounts whose code contains this text (411).
`name`	string	No	Only the records whose name contains this text (case-insensitive).
`account_type`	enum	No	Only accounts of these types. Values: asset_receivable, asset_cash, asset_current, asset_non_current, asset_prepayments
`active`	boolean	No	False: the archived accounts.
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`code` default	string	—	-
`name` default	string	—	-
`account_type` default	enum	—	-
`reconcile`	boolean	—	-
`currency_id`	id	→ currencies	-
`currency_id_name`	string	—	-
`current_balance` default	number	—	-
`note`	string	—	-
`active`	boolean	—	-

Creation

Create Account

Route: POST /mutation/accounts

Entrees configurables

Name	Type	Required	Description
`account_type`	enum	Yes	Values: asset_receivable, asset_cash, asset_current, asset_non_current, asset_prepayments
`code`	string	Yes	-
`currency_id`	id	No	-
`name`	string	Yes	-
`note`	string	No	-
`reconcile`	boolean	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Account

Route: PATCH /mutation/accounts

Entrees configurables

Name	Type	Required	Description
`account_type`	enum	Yes	Values: asset_receivable, asset_cash, asset_current, asset_non_current, asset_prepayments
`code`	string	Yes	-
`currency_id`	id	No	-
`name`	string	Yes	-
`note`	string	No	-
`reconcile`	boolean	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Analytic Accounts

The analytic accounts (account.analytic.account) a line’s amount is split over, with their balance.

Lecture

Analytic Accounts

The analytic accounts (account.analytic.account) a line’s amount is split over, with their balance.

Route: GET /analyticAccounts

Formule Excel: =LF.odoo.analyticAccounts("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`plan_id`	id	No	Only the records of this plan: one ID, or several comma-separated.
`name`	string	No	Only the records whose name contains this text (case-insensitive).
`partner_id`	id	No	Only the records of this customer: one ID, or several comma-separated.
`active`	boolean	No	False: the archived accounts.
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`code` default	string	—	-
`plan_id`	id	→ analyticPlans	-
`plan_id_name` default	string	—	-
`partner_id`	id	→ partners	-
`partner_id_name`	string	—	-
`debit`	number	—	-
`credit`	number	—	-
`balance` default	number	—	-
`active`	boolean	—	-

Creation

Create Analytic Account

Route: POST /mutation/analyticAccounts

Entrees configurables

Name	Type	Required	Description
`code`	string	No	-
`name`	string	Yes	-
`partner_id`	id	No	-
`plan_id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Analytic Account

Route: PATCH /mutation/analyticAccounts

Entrees configurables

Name	Type	Required	Description
`code`	string	No	-
`name`	string	Yes	-
`partner_id`	id	No	-
`plan_id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Analytic Plans

The analytic plans (account.analytic.plan) that group analytic accounts: projects, departments, cost centers.

Utilise comme filtre par

Analytic Accounts · plan_id

Lecture

Analytic Plans

The analytic plans (account.analytic.plan) that group analytic accounts: projects, departments, cost centers.

Route: GET /analyticPlans

Formule Excel: =LF.odoo.analyticPlans("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`name`	string	No	Only the records whose name contains this text (case-insensitive).
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`complete_name` default	string	—	-
`parent_id`	id	→ analyticPlans	-
`parent_id_name`	string	—	-

Currencies

The currencies of the database (res.currency): the active ones and their current rate against the company’s.

Utilise comme filtre par

Currency Rates · currency_id

Lecture

Currencies

The currencies of the database (res.currency): the active ones and their current rate against the company’s.

Route: GET /currencies

Formule Excel: =LF.odoo.currencies("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`name`	string	No	Only the records whose code contains this text (case-insensitive).
`active`	boolean	No	False: the currencies not in use, which a list leaves out otherwise.
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`full_name` default	string	—	-
`symbol`	string	—	-
`rate` default	number	—	-
`decimal_places`	number	—	-
`active`	boolean	—	-

Currency Rates

The exchange rates of each currency by date (res.currency.rate), against the company’s currency.

Lecture

Currency Rates

The exchange rates of each currency by date (res.currency.rate), against the company’s currency.

Route: GET /currencyRates

Formule Excel: =LF.odoo.currencyRates("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`currency_id`	id	No	Only the records of this currency: one ID, or several comma-separated.
`name_from`	date	No	On or after this date (YYYY-MM-DD).
`name_to`	date	No	On or before this date (YYYY-MM-DD).
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`currency_id`	id	→ currencies	-
`currency_id_name` default	string	—	-
`name` default	date	—	-
`rate` default	number	—	-

Creation

Create Currency Rate

Route: POST /mutation/currencyRates

Entrees configurables

Name	Type	Required	Description
`currency_id`	id	Yes	-
`name`	date	Yes	-
`rate`	number	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Currency Rate

Route: PATCH /mutation/currencyRates

Entrees configurables

Name	Type	Required	Description
`currency_id`	id	Yes	-
`name`	date	Yes	-
`rate`	number	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Fiscal Positions

The fiscal positions (account.fiscal.position) that map taxes and accounts by customer or vendor: domestic, intra-EU, export.

Lecture

Fiscal Positions

The fiscal positions (account.fiscal.position) that map taxes and accounts by customer or vendor: domestic, intra-EU, export.

Route: GET /fiscalPositions

Formule Excel: =LF.odoo.fiscalPositions("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`name`	string	No	Only the records whose name contains this text (case-insensitive).
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`auto_apply` default	boolean	—	-
`country_id`	id	—	-
`country_id_name`	string	—	-
`vat_required`	boolean	—	-
`active`	boolean	—	-

Journals

The accounting journals (account.journal): sales, purchase, bank, cash, credit card and miscellaneous.

Utilise comme filtre par

Trial Balance · journal_id

Bank Statement Lines · journal_id

Invoices · journal_id

Journal Entries · journal_id

Journal Items · journal_id

Payments · journal_id

Lecture

Journals

The accounting journals (account.journal): sales, purchase, bank, cash, credit card and miscellaneous.

Route: GET /journals

Formule Excel: =LF.odoo.journals("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`type`	enum	No	Only journals of these types: bank and cash for payments. Values: sale, purchase, cash, bank, credit
`name`	string	No	Only the records whose name contains this text (case-insensitive).
`company_id`	id	No	Only the records of this company: one ID, or several comma-separated.
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`code` default	string	—	-
`type` default	enum	—	-
`currency_id`	id	→ currencies	-
`currency_id_name`	string	—	-
`default_account_id`	id	→ accounts	-
`default_account_id_name`	string	—	-
`company_id`	id	—	-
`company_id_name`	string	—	-
`active`	boolean	—	-

Payment Terms

The payment terms (account.payment.term) an invoice or an order is due by: immediate, 30 days, end of month…

Lecture

Payment Terms

The payment terms (account.payment.term) an invoice or an order is due by: immediate, 30 days, end of month…

Route: GET /paymentTerms

Formule Excel: =LF.odoo.paymentTerms("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`name`	string	No	Only the records whose name contains this text (case-insensitive).
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`early_discount`	boolean	—	-
`active`	boolean	—	-

Taxes

The taxes of the database (account.tax): rate, computation and whether they apply to sales or purchases.

Lecture

Taxes

The taxes of the database (account.tax): rate, computation and whether they apply to sales or purchases.

Route: GET /taxes

Formule Excel: =LF.odoo.taxes("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`type_tax_use`	enum	No	sale, purchase or none. Values: sale, purchase, none
`name`	string	No	Only the records whose name contains this text (case-insensitive).
`active`	boolean	No	False: the archived taxes.
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`amount` default	number	—	-
`amount_type`	enum	—	-
`type_tax_use` default	enum	—	-
`price_include`	boolean	—	-
`invoice_label`	string	—	-
`tax_group_id`	id	—	-
`tax_group_id_name`	string	—	-
`active`	boolean	—	-

Catalog

Product Categories

The categories that sort the catalogue (product.category), each with its full path.

Utilise comme filtre par

Product Categories · parent_id

Products · categ_id

Lecture

Product Categories

The categories that sort the catalogue (product.category), each with its full path.

Route: GET /productCategories

Formule Excel: =LF.odoo.productCategories("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`name`	string	No	Only the records whose name contains this text (case-insensitive).
`parent_id`	id	No	Only the records of this parent category: one ID, or several comma-separated.
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`complete_name` default	string	—	-
`parent_id`	id	→ productCategories	-
`parent_id_name`	string	—	-

Products

The products of the catalogue (product.product): each variant with its internal reference, barcode, prices and category.

Utilise comme filtre par

Journal Items · product_id

Purchase Order Lines · product_id

Sales Order Lines · product_id

Lecture

Products

The products of the catalogue (product.product): each variant with its internal reference, barcode, prices and category.

Route: GET /products

Formule Excel: =LF.odoo.products("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`name`	string	No	Only the records whose name contains this text (case-insensitive).
`default_code`	string	No	Only these SKUs: one, or several comma-separated, exactly as written.
`barcode`	string	No	Only these barcodes: one, or several comma-separated.
`type`	enum	No	Only products of these types. Values: consu, service, combo
`categ_id`	id	No	Only the records of this category: one ID, or several comma-separated.
`sale_ok`	boolean	No	Only products that can (true) or cannot (false) be sold.
`purchase_ok`	boolean	No	Only products that can (true) or cannot (false) be purchased.
`active`	boolean	No	False: the archived products, which a list leaves out otherwise.
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`default_code` default	string	—	-
`barcode`	string	—	-
`type`	enum	—	-
`categ_id`	id	→ productCategories	-
`categ_id_name` default	string	—	-
`lst_price` default	number	—	-
`standard_price`	number	—	-
`uom_id`	id	—	-
`uom_id_name`	string	—	-
`sale_ok`	boolean	—	-
`purchase_ok`	boolean	—	-
`description_sale`	string	—	-
`active`	boolean	—	-
`product_tmpl_id`	id	—	-
`write_date`	date	—	-

Creation

Create Product

Route: POST /mutation/products

Entrees configurables

Name	Type	Required	Description
`barcode`	string	No	-
`categ_id`	id	No	-
`default_code`	string	No	-
`description_sale`	string	No	-
`lst_price`	number	No	-
`name`	string	Yes	-
`purchase_ok`	boolean	No	-
`sale_ok`	boolean	No	-
`standard_price`	number	No	-
`type`	enum	No	Values: consu, service, combo

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Product

Route: PATCH /mutation/products

Entrees configurables

Name	Type	Required	Description
`barcode`	string	No	-
`categ_id`	id	No	-
`default_code`	string	No	-
`description_sale`	string	No	-
`lst_price`	number	No	-
`name`	string	Yes	-
`purchase_ok`	boolean	No	-
`sale_ok`	boolean	No	-
`standard_price`	number	No	-
`type`	enum	No	Values: consu, service, combo

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Contacts

Partners

Customers and vendors of the database (res.partner): companies, and the people and addresses under them.

Utilise comme filtre par

Trial Balance · partner_id

Analytic Accounts · partner_id

Bank Statement Lines · partner_id

Invoices · partner_id

Journal Items · partner_id

Partner Balances · partner_id

Partners · parent_id

Payments · partner_id

Purchase Orders · partner_id

Sales Orders · partner_id

Lecture

Partners

Customers and vendors of the database (res.partner): companies, and the people and addresses under them.

Route: GET /partners

Formule Excel: =LF.odoo.partners("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`name`	string	No	Only the records whose name contains this text (case-insensitive).
`email`	string	No	Only the records whose email contains this text (case-insensitive).
`vat`	string	No	Only the records whose tax id contains this text (case-insensitive).
`is_company`	boolean	No	True: companies only; false: people and addresses only.
`parent_id`	id	No	Only the records of this parent company: one ID, or several comma-separated.
`country_id`	id	No	Only the records of this country: one ID, or several comma-separated.
`customer_rank_min`	number	No	Customers only: 1 keeps the partners that have been sold to or invoiced.
`supplier_rank_min`	number	No	Vendors only: 1 keeps the partners that have been bought from or have billed.
`active`	boolean	No	False: the archived partners, which a list leaves out otherwise.
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`is_company` default	boolean	—	-
`email` default	string	—	-
`city` default	string	—	-
`country_id_name` default	string	—	-

Creation

Create Partner

Route: POST /mutation/partners

Entrees configurables

Name	Type	Required	Description
`city`	string	No	-
`country_id`	id	No	-
`email`	string	No	-
`is_company`	boolean	No	-
`name`	string	Yes	-
`parent_id`	id	No	-
`phone`	string	No	-
`ref`	string	No	-
`street`	string	No	-
`street2`	string	No	-
`vat`	string	No	-
`website`	string	No	-
`zip`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Partner

Route: PATCH /mutation/partners

Entrees configurables

Name	Type	Required	Description
`city`	string	No	-
`country_id`	id	No	-
`email`	string	No	-
`is_company`	boolean	No	-
`name`	string	Yes	-
`parent_id`	id	No	-
`phone`	string	No	-
`ref`	string	No	-
`street`	string	No	-
`street2`	string	No	-
`vat`	string	No	-
`website`	string	No	-
`zip`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Purchase

Cancel Purchase Order

Cancels a request for quotation, or an order still awaiting approval.

Creation

Cancel Purchase Order

Route: POST /mutation/purchaseOrderCancel

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Confirm Purchase Order

Confirms a request for quotation: it becomes a purchase order sent to receive and bill — or waits for approval where the company asks for one.

Creation

Confirm Purchase Order

Route: POST /mutation/purchaseOrderConfirm

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Purchase Order Lines

The lines of requests for quotation and purchase orders (purchase.order.line): product, quantities ordered, received and billed, prices.

Lecture

Purchase Order Lines

The lines of requests for quotation and purchase orders (purchase.order.line): product, quantities ordered, received and billed, prices.

Route: GET /purchaseOrderLines

Formule Excel: =LF.odoo.purchaseOrderLines("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`order_id`	id	No	Only the records of this purchase order: one ID, or several comma-separated.
`product_id`	id	No	Only the records of this product: one ID, or several comma-separated.
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`order_id_name` default	string	—	-
`product_id_name` default	string	—	-
`product_qty` default	number	—	-
`price_unit` default	number	—	-
`price_subtotal` default	number	—	-

Purchase Orders

Requests for quotation and purchase orders (purchase.order): vendor, state, dates, totals and what remains to be billed.

Utilise comme filtre par

Purchase Order Lines · order_id

Lecture

Purchase Orders

Requests for quotation and purchase orders (purchase.order): vendor, state, dates, totals and what remains to be billed.

Route: GET /purchaseOrders

Formule Excel: =LF.odoo.purchaseOrders("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`partner_id`	id	No	Only the records of this vendor: one ID, or several comma-separated.
`state`	enum	No	Only these statuses: draft and sent for requests for quotation, purchase for orders. Values: draft, sent, to approve, purchase, cancel
`invoice_status`	enum	No	Only these billing statuses. Values: no, to invoice, invoiced
`name`	string	No	Only the records whose number contains this text (case-insensitive).
`partner_ref`	string	No	Only the records whose vendor reference contains this text (case-insensitive).
`date_order_from`	date	No	On or after this date (YYYY-MM-DD).
`date_order_to`	date	No	On or before this date (YYYY-MM-DD).
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`state` default	enum	—	-
`partner_id_name` default	string	—	-
`date_order` default	date	—	-
`currency_id_name` default	string	—	-
`amount_total` default	number	—	-

Creation

Create Purchase Order

Route: POST /mutation/purchaseOrders

Entrees configurables

Name	Type	Required	Description
`lines`	string	Yes	-
`origin`	string	No	-
`partner_id`	id	Yes	-
`partner_ref`	string	No	-
`payment_term_id`	id	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Purchase Order

Route: PATCH /mutation/purchaseOrders

Entrees configurables

Name	Type	Required	Description
`lines`	string	Yes	-
`origin`	string	No	-
`partner_id`	id	Yes	-
`partner_ref`	string	No	-
`payment_term_id`	id	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Purchase Order

Route: DELETE /mutation/purchaseOrders

Entrees configurables

Name	Type	Required	Description
`lines`	string	Yes	-
`origin`	string	No	-
`partner_id`	id	Yes	-
`partner_ref`	string	No	-
`payment_term_id`	id	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Sales

Confirm Sales Order

Confirms a quotation: it becomes a sales order, ready to deliver and invoice.

Creation

Confirm Sales Order

Route: POST /mutation/salesOrderConfirm

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Sales Order Lines

The lines of quotations and sales orders (sale.order.line): product, quantities ordered, delivered and invoiced, prices.

Lecture

Sales Order Lines

The lines of quotations and sales orders (sale.order.line): product, quantities ordered, delivered and invoiced, prices.

Route: GET /salesOrderLines

Formule Excel: =LF.odoo.salesOrderLines("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`order_id`	id	No	Only the records of this sales order: one ID, or several comma-separated.
`product_id`	id	No	Only the records of this product: one ID, or several comma-separated.
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`order_id_name` default	string	—	-
`product_id_name` default	string	—	-
`product_uom_qty` default	number	—	-
`price_unit` default	number	—	-
`price_subtotal` default	number	—	-

Sales Orders

Quotations and sales orders (sale.order): customer, state, dates, totals and what remains to invoice.

Utilise comme filtre par

Sales Order Lines · order_id

Lecture

Sales Orders

Quotations and sales orders (sale.order): customer, state, dates, totals and what remains to invoice.

Route: GET /salesOrders

Formule Excel: =LF.odoo.salesOrders("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Only these records: one ID, or several comma-separated. An unknown ID answers no row.
`partner_id`	id	No	Only the records of this customer: one ID, or several comma-separated.
`state`	enum	No	Only these statuses: draft and sent for quotations, sale for orders. Values: draft, sent, sale, cancel
`invoice_status`	enum	No	Only these invoice statuses. Values: upselling, invoiced, to invoice, no
`name`	string	No	Only the records whose number contains this text (case-insensitive).
`client_order_ref`	string	No	Only the records whose customer reference contains this text (case-insensitive).
`date_order_from`	date	No	On or after this date (YYYY-MM-DD).
`date_order_to`	date	No	On or before this date (YYYY-MM-DD).
`per_page`	number	No	Rows per page (max 200) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`state` default	enum	—	-
`partner_id_name` default	string	—	-
`date_order` default	date	—	-
`currency_id_name` default	string	—	-
`amount_total` default	number	—	-

Creation

Create Sales Order

Route: POST /mutation/salesOrders

Entrees configurables

Name	Type	Required	Description
`client_order_ref`	string	No	-
`lines`	string	Yes	-
`origin`	string	No	-
`partner_id`	id	Yes	-
`payment_term_id`	id	No	-
`validity_date`	date	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Sales Order

Route: PATCH /mutation/salesOrders

Entrees configurables

Name	Type	Required	Description
`client_order_ref`	string	No	-
`lines`	string	Yes	-
`origin`	string	No	-
`partner_id`	id	Yes	-
`payment_term_id`	id	No	-
`validity_date`	date	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Sales Order

Route: DELETE /mutation/salesOrders

Entrees configurables

Name	Type	Required	Description
`client_order_ref`	string	No	-
`lines`	string	Yes	-
`origin`	string	No	-
`partner_id`	id	Yes	-
`payment_term_id`	id	No	-
`validity_date`	date	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.