get_contact | Get a contact by its id (from list_contacts). |
get_invoice | Get a customer invoice with its lines by its id (from list_invoices). |
get_order | Get a customer order with its lines by its id (from list_orders). |
get_product | Get a product or service by its id (from list_products). |
get_proposal | Get a commercial proposal with its lines by its id (from list_proposals). |
get_status | Check the connection: returns the Dolibarr version of the instance and whether access is locked. |
list_agenda_events | List agenda events (meetings, calls, logged actions). user_ids: events owned by these user ids (“1” or “1,2,3”). Filter columns: t.label, t.code (event type, e.g. AC_RDV, AC_TEL), t.datep (start), t.fk_soc (third party id), t.percent (-1 not applicable, 0 to do, 100 done). Default sort: t.id. limit: 1-100 (Dolibarr default 100); page: page number starting at 0; sortfield: “t.<column>”; sortorder: “ASC” or “DESC”; sqlfilters: Dolibarr filter syntax “(t.<column>:<operator>:‘<value>’)” combined with and/or, operators =, !=, <, >, <=, >=, like (with %), dates as ‘YYYY-MM-DD’. |
list_contacts | List contacts (people). thirdparty_ids: contacts of these third parties (“1” or “1,2,3”, ids from list_thirdparties). category: category id. Filter columns: t.lastname, t.firstname, t.email, t.poste, t.town, t.fk_soc, t.datec, e.g. “(t.email:like:’%@acme.fr’)”. limit: 1-100 (Dolibarr default 100); page: page number starting at 0; sortfield: “t.<column>”; sortorder: “ASC” or “DESC”; sqlfilters: Dolibarr filter syntax “(t.<column>:<operator>:‘<value>’)” combined with and/or, operators =, !=, <, >, <=, >=, like (with %), dates as ‘YYYY-MM-DD’. |
list_invoices | List customer invoices. thirdparty_ids: invoices of these third parties (“1” or “1,2,3”). status: “draft”, “unpaid”, “paid” or “cancelled”. Filter columns: t.ref, t.datef (invoice date), t.date_lim_reglement (due date), t.total_ttc, t.paye, t.fk_soc, e.g. “(t.date_lim_reglement:<:‘2026-09-30’)”. limit: 1-100 (Dolibarr default 100); page: page number starting at 0; sortfield: “t.<column>”; sortorder: “ASC” or “DESC”; sqlfilters: Dolibarr filter syntax “(t.<column>:<operator>:‘<value>’)” combined with and/or, operators =, !=, <, >, <=, >=, like (with %), dates as ‘YYYY-MM-DD’. |
list_orders | List customer orders. thirdparty_ids: orders of these third parties (“1” or “1,2,3”). Filter columns: t.ref, t.fk_statut (-1 canceled, 0 draft, 1 validated, 2 shipment in process, 3 closed), t.date_commande, t.total_ht, t.fk_soc. limit: 1-100 (Dolibarr default 100); page: page number starting at 0; sortfield: “t.<column>”; sortorder: “ASC” or “DESC”; sqlfilters: Dolibarr filter syntax “(t.<column>:<operator>:‘<value>’)” combined with and/or, operators =, !=, <, >, <=, >=, like (with %), dates as ‘YYYY-MM-DD’. |
list_products | List products and services. mode: 0 all (default), 1 products only, 2 services only. category: category id. Filter columns: t.ref, t.label, t.tosell, t.tobuy, t.fk_product_type, e.g. “(t.label:like:‘%cable%’)”. Default sort: t.ref. limit: 1-100 (Dolibarr default 100); page: page number starting at 0; sortfield: “t.<column>”; sortorder: “ASC” or “DESC”; sqlfilters: Dolibarr filter syntax “(t.<column>:<operator>:‘<value>’)” combined with and/or, operators =, !=, <, >, <=, >=, like (with %), dates as ‘YYYY-MM-DD’. |
list_projects | List projects. thirdparty_ids: projects of these third parties (“1” or “1,2,3”). category: category id. Filter columns: t.ref, t.title, t.fk_statut (0 draft, 1 open, 2 closed), t.dateo (start date), t.fk_soc. limit: 1-100 (Dolibarr default 100); page: page number starting at 0; sortfield: “t.<column>”; sortorder: “ASC” or “DESC”; sqlfilters: Dolibarr filter syntax “(t.<column>:<operator>:‘<value>’)” combined with and/or, operators =, !=, <, >, <=, >=, like (with %), dates as ‘YYYY-MM-DD’. |
list_proposals | List commercial proposals (quotes). thirdparty_ids: proposals of these third parties (“1” or “1,2,3”). Filter columns: t.ref, t.fk_statut (0 draft, 1 validated, 2 signed, 3 not signed, 4 billed), t.datep, t.total_ht, t.fk_soc, e.g. “(t.fk_statut:=:1)”. limit: 1-100 (Dolibarr default 100); page: page number starting at 0; sortfield: “t.<column>”; sortorder: “ASC” or “DESC”; sqlfilters: Dolibarr filter syntax “(t.<column>:<operator>:‘<value>’)” combined with and/or, operators =, !=, <, >, <=, >=, like (with %), dates as ‘YYYY-MM-DD’. |
list_thirdparties | List or read third parties (customers, prospects, suppliers). id: read one third party by its id. mode: 0 all (default), 1 customers, 2 prospects, 3 neither customer nor prospect, 4 suppliers. category: category id. Filter columns: t.nom (name), t.name_alias, t.email, t.town, t.zip, t.code_client, t.siren, t.siret, t.client, t.fournisseur, t.datec, e.g. “(t.nom:like:‘%acme%’)”. properties: optional array of fields to return (default: the usual business fields). limit: 1-100 (Dolibarr default 100); page: page number starting at 0; sortfield: “t.<column>”; sortorder: “ASC” or “DESC”; sqlfilters: Dolibarr filter syntax “(t.<column>:<operator>:‘<value>’)” combined with and/or, operators =, !=, <, >, <=, >=, like (with %), dates as ‘YYYY-MM-DD’. No match → Dolibarr answers 404 “No third parties found”. |