Joinways

Count contacts matching filters.

count_people

Count quotes matching filters.

count_quotes

Count tasks matching filters.

count_tasks

Add an item to a venue catalog.

create_catalog_item

Create a company.

create_company

Create an event. company_name and contact_email auto-create rows if needed.

create_event

Create a contact.

create_person

Create a quote on an event. Returns quote_id.

create_quote

Create a task, optionally linked to an event.

create_task

Remove a catalog item.

delete_catalog_item

Permanently delete an event and its data.

delete_event

Delete a contact.

delete_person

Permanently delete a quote and its items.

delete_quote

Remove a single line item from a quote.

delete_quote_item

Delete a task.

delete_task

Generate a PDF for a quote (or its invoice once accepted), store it as a new version in `quote_pdfs`, and return a 1h signed URL the client can download. Mirrors the web download flow: if the quote is `accepted` without an invoice number, a legal invoice number is generated and persisted.

download_quote

Clone a quote with all its line items. The copy is a clean draft (status=draft, is_invoiced=false, signature_mode='manual'). Header snapshot (client, terms, reverse-charge flag) is preserved. Returns the new quote id.

duplicate_quote

Monthly event counts by status over the last 12 months.

get_events_analytics

AI-draft an email body for an event.

generate_email_draft

Full BEO (feuille de fonction): event-level fields (schedule, setup, notes, vendors, on-site contact, context), staff, day-of contacts, and per-day overrides. This is the canonical way to inspect everything an event's BEO holds.

get_beo

Full event with company/contact/venue/spaces/BEO. Excludes search vector and embedding.

get_event

Get full lead with ai_summary, requirements and metadata.

get_lead

Full quote with line items, totals and status.

get_quote_details

Venue with spaces and members.

get_venue

Business hours, blocked dates (closures) and enforcement mode for a venue or sub-space. Use `from`/`to` to scope closures to a date window.

get_venue_availability

Search events, companies and people.

global_search

Bulk-create public-holiday closures on a venue (`enable=true`) or remove all auto-imported ones (`enable=false`). Country is an ISO-3166 alpha-2 or alpha-3 code, e.g. "FR".

import_venue_holidays

Attach a lead to an existing event.

link_lead_to_event

Venue catalog (paginated). detail="full" includes description and tags.

list_catalog_items

List companies (paginated, compact summary). detail="full" includes enrichment_data.

list_companies

User Gmail/Outlook connections. Required before send.

list_email_connections

Available email templates.

list_email_templates

Day-of contacts for an event (on-site & remote): display name, role, phone, email, isOnsite, isPrimary, optional day pin. The primary contact is mirrored to events.onsite_contact_person_id.

list_event_contacts

Per-day rows for a multi-day event (setup/catering/technical/service overrides). Mono-day events return [] — fall back to the flat events.<col> values in that case. Rows are auto-created by a Postgres trigger when start_date/end_date change.

list_event_days

Emails linked to an event.

list_event_emails

Files attached to an event.

list_event_files

Notes attached to an event.

list_event_notes

BEO staff list for an event: display name, role, call/leave time, phone, email, notes, optional day pin.

list_event_staff

List events with company/contact/venue (paginated, compact summary). detail="full" returns every column.

list_events

List inbox leads (paginated, compact summary). The summary omits personal identifiers (client_email, client_phone); use detail="full" or get_lead to retrieve contact details plus ai_summary/requirements/metadata.

list_leads