find_vehicles_by_vin
ChatGPTFind a site's vehicles by exact VIN. Each result carries contactId, the owner for get_contact.
get_advisor_attribution
ChatGPTPer-advisor repair-order rollup for a site over a range: attributed vs organic ROs and revenue.
get_appointment
ChatGPTGet one appointment by its OriginId, scoped to a site.
get_attribution_trends
ChatGPTDaily attribution metrics for a site across a date range (booked/sold/revenue over time).
get_call
ChatGPTGet one call by its CallId, with AI summary, sentiment, tags and scorecard.
get_campaign
ChatGPTGet one campaign definition by its campaignId, scoped to a site.
get_campaign_attribution_summary
ChatGPTMarketing & sales attribution funnel for a site over a date range: campaign reach/sends, attributed vs organic journeys, engaged, booked, sold (RO count), revenue, gross profit, first-time split.
get_campaign_run
ChatGPTGet one campaign run by its runId, scoped to a site.
get_campaign_send
ChatGPTGet one campaign send by its sendId, scoped to a site.
get_contact
ChatGPTFull contact detail (Mongo contacts) by DcDocumentId or OriginId.
get_customer_journey
ChatGPTOne customer journey for a site: campaign touches + the linked event chain (calls, texts, appointments, ROs).
get_goals
ChatGPTGet shop goals for a site over a month range (YYYY-MM). Optionally include per-actor (advisor) goal rows.
get_message
ChatGPTFull message detail (Mongo messages: body/from/to/media) by its DcDocumentId.
get_profile
ChatGPTReturn the identity represented by the current connection. Use it to label or distinguish connected OktoRocket accounts; it does not list other users.
get_repair_order
ChatGPTFull repair-order detail (Mongo ro) by its DcDocumentId. Includes per-job line items (name, state approved/pending/declined, per-job labor/parts sales, cost and hours, authorized/completed timestamps) and RO-level labor/parts/sublet cost + gross profit, summed from approved line items (agrees with the RO-summary report). Cost is null when the document carries no line items.
get_repair_order_by_origin
ChatGPTSA fallback: a repair order that has only an OriginId (no Mongo doc), scoped to a site.
get_ro_summary
ChatGPTRepair-order financial totals for a site over a date range: RO count, sales, gross profit, labor/parts sales & cost, billed hours, ARO, close ratio, effective labor rate. Optionally broken down by advisor or tech. Matches the dashboard RO-overview report. Totals cover the row set named by viewType (default complete = closed/posted), so figures here will not match goal_vs_actual, which reports the created-this-month row set.
get_rollover
ChatGPTRollover trend for a site: the unclosed sold/posted balance carried into each month (sales, gross profit, billed hours, parts cost, ticket count), most recent first. Covers a nine-month window ending with the requested month, but months with no carried tickets are omitted, so fewer than nine entries is normal. Consecutive months can legitimately match to the cent when nothing opened or closed between them. Month defaults to the current month.
get_sales_per_day
ChatGPTSales-per-day pacing for a site's month: sales goal, sales so far, sales per workday so far, the sales per day still needed to hit the goal, and total vs remaining workdays. Month defaults to the current month. Matches the dashboard sales-per-day report: currentSales covers the row set named by viewType (default all = closed + WIP), which is why it can differ from goal_vs_actual's monthActual.
get_site
ChatGPTGet one site by its siteId.
get_site_employee_map
ChatGPTGet a site's raw employee map, including entries that resolve to no user.
get_transcript
ChatGPTGet the full transcript for a call. format: text (default), utterances, or both. Returns available=false when the call has no transcript.
get_user
ChatGPTGet one user by their userId, with their site employee mappings.
get_vehicle
ChatGPTGet one vehicle by its OriginId (external PMS vehicle id).
goal_vs_actual
ChatGPTMonthly sales pacing for a site: sales goal, month-to-date actual, sales carried in as rollover, projected end-of-month, projected year, and attainment %. Month defaults to the current month. monthActual covers the created-this-month row set, matching the dashboard sales-projections report — it is deliberately a different row set from get_ro_summary and get_sales_per_day, so the three do not agree by design.
list_appointments
ChatGPTList appointments for a site (cursor-paginated). Filter by date range, booking status, contactId, or updatedSince.
list_attribution_pipeline
ChatGPTPaged customer journeys for a site, filterable by funnel stage (touched/engaged/booked/sold), lead channel (call/text/appointment/ro), and advisor. This is the source for calls-for-RO — a journey's event chain links calls/texts/appointments to its RO.
list_calls
ChatGPTList calls for a site (cursor-paginated). Filter by date range, direction, minimum duration, label, AdvisorIQ range, contactId, phone, or answering extension.
list_campaign_performance
ChatGPTPer-campaign performance for a site over a range under a credit model: touches, booked, sold, revenue, gross profit — weighted per attributed journey.
list_campaign_runs
ChatGPTList campaign runs for a site (cursor-paginated): one entry per campaign execution, with when it ran and how its audience narrowed — matched, opted out, on deck, built. Filter by campaignId or a ran-at range. Counts are as recorded by the campaign engine; a null count means it was not recorded, which is not the same as zero.
list_campaign_sends
ChatGPTList campaign sends for a site (cursor-paginated): one entry per message actually sent, with its campaign, contact, channel type and send time. Filter by campaignId, contactId, type or a send-date range. Message bodies are not stored and so are never returned.
list_campaigns
ChatGPTList campaign definitions for a site (cursor-paginated): name, type, class, origin, enabled, run window, attribution settings. Filter by type, class, origin, enabled or updatedSince. For how a campaign PERFORMED, use the campaign attribution tools instead.
list_contact_vehicles
ChatGPTList the vehicles belonging to a contact, by the contact's DcDocumentId.
list_contacts
ChatGPTList contacts for a site (cursor-paginated). Optional free-text search (name/company/phone/email) and updatedSince.
list_messages
ChatGPTList messages for a site (cursor-paginated, metadata only). Filter by contactId or updatedSince. Bodies come from get_message. direction carries the carrier's own value, so expect outbound-api alongside inbound/outbound.
list_payments
ChatGPTPMS cash reporting: list paid repair orders for a site (cursor-paginated, newest paid first). Each row is money-only — amountPaid (total minus balance), total, balanceDue, the cashiered date, and the PMS payment-method breakdown — never card or processor data. from/to are the shop's local calendar dates (whole days in the shop's timezone) for daily totals. Sourced from the repair order the PMS relays; a shop that never relays a paid RO returns nothing.
list_repair_orders
ChatGPTList repair orders for a site (cursor-paginated, newest first). Filter by status (raw ShopData.StatusCode), date range, ticket number, VIN, contactId, or updatedSince.
list_reviews
ChatGPTList a site's Google and Carfax reviews, newest first (cursor-paginated): rating 1-5, comment, reviewer, the shop's reply, and the matched contactId/repairOrderId when known.
list_sites
ChatGPTList the sites (shops) this key can access, cursor-paginated. Returns siteId, name, clientName, timezone, active, softwareType.
list_users
ChatGPTList users (cursor-paginated) with their site employee mappings. Filter by siteId, status, or role id (PID).