Data dictionary

Data dictionary

Every kind of record your company can read from HailMate, every field and its type. Jobs, contacts, invoices and the other resources are in the API reference; everything else is here.

Getting all of it, and keeping it current

  • Everything at once: POST /v1/actions/run_export_now makes one file (Excel, CSV or JSON, every field) and answers a download link. Settings → Export data does the same on a schedule, and can write it to your own storage.
  • Only what changed: add updated_since to any list. Read everything once, then ask for what changed since your last read.
  • What was deleted: GET /v1/audit_log?action=job.deleted,contact.deleted,record.deleted,media.deleted.
  • Power BI, Excel, Google Sheets, Tableau, Looker Studio: a live link from Settings → Export data.

Never raw database access: every read is as the person who made the key, inside one company, through the same rules as the app. Money fields are left out for a role that may not see prices. GET /v1/records answers this list as JSON.

Every other record: GET /v1/records/{kind}

analytics_alerts

Alerts on a number (yours). updated_since reads updated_at. Filter by active, cadence.

FieldTypeMay be empty
idtext
activeboolean
cadencetext
conditiontext
created_attext
last_checked_ontextyes
last_fired_attextyes
last_valuenumberyes
specjson
thresholdnumber
updated_attext

analytics_views

Charts in Reports (yours and the team's). updated_since reads updated_at. Filter by owner_id, made_by.

FieldTypeMay be empty
idtext
created_attext
made_bytext
owner_idtextyes
positionnumber
sizetext
specjson
titletext
updated_attext

api_request_log

Requests made with the company's API keys (to find what broke an integration). updated_since reads created_at. Filter by api_key_id, status, method, error_code.

FieldTypeMay be empty
idjson
api_key_idtextyes
created_attext
duration_msnumberyes
error_codetextyes
error_messagetextyes
methodtext
request_idtext
routetext
statusnumber

automation_runs

Automation runs. updated_since reads created_at. Filter by automation_type, status.

FieldTypeMay be empty
idtext
automation_typetext
created_attext
detailjson
event_keytext
statustext

calendar_members

Who is on each calendar. updated_since reads created_at. Filter by calendar_id, user_id.

FieldTypeMay be empty
calendar_idtext
user_idtext
sees_allboolean
created_attext

calendars

Calendars (Sales, Production, ...). updated_since reads updated_at.

FieldTypeMay be empty
idtext
auto_join_rolestext[]
colortext
created_attext
created_bytextyes
default_for_typestext[]
members_see_allboolean
nametext
positionnumber
updated_attext

call_transfers

Calls passed from one teammate to another. updated_since reads created_at. Filter by contact_id, from_user_id, to_user_id, status.

FieldTypeMay be empty
idtext
contact_idtextyes
contact_nametextyes
contact_phonetextyes
created_attext
directiontext
from_user_idtext
phone_number_idtextyes
seconds_beforenumberyes
statustext
to_user_idtext

canvassing_knock_checks

Knock checks: how far the rep stood from the door. updated_since reads knocked_at. Filter by knock_id, pin_id, user_id, source.

FieldTypeMay be empty
knock_idtext
accuracy_mnumberyes
created_attext
distance_mnumberyes
is_mockedboolean
knocked_attext
missingtextyes
pin_idtext
position_attextyes
reviewed_attextyes
reviewed_bytextyes
sourcetext
user_idtextyes

canvassing_knocks

Door knocks: every knock on every door. updated_since reads knocked_at. Filter by pin_id, user_id, knock_result.

FieldTypeMay be empty
idtext
knock_resulttext
knocked_attext
pin_idtext
user_idtextyes

canvassing_pin_history

A door's result over time. updated_since reads changed_at. Filter by pin_id, source, new_pin_type.

FieldTypeMay be empty
idtext
changed_attext
new_pin_typetext
old_pin_typetextyes
pin_idtext
sourcetext

commission_ledger

Commission draws and base pay. updated_since reads created_at. Filter by kind, user_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
amountnumber
commission_idstext[]
counts_as_drawboolean
created_attext
kindtext
notetextyes
occurred_ontext
period_endtextyes
period_starttextyes
user_idtext

commission_pay_settings

Base pay settings. updated_since reads updated_at. Filter by user_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
user_idtext
base_pay_is_drawboolean
base_pay_starts_ontextyes
base_pay_weeklynumberyes
created_attext
updated_attext

commission_rule_rates

Commission rates. updated_since reads created_at. Filter by rule_id, setter_rule_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
created_attext
flat_amountnumberyes
job_typetextyes
lead_sourcetextyes
rate_percentnumber
rule_idtextyes
setter_rule_idtextyes
when_splitboolean

commission_rules

Commission plans. updated_since reads updated_at. Filter by user_id, is_active. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
basistext
company_cut_percentnumber
created_attext
flat_amountnumber
is_activeboolean
rate_percentnumber
updated_attext
user_idtextyes

commission_setter_rules

Setter commission plans. updated_since reads updated_at. Filter by user_id, is_active. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
basistext
company_cut_percentnumber
created_attext
flat_amountnumber
is_activeboolean
rate_percentnumber
updated_attext
user_idtextyes

commission_settings

When commissions come due. updated_since reads updated_at. Money: left out for a role that may not see prices.

FieldTypeMay be empty
created_attext
owed_whentext
setuptextyes
updated_attext

Jobs linked to CompanyCam projects. updated_since reads updated_at. Filter by job_id, companycam_project_id.

FieldTypeMay be empty
idtext
companycam_project_idtext
created_attext
created_bytextyes
job_idtext
last_pulled_attextyes
link_sourcetext
project_nametextyes
project_urltextyes
updated_attext

crew_days_off

Crews' days off. updated_since reads updated_at. Filter by crew_id.

FieldTypeMay be empty
idtext
created_attext
crew_idtext
starts_ontext
ends_ontext
reasontextyes
created_bytextyes

crew_documents

Crews' papers. updated_since reads created_at. Filter by crew_id, kind.

FieldTypeMay be empty
idtext
created_attext
crew_idtextyes
expires_ontextyes
file_nametextyes
kindtext
labeltextyes
storage_pathtext
uploaded_bytextyes

crew_invites

Crew and sub invitations. updated_since reads updated_at. Filter by crew_id, status, kind, sub_company_id.

FieldTypeMay be empty
idtext
created_attext
crew_idtextyes
invited_bytextyes
is_leadboolean
joined_attextyes
kindtext
languagetext
last_sent_attextyes
nametext
phonetext
send_countnumber
statustext
sub_company_idtextyes
updated_attext
user_idtextyes
work_order_idtextyes

crew_join_requests

Helpers asking to join a crew. updated_since reads created_at. Filter by crew_id, status, job_id.

FieldTypeMay be empty
idtext
created_attext
crew_idtextyes
decided_attextyes
decided_bytextyes
invite_idtextyes
job_idtextyes
nametext
phonetext
statustext
work_order_idtextyes

crew_members

Who is on each crew. updated_since reads created_at. Filter by crew_id, user_id, is_lead.

FieldTypeMay be empty
crew_idtext
user_idtext
is_leadboolean
created_attext

crew_paper_requests

Papers asked of crews (insurance, W-9…). updated_since reads created_at. Filter by crew_id, sub_company_id.

FieldTypeMay be empty
idtext
created_attext
crew_idtextyes
fulfilled_attextyes
kindstext[]
last_sent_attextyes
notetextyes
requested_bytextyes
sent_totextyes
sub_company_idtextyes

crew_rates

Crews' rate cards. updated_since reads updated_at. Filter by crew_id, unit. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
created_attext
crew_idtextyes
labeltext
positionnumber
ratenumber
unittext
updated_attext

crews

Crews. updated_since reads updated_at. Filter by active, contact_id, kind, sub_company_id.

FieldTypeMay be empty
idtext
activeboolean
colortext
contact_idtextyes
created_attext
emailtextyes
kindtext
nametext
notestextyes
phonetextyes
squares_per_daynumberyes
sub_company_idtextyes
tradestext[]
updated_attext

data_credit_ledger

Storm list data credits used and bought. updated_since reads created_at. Filter by reason, storm_list_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
created_attext
created_bytextyes
deltanumber
notetextyes
reasontext
storm_list_idtextyes

data_export_destinations

Your own storage scheduled exports are written to (never its secret). updated_since reads updated_at.

FieldTypeMay be empty
idtext
access_key_idtext
buckettext
created_attext
created_bytextyes
endpointtext
last_check_okbooleanyes
last_checked_attextyes
last_delivered_attextyes
last_errortextyes
nametext
path_styleboolean
prefixtext
regiontext
updated_attext
updated_bytextyes

data_export_runs

Export files made (scheduled, now, by the API). updated_since reads created_at. Filter by kind, schedule_id, status, requested_by.

FieldTypeMay be empty
idtext
created_attext
deliver_to_scheduleboolean
deliveredjson
delivered_tojsonyes
errortextyes
expires_attext
file_bytesnumberyes
file_nametextyes
finished_attextyes
formattext
itemsjson
kindtext
nametext
partsjson
requested_bytextyes
row_countnumberyes
schedule_idtextyes
started_attextyes
statustext

data_export_schedules

Scheduled exports. updated_since reads updated_at. Filter by cadence, created_by, paused, destination_id.

FieldTypeMay be empty
idtext
cadencetext
created_attext
created_bytext
deliver_emailstext[]
deliver_memberstext[]
destination_idtextyes
failure_countnumber
formattext
hournumber
itemsjson
last_run_attextyes
last_run_idtextyes
last_statustextyes
month_daynumberyes
nametext
next_run_attext
pausedboolean
paused_reasontextyes
time_zonetext
updated_attext
weekdaynumberyes

data_feeds

Live links (owners and admins). updated_since reads created_at. Filter by created_by.

FieldTypeMay be empty
idtext
created_attext
created_bytext
itemjson
last_used_attextyes
nametext
revoked_attextyes
use_countnumber

data_import_run_records

What each import made or changed (with the values it overwrote). updated_since reads created_at. Filter by run_id, entity_type, action, record_id.

FieldTypeMay be empty
actiontext
created_attext
entity_typetext
previousjsonyes
record_idtext
run_idtext

data_import_runs

Imports (each file brought in from Settings, what it made, and its undo). updated_since reads created_at. Filter by source, status, created_by.

FieldTypeMay be empty
idtext
countsjson
created_attext
created_bytextyes
file_nametextyes
finished_attextyes
row_countnumber
sourcetext
statustext
undone_attextyes
undone_bytextyes

document_templates

Contract templates. updated_since reads updated_at. Filter by doc_type.

FieldTypeMay be empty
idtext
blocksjson
created_attextyes
descriptiontextyes
doc_typetext
nametext
pdf_formjsonyes
updated_attextyes

email_location_senders

The mailbox each location's automated email is sent from. updated_since reads updated_at.

FieldTypeMay be empty
mailbox_idtextyes
set_bytextyes
updated_attext

email_mailbox_locations

Which locations share a company mailbox. updated_since reads created_at. Filter by mailbox_id.

FieldTypeMay be empty
mailbox_idtext
everyoneboolean
created_attext

email_mailbox_members

Who shares each company mailbox. updated_since reads created_at. Filter by mailbox_id, user_id.

FieldTypeMay be empty
mailbox_idtext
user_idtext
created_attext

email_signatures

Email signatures. updated_since reads updated_at. Filter by is_default, user_id.

FieldTypeMay be empty
idtext
bodytext
created_attext
designjsonyes
formattext
htmltextyes
is_defaultboolean
nametext
updated_attext
user_idtext

email_templates

Email templates. updated_since reads updated_at. Filter by is_shared.

FieldTypeMay be empty
idtext
bodytext
created_attext
is_sharedboolean
nametext
subjecttext
updated_attext

email_thread_assignments

Who owns each email thread. updated_since reads assigned_at. Filter by thread_id, user_id.

FieldTypeMay be empty
thread_idtext
user_idtext
assigned_attext
assigned_bytextyes

estimate_auto_drafts

Estimates a measurement report drafted. Filter by job_id, estimate_id, state.

FieldTypeMay be empty
idtext
estimate_idtextyes
job_idtext
measurement_idtextyes
start_reftext
statetext
drafted_attext
refitted_attextyes

estimate_photos

Photos on an estimate. updated_since reads created_at. Filter by estimate_id, file_id, section_id.

FieldTypeMay be empty
idtext
captiontextyes
created_attextyes
display_ordernumber
estimate_idtext
file_idtextyes
file_nametextyes
include_in_pdfboolean
media_kindtext
mime_typetextyes
photo_urltext
section_idtextyes

estimate_pricing_packages

Good, better, best options on an estimate. updated_since reads updated_at. Filter by estimate_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
created_attext
descriptiontextyes
display_ordernumber
estimate_idtext
is_enabledboolean
nametext
tier_keytext
updated_attext

estimate_sections

Sections of an estimate. updated_since reads updated_at. Filter by estimate_id, section_type.

FieldTypeMay be empty
idtext
contentjsonyes
created_attextyes
display_ordernumber
estimate_idtext
is_visiblebooleanyes
section_typetext
show_titleboolean
tiertextyes
titletextyes
updated_attextyes

estimate_settings

Estimate and invoice settings. updated_since reads updated_at. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
boldsign_sender_emailtextyes
boldsign_sender_statustextyes
company_insurance_infotextyes
company_license_numbertextyes
created_attextyes
default_cost_per_squarenumberyes
default_labor_cost_per_squarenumberyes
default_material_cost_per_squarenumberyes
default_price_per_squarenumberyes
default_tax_ratenumberyes
default_terms_and_conditionstextyes
default_valid_daysnumberyes
deposit_percentnumberyes
invoice_default_due_daysnumberyes
invoice_default_notestextyes
invoice_default_tax_ratenumberyes
invoice_default_termstextyes
min_margin_percentnumberyes
pdf_primary_colortextyes
updated_attextyes

estimate_signers

Who signs an estimate. updated_since reads updated_at. Filter by estimate_id, status.

FieldTypeMay be empty
idtext
boldsign_signer_statustextyes
created_attextyes
estimate_idtext
signed_attextyes
signer_emailtext
signer_nametext
signer_ordernumberyes
signer_roletextyes
statustextyes
updated_attextyes

estimate_templates

Estimate templates. updated_since reads updated_at. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
created_attext
created_bytextyes
descriptiontextyes
nametext
template_datajson
updated_attext

estimate_view_events

When a homeowner opened an estimate. updated_since reads created_at. Filter by estimate_id, event_type.

FieldTypeMay be empty
idtext
created_attextyes
estimate_idtext
event_datajsonyes
event_typetext

estimate_warranty_options

Warranty choices on an estimate. updated_since reads updated_at. Filter by estimate_id, section_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
created_attext
descriptiontextyes
display_ordernumber
estimate_idtext
is_recommendedboolean
nametext
pricenumberyes
section_idtext
term_labeltextyes
updated_attext

external_record_map

Records brought in from other software, with their ids there. updated_since reads updated_at. Filter by source, entity_type, internal_id, external_id.

FieldTypeMay be empty
idtext
created_attext
entity_typetext
external_idtext
internal_idtext
sourcetext
updated_attext

file_money_suggestions

Money read off a file. updated_since reads created_at. Filter by file_id, status. Money: left out for a role that may not see prices.

FieldTypeMay be empty
file_idtext
amountnumberyes
check_numbertextyes
completed_attextyes
cost_categorytextyes
created_attext
dismissed_attextyes
document_datetextyes
document_kindtextyes
payer_typetextyes
statustext

homeowner_lead_offers

Homeowner leads offered to the company. updated_since reads created_at. Filter by request_id.

FieldTypeMay be empty
idtext
claimed_attextyes
created_attext
distance_minumberyes
notified_attextyes
notify_channeltextyes
releases_attext
request_idtext

incoming_payments

Payments another app sent that wait for a person to place them. updated_since reads created_at. Filter by state, processor, kind. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
amountnumber
created_attext
customer_emailtextyes
customer_nametextyes
customer_phonetextyes
date_receivedtext
depositedboolean
descriptiontextyes
invoice_numbertextyes
job_numbertextyes
kindtext
notestextyes
original_referencetextyes
payment_idtextyes
payment_methodtextyes
processortext
processor_feenumberyes
processor_referencetext
resolved_attextyes
statetext
waiting_becausetextyes

inspection_templates

Inspection checklists. updated_since reads updated_at. Filter by archived.

FieldTypeMay be empty
idtext
archivedboolean
based_ontextyes
created_attext
descriptiontextyes
itemsjson
nametext
rulesjsonyes
updated_attext

inspections

Inspections. updated_since reads updated_at. Filter by job_id, status, template_key.

FieldTypeMay be empty
idtext
answersjson
damagetextyes
finished_attextyes
itemsjson
job_idtext
slope_countnumber
started_attext
statustext
template_keytext
template_nametext
updated_attext

job_access_requests

Teammates asking to see a job. updated_since reads created_at. Filter by job_id, user_id, resolution.

FieldTypeMay be empty
idtext
created_attext
job_idtext
resolutiontextyes
resolved_attextyes
resolved_bytextyes
user_idtext

job_checklist_item_photos

Photos on items of a job's checklists. updated_since reads created_at. Filter by item_id, job_id, file_id.

FieldTypeMay be empty
idtext
item_idtext
file_idtext
job_idtext
positionnumber
created_bytextyes
created_attext

job_checklist_items

Items on a job's checklists. updated_since reads updated_at. Filter by checklist_id, job_id, status.

FieldTypeMay be empty
idtext
checklist_idtext
created_attext
headingtextyes
job_idtext
labeltext
notetextyes
photo_file_idtextyes
positionnumber
quantitynumberyes
statustext
status_attextyes
status_bytextyes
unittextyes
updated_attext

job_checklist_templates

Company job checklists. updated_since reads updated_at.

FieldTypeMay be empty
idtext
auto_add_stage_idstext[]
created_attext
itemsjson
nametext
positionnumber
starter_keytextyes
updated_attext

job_checklists

Checklists on jobs. updated_since reads updated_at. Filter by job_id, template_id.

FieldTypeMay be empty
idtext
added_at_stage_idtextyes
added_bytextyes
created_attext
job_idtext
nametext
removed_attextyes
template_idtextyes
updated_attext

job_commissions

Commissions on jobs. updated_since reads updated_at. Filter by job_id, role, status, user_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
amountnumber
basistext
basis_amountnumber
company_cut_percentnumber
created_attext
flat_amountnumber
job_idtext
notetextyes
paid_attextyes
rate_percentnumber
roletext
statustext
updated_attext
user_idtext

job_document_signers

Who signs a contract. updated_since reads updated_at. Filter by document_id, status.

FieldTypeMay be empty
idtext
boldsign_signer_statustextyes
created_attextyes
document_idtext
signed_attextyes
signer_emailtext
signer_nametext
signer_ordernumber
signer_roletext
statustext
updated_attextyes

job_documents

Contracts and job documents. updated_since reads updated_at. Filter by job_id, status, template_id, doc_type.

FieldTypeMay be empty
idtext
blocksjson
created_attextyes
doc_typetext
document_numbertext
job_idtext
pdf_generated_attextyes
pdf_urltextyes
sent_attextyes
signature_field_defsjsonyes
signature_methodtextyes
signed_attextyes
signed_pdf_urltextyes
signersjsonyes
statustext
template_idtextyes
titletext
updated_attextyes

job_role_settings

Which roles a company uses on its jobs. updated_since reads updated_at.

FieldTypeMay be empty
canvasser_onboolean
project_manager_onboolean
created_attext
updated_attext

job_setters

Who set each job. updated_since reads updated_at. Filter by job_id, user_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
job_idtext
created_attext
sourcetext
updated_attext
user_idtext

Job-site sign links. updated_since reads updated_at. Filter by job_id.

FieldTypeMay be empty
idtext
created_attext
guest_uploadsboolean
job_idtext
updated_attext

job_stage_visits

Time in stage: each stay of a job in a stage. updated_since reads entered_at. Filter by job_id, pipeline_id, stage, moved_by.

FieldTypeMay be empty
idtext
entered_attext
entered_knownboolean
job_idtext
left_attextyes
left_knownboolean
moved_bytextyes
next_stagetextyes
pipeline_idtextyes
stagetext

Leads that came in through a lead link. updated_since reads received_at. Filter by lead_link_id, outcome, job_id, contact_id.

FieldTypeMay be empty
idtext
contact_idtextyes
detailtextyes
job_idtextyes
lead_link_idtext
outcometext
payloadjsonyes
received_attext

Lead links. updated_since reads updated_at. Filter by enabled, kind, pipeline_id.

FieldTypeMay be empty
idtext
assigned_totextyes
created_attext
enabledboolean
kindtext
last_received_attextyes
lead_sourcetextyes
nametext
pipeline_idtextyes
price_pageboolean
received_countnumber
stage_keytextyes
updated_attext

leaderboard_contests

Leaderboard contests (a number, days and a prize). updated_since reads updated_at. Filter by metric, scope.

FieldTypeMay be empty
idtext
created_attext
created_bytextyes
ends_ontext
metrictext
prizetextyes
scopetext
starts_ontext
titletext
updated_attext

leaderboard_goals

Leaderboard goals (a target per number). updated_since reads updated_at. Filter by per.

FieldTypeMay be empty
metrictext
pertext
targetnumber
updated_attext
updated_bytextyes

mail_do_not_mail

Homes never to mail. updated_since reads created_at. Filter by reason.

FieldTypeMay be empty
idtext
addresstext
address_keytext
created_attext
created_bytextyes
reasontext

mail_orders

Postcard mailings. updated_since reads updated_at. Filter by status, job_id, source, automation, followup_of. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
audiencejson
automationtextyes
canceled_attextyes
card_countnumber
cents_per_cardnumber
codetext
contentjson
created_attext
created_bytextyes
delivered_attextyes
errortextyes
followup_daysnumberyes
followup_oftextyes
homes_foundnumber
job_idtextyes
mail_datetextyes
mailed_attextyes
paid_attextyes
paid_bytextyes
product_keytext
providertextyes
refunded_centsnumber
sent_attextyes
sourcetext
statustext
storm_datetextyes
summaryjson
template_keytext
titletext
total_centsnumber
updated_attext

mail_recipients

Homes a mailing went to. updated_since reads created_at. Filter by order_id, status, job_id, lead_job_id, pin_id.

FieldTypeMay be empty
idtext
addresstext
assessed_valuenumberyes
citytextyes
codetext
created_attext
delivered_attextyes
distance_minumberyes
hail_size_innumberyes
job_idtextyes
latitudenumberyes
lead_attextyes
lead_job_idtextyes
longitudenumberyes
order_idtext
owner_occupiedbooleanyes
pin_idtextyes
ranknumber
scan_countnumber
scanned_attextyes
skip_reasontextyes
statetextyes
statustext
to_addresstextyes
to_address2textyes
to_citytextyes
to_nametextyes
to_statetextyes
to_ziptextyes
year_builtnumberyes
ziptextyes

mail_scans

A mailing's QR codes scanned. updated_since reads created_at. Filter by order_id, recipient_id, kind, job_id.

FieldTypeMay be empty
idtext
created_attext
job_idtextyes
kindtext
order_idtext
recipient_idtextyes

material_order_items

Lines on a material order. updated_since reads updated_at. Filter by material_order_id, product_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
created_attextyes
descriptiontextyes
display_ordernumber
line_totalnumber
material_order_idtext
nametext
product_idtextyes
quantitynumber
supplier_descriptiontextyes
supplier_item_numbertextyes
unit_costnumber
uomtextyes
updated_attextyes

material_order_template_items

Lines on a material order template. updated_since reads updated_at. Filter by template_id, product_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
basistext
created_attext
descriptiontextyes
display_ordernumber
min_quantitynumber
nametext
per_unitnumber
product_idtextyes
round_upboolean
supplier_item_numbertextyes
template_idtext
unit_costnumber
uomtextyes
updated_attext
waste_pctnumber

material_order_templates

Material order templates. updated_since reads updated_at. Filter by supplier_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
created_attext
nametext
notestextyes
supplier_idtextyes
updated_attext

material_orders

Material orders. updated_since reads updated_at. Filter by job_id, status, supplier_id, estimate_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
additional_chargesjson
created_attextyes
delivery_addresstextyes
delivery_datetextyes
delivery_notestextyes
estimate_idtextyes
job_idtextyes
notestextyes
order_numbertext
sent_attextyes
statustext
subtotalnumber
supplier_idtextyes
tax_amountnumber
tax_ratenumber
total_amountnumber
updated_attextyes

measurement_orders

Roof measurement orders (EagleView, Hover…). updated_since reads updated_at. Filter by job_id, provider, status. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
addresstextyes
citytextyes
completed_attextyes
cost_amountnumberyes
created_attext
error_messagetextyes
external_order_idtextyes
job_cost_idtextyes
job_idtext
measurement_idtextyes
ordered_attext
productjson
providertext
quoted_maxnumberyes
quoted_minnumberyes
report_file_idtextyes
requested_bytextyes
statetextyes
statustext
updated_attext
ziptextyes

member_activity

When each teammate was last active. updated_since reads last_active_at. Filter by user_id.

FieldTypeMay be empty
user_idtext
last_active_attext

money_targets

Monthly money goals. updated_since reads updated_at. Money: left out for a role that may not see prices.

FieldTypeMay be empty
created_attext
monthly_collected_goalnumberyes
monthly_overheadnumberyes
monthly_sold_goalnumberyes
updated_attext
updated_bytextyes

note_mentions

Teammates mentioned in notes. updated_since reads created_at. Filter by job_id, mentioned_user_id, note_id.

FieldTypeMay be empty
idtext
created_attextyes
job_idtext
mentioned_user_idtext
note_idtext

notifications

Alerts. updated_since reads created_at. Filter by job_id, read, task_id, type, user_id.

FieldTypeMay be empty
idtext
created_attextyes
job_idtextyes
messagetextyes
note_idtextyes
readbooleanyes
read_attextyes
snoozed_untiltextyes
task_idtextyes
titletext
typetext
user_idtext

partner_portals

Partner portals. updated_since reads updated_at. Filter by enabled. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
company_nametext
contact_emailtextyes
created_attext
data_rate_centsnumberyes
enabledboolean
last_seen_attextyes
max_properties_per_buildnumberyes
parcels_enabledboolean
slugtext
updated_attext

payment_imports

Payment imports (files from a processor or bank). updated_since reads created_at. Filter by processor, created_by. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
created_attext
created_bytextyes
file_nametextyes
line_countnumber
processortext
recorded_countnumber
refund_countnumber
skipped_countnumber
total_amountnumber
undone_attextyes
undone_bytextyes

phone_line_members

Who answers each phone line. updated_since reads created_at. Filter by phone_number_id, user_id.

FieldTypeMay be empty
phone_number_idtext
user_idtext
created_attext

phone_number_requests

Teammates asking for a phone number. updated_since reads created_at. Filter by status, user_id.

FieldTypeMay be empty
idtext
created_attext
notetextyes
phone_number_idtextyes
resolved_attextyes
resolved_bytextyes
statustext
user_idtext

photo_comments

Comments on photos. updated_since reads created_at. Filter by file_id, pin_photo_id, user_id.

FieldTypeMay be empty
idtext
bodytext
created_attext
file_idtextyes
mentioned_user_idstext[]
pin_photo_idtextyes
user_idtext

photo_galleries

Shared photo galleries. updated_since reads created_at. Filter by job_id.

FieldTypeMay be empty
idtext
created_attext
expires_attextyes
job_idtext
last_viewed_attextyes
revoked_attextyes
titletext
view_countnumber

Photos in a shared gallery. Filter by gallery_id, file_id.

FieldTypeMay be empty
gallery_idtext
file_idtext
positionnumber

photo_report_templates

Photo report templates. updated_since reads updated_at.

FieldTypeMay be empty
idtext
bodyjson
created_attext
nametext
updated_attext

photo_suggestions

Suggested photo captions. updated_since reads created_at. Filter by file_id, status.

FieldTypeMay be empty
file_idtext
accepted_attextyes
captiontextyes
created_attext
damagetextyes
dismissed_attextyes
roof_phasetextyes
shot_keytextyes
statustext

pin_photos

Photos on a door knock. updated_since reads created_at. Filter by pin_id.

FieldTypeMay be empty
idtext
created_attextyes
descriptiontextyes
file_pathtext
filenametextyes
latitudenumberyes
longitudenumberyes
mime_typetextyes
pin_idtext
tagstext[]
taken_attextyes
thumbnail_pathtextyes

pipeline_stage_people

Who is put on a job at each stage. updated_since reads created_at. Filter by stage_id, user_id.

FieldTypeMay be empty
stage_idtext
user_idtext
created_attext
created_bytextyes

proposal_templates

Proposal templates. updated_since reads updated_at.

FieldTypeMay be empty
idtext
cover_intro_texttextyes
cover_titletextyes
created_attextyes
created_bytextyes
descriptiontextyes
footer_texttextyes
is_defaultbooleanyes
nametext
terms_and_conditionstextyes
updated_attextyes
valid_daysnumberyes

queued_messages

Texts and emails waiting to send (scheduled, or typed with no signal). updated_since reads updated_at. Filter by channel, contact_id, job_id, status.

FieldTypeMay be empty
idtext
bodytext
channeltext
contact_idtextyes
created_attext
job_idtextyes
last_errortextyes
made_attext
send_attextyes
sent_attextyes
statustext
subjecttextyes
to_emailstext[]
to_phonetextyes
updated_attext
user_idtext

quickbooks_sync_log

What went to and came from QuickBooks. updated_since reads at. Filter by entity_type, entity_id, direction, action, target.

FieldTypeMay be empty
idtext
actiontext
attext
directiontext
entity_idtextyes
entity_typetext
labeltextyes
messagetextyes
quickbooks_idtextyes
targettext

quickbooks_sync_records

Records in QuickBooks, with their QuickBooks ids. updated_since reads updated_at. Filter by entity_type, entity_id, sync_status, target.

FieldTypeMay be empty
idtext
attached_pdftextyes
created_attext
entity_idtext
entity_typetext
last_errortextyes
origintext
quickbooks_idtextyes
removed_in_bookstextyes
sync_statustext
synced_attextyes
targettext
updated_attext

rep_territories

Reps' territories. updated_since reads updated_at.

FieldTypeMay be empty
idtext
archived_attextyes
assignee_idstext[]
colortext
created_attext
geojsonjson
nametext
updated_attext

roof_facts

Roof facts on a job. updated_since reads updated_at. Filter by job_id.

FieldTypeMay be empty
job_idtext
created_attext
factsjson
updated_attext
vision_photo_countnumberyes
vision_ran_attextyes
vision_requested_attextyes

roof_readings

Satellite roof readings. updated_since reads measured_at.

FieldTypeMay be empty
idtext
addresstextyes
building_nametextyes
created_bytextyes
facet_countnumberyes
imagery_datetextyes
imagery_qualitytextyes
latitudenumber
longitudenumber
measured_attext
pitch_degreesnumberyes
predominant_pitchtextyes
total_area_sqftnumber
total_squaresnumber
tree_cover_sharenumberyes

saved_reports

Saved reports (yours and the team's). updated_since reads updated_at. Filter by owner_id, folder, pinned, template_key.

FieldTypeMay be empty
idtext
created_attext
descriptiontextyes
foldertextyes
owner_idtextyes
pinnedboolean
specjson
template_keytextyes
titletext
updated_attext
viewjson

scheduled_automation_messages

Automation messages waiting to send. updated_since reads updated_at. Filter by automation_type, contact_id, job_id, rule_id, status.

FieldTypeMay be empty
idtext
automation_typetext
contact_idtextyes
created_attext
job_idtext
resolved_attextyes
rule_idtext
send_aftertext
statustext
trigger_stage_keytext
updated_attext

scheduled_emails

Emails scheduled to send later. updated_since reads updated_at. Filter by contact_id, job_id, status, user_id.

FieldTypeMay be empty
idtext
contact_idtextyes
created_attext
job_idtextyes
send_attext
sent_attextyes
statustext
subjecttext
to_emailstext[]
updated_attext
user_idtext

showcase_photos

Photos on the company showcase. Filter by file_id.

FieldTypeMay be empty
file_idtext
added_attext
heightnumberyes
widthnumberyes

Contacts shared with a sister company. updated_since reads created_at. Filter by record_id, link_group, origin.

FieldTypeMay be empty
record_idtext
created_attext
created_bytextyes
howtext
link_grouptext
origintext
sent_from_workspace_idtextyes

Jobs shared with a sister company. updated_since reads created_at. Filter by record_id, link_group, origin.

FieldTypeMay be empty
record_idtext
created_attext
created_bytextyes
howtext
link_grouptext
origintext
sent_from_workspace_idtextyes

sms_broadcast_recipients

Who a text blast went to. updated_since reads created_at. Filter by broadcast_id, contact_id, job_id, status.

FieldTypeMay be empty
idtext
broadcast_idtext
contact_idtextyes
created_attext
delivered_attextyes
errortextyes
first_nametextyes
job_idtextyes
last_nametextyes
phonetext
sent_attextyes
skip_reasontextyes
statustext

sms_broadcasts

Text blasts. updated_since reads updated_at. Filter by status.

FieldTypeMay be empty
idtext
bodytext
completed_attextyes
created_attext
nametextyes
scheduled_fortextyes
started_attextyes
statustext
total_recipientsnumber
updated_attext

sms_conversation_assignments

Who owns each text conversation. updated_since reads assigned_at. Filter by conversation_id, user_id.

FieldTypeMay be empty
conversation_idtext
user_idtext
assigned_attext
assigned_bytextyes

sms_conversations

Text conversations. updated_since reads updated_at. Filter by contact_id, status, user_id.

FieldTypeMay be empty
idtext
contact_idtextyes
contact_phonetext
created_attextyes
last_directiontextyes
last_message_attextyes
last_message_previewtextyes
statustextyes
unread_countnumberyes
updated_attextyes
user_idtextyes

spotio_appointments

Appointments from Spotio. updated_since reads updated_at. Filter by lead_spotio_id, task_id.

FieldTypeMay be empty
spotio_idtext
completedboolean
created_attext
deleted_attextyes
duration_minutesnumberyes
last_event_attextyes
lead_spotio_idtextyes
starts_attextyes
task_idtextyes
updated_attext

spotio_leads

Leads from Spotio. updated_since reads updated_at. Filter by spotio_id, job_id, contact_id, credited_user_id.

FieldTypeMay be empty
idtext
addresstextyes
citytextyes
contact_idtextyes
created_attext
credited_user_idtextyes
deleted_attextyes
job_idtextyes
last_visit_attextyes
last_visit_resulttextyes
latitudenumberyes
longitudenumberyes
nametextyes
owner_spotio_idtextyes
pin_idtextyes
pushed_attextyes
spotio_idtext
spotio_updated_attextyes
stage_idtextyes

spotio_reps

Reps in Spotio, and who each is here. updated_since reads updated_at. Filter by user_id, suspended.

FieldTypeMay be empty
spotio_user_idtext
appointmentsnumber
doorsnumber
emailtextyes
first_seen_attext
last_seen_attext
matched_bytextyes
nametextyes
phonetextyes
spotio_roletextyes
suspendedboolean
updated_attext
user_idtextyes

storm_digest_settings

Morning storm digest settings. updated_since reads updated_at.

FieldTypeMay be empty
created_attext
enabledboolean
immediate_alert_size_innumberyes
min_cell_countnumber
min_size_innumber
updated_attext
whole_usboolean

storm_list_segments

Parts of a storm list. updated_since reads updated_at. Filter by storm_list_id.

FieldTypeMay be empty
idtext
created_attext
filtersjson
nametext
piece_countnumberyes
storm_list_idtext
updated_attext

sub_companies

Subcontractor companies. updated_since reads updated_at. Filter by active, owner_user_id.

FieldTypeMay be empty
idtext
activeboolean
created_attext
languagetext
nametext
notestextyes
owner_nametextyes
owner_phonetextyes
owner_user_idtextyes
updated_attext

supplement_asks

Items asked for on supplements. updated_since reads created_at. Filter by case_id, job_id, submission_id, state. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
amountnumberyes
buckettextyes
carrier_nametextyes
case_idtextyes
codetextyes
coveragetextyes
created_attext
itemtext
job_idtextyes
photo_backedboolean
quantitynumberyes
roundnumber
sent_attextyes
statetextyes
submission_idtext
unittextyes
unit_pricenumberyes

supplement_case_events

What happened on a supplement claim. updated_since reads created_at. Filter by case_id, kind.

FieldTypeMay be empty
idtext
case_idtext
created_attext
kindtext
payloadjson

supplement_cases

Supplement claims. updated_since reads updated_at. Filter by job_id, stage, assigned_to, carrier_scope_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
assigned_totextyes
carrier_scope_idtextyes
claim_kindtext
created_attext
depreciation_deadlinetextyes
dollars_approvednumber
dollars_foundnumber
dollars_sentnumber
job_idtext
next_actiontextyes
next_action_attextyes
roundnumber
sent_attextyes
stagetext
updated_attext

supplement_gaps

Items on a supplement claim. updated_since reads updated_at. Filter by case_id, included, bucket. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
amountnumberyes
buckettext
case_idtext
codetextyes
confidencenumber
created_attext
includedboolean
issuetext
itemtext
notetextyes
prioritytext
questiontextyes
rule_keytext

supplement_intake_queue

Carrier paperwork waiting for a job. updated_since reads created_at. Filter by carrier_scope_id, matched_job_id, status.

FieldTypeMay be empty
idtext
candidate_job_idstext[]
carrier_scope_idtextyes
created_attext
filenametextyes
matched_job_idtextyes
resolved_attextyes
sourcetext
statustext

supplier_item_mappings

Suppliers' item numbers. updated_since reads updated_at. Filter by provider, match_kind.

FieldTypeMay be empty
idtext
created_attext
last_used_attext
match_keytext
match_kindtext
providertext
supplier_descriptiontextyes
supplier_item_numbertext
times_usednumber
uomtextyes
updated_attext

suppliers

Suppliers. updated_since reads updated_at. Filter by is_active.

FieldTypeMay be empty
idtext
account_numbertextyes
addresstextyes
contact_nametextyes
created_attextyes
emailtextyes
is_activebooleanyes
nametext
notestextyes
phonetextyes
updated_attextyes

task_series

Repeating tasks and appointments. updated_since reads updated_at. Filter by assigned_to.

FieldTypeMay be empty
idtext
assigned_totextyes
created_attext
created_bytextyes
ended_ontextyes
generated_throughtext
rulejson
starts_ontext
templatejson
updated_attext

text_from_lines

Which line each kind of text leaves from. updated_since reads updated_at.

FieldTypeMay be empty
defaultsjson
created_attext
updated_attext

user_email_accounts

Connected mailboxes. updated_since reads updated_at. Filter by user_id, status, mailbox_type.

FieldTypeMay be empty
idtext
created_attext
display_nametextyes
email_addresstext
labeltextyes
last_errortextyes
last_synced_attextyes
mailbox_typetext
providertext
serves_all_locationsboolean
statustext
updated_attext
user_idtextyes

user_phone_numbers

Phone numbers and voicemail. updated_since reads updated_at. Filter by status, user_id.

FieldTypeMay be empty
idtext
created_attextyes
forward_to_hail_trackerboolean
phone_numbertext
port_statustextyes
statustext
updated_attextyes
user_idtextyes
voicemail_enabledboolean
voicemail_greeting_texttextyes
voicemail_max_length_secondsnumber

webhook_deliveries

Webhook deliveries to the company's own addresses. updated_since reads created_at. Filter by subscription_id, event, status, resource_id.

FieldTypeMay be empty
idtext
attemptsnumber
created_attext
delivered_attextyes
eventtext
last_errortextyes
next_attempt_attext
resourcetext
resource_idtext
response_statusnumberyes
statustext
subscription_idtext

work_order_issues

Issues crews report on work orders. updated_since reads created_at. Filter by job_id, status, work_order_id.

FieldTypeMay be empty
idtext
created_attext
created_bytextyes
decided_attextyes
decided_bytextyes
file_idstext[]
job_idtext
notetext
quantitynumberyes
statustext
unittextyes
work_order_idtext

work_order_logs

Crews' daily logs on work orders. updated_since reads created_at. Filter by job_id, work_order_id, day.

FieldTypeMay be empty
idtext
created_attext
created_bytextyes
daytext
file_idstext[]
job_idtext
notetext
work_order_idtext

work_order_messages

Messages on a work order's chat with its crew. updated_since reads created_at. Filter by job_id, work_order_id, created_by.

FieldTypeMay be empty
idtext
bodytext
created_attext
created_bytextyes
file_idstext[]
job_idtext
languagetextyes
work_order_idtext

work_order_pay

What work orders' crews are paid. updated_since reads updated_at. Filter by work_order_id. Money: left out for a role that may not see prices.

FieldTypeMay be empty
work_order_idtext
amountnumberyes
cost_idtextyes
linesjson
paid_attextyes
updated_attext
updated_bytextyes

work_order_punch_items

Punch list items on work orders. updated_since reads created_at. Filter by job_id, work_order_id.

FieldTypeMay be empty
idtext
created_attext
created_bytextyes
done_attextyes
done_bytextyes
file_idstext[]
job_idtext
positionnumber
texttext
work_order_idtext

work_order_time_entries

Time clocked on work orders. updated_since reads created_at. Filter by job_id, user_id, work_order_id.

FieldTypeMay be empty
idtext
clock_intext
clock_outtextyes
created_attext
job_idtext
user_idtext
work_order_idtext

work_orders

Work orders. updated_since reads updated_at. Filter by crew_id, job_id, status, trade.

FieldTypeMay be empty
idtext
accepted_attextyes
arrival_timetextyes
auto_createdboolean
calendar_task_idtextyes
check_task_idtextyes
checked_attextyes
checked_bytextyes
colorstextyes
created_attext
crew_idtextyes
daysnumber
depends_ontextyes
finished_attextyes
hoa_statustextyes
homeowner_signed_attextyes
homeowner_signer_nametextyes
homeowner_told_attextyes
job_idtext
material_order_idtextyes
materials_notestextyes
on_way_attextyes
permit_statustextyes
photo_itemsjson
positionnumber
required_shotstext[]
scopejson
scope_notetextyes
site_notestextyes
source_estimate_idtextyes
squaresnumberyes
start_datetextyes
started_attextyes
statustext
titletextyes
tradetext
tradestext[]
updated_attext

workflow_runs

Workflow runs. updated_since reads updated_at. Filter by workflow_id, job_id, status.

FieldTypeMay be empty
idtext
attemptsnumber
created_attext
errortextyes
event_idtextyes
job_idtextyes
resume_aftertextyes
statustext
updated_attext
workflow_idtext

workflows

Workflows. updated_since reads updated_at. Filter by enabled.

FieldTypeMay be empty
idtext
actionsjson
conditionsjson
created_attext
descriptiontext
enabledboolean
nametext
triggerjson
updated_attext

workspace_automations

Automation settings. updated_since reads updated_at. Filter by type, enabled.

FieldTypeMay be empty
idtext
configjson
created_attext
enabledboolean
typetext
updated_attext

workspace_certifications

Certifications. updated_since reads created_at. Filter by certification_program_id.

FieldTypeMay be empty
idtext
certification_program_idtextyes
created_attext
credential_numbertextyes
custom_badge_labeltextyes
custom_logo_urltextyes
custom_organizationtextyes
custom_programtextyes
display_ordernumber

workspace_location_settings

Team map and knock check settings. updated_since reads updated_at.

FieldTypeMay be empty
knock_check_feetnumber
team_mapboolean
updated_attext
updated_bytextyes

workspace_mail_settings

Postcard settings. updated_since reads updated_at.

FieldTypeMay be empty
created_attext
followup_daysnumber
followup_defaultboolean
license_numbertextyes
missed_auto_enabledboolean
neighbors_auto_cardsnumber
neighbors_auto_enabledboolean
phonetextyes
rep_monthly_limit_centsnumber
reps_can_sendboolean
return_addresstextyes
return_citytextyes
return_nametextyes
return_statetextyes
return_ziptextyes
skip_recent_daysnumber
storm_auto_enabledboolean
storm_auto_max_cardsnumber
storm_auto_max_centsnumber
storm_auto_min_hailnumber
storm_auto_sendboolean
updated_attext
updated_bytextyes
websitetextyes

workspace_message_templates

Customer message wording. updated_since reads updated_at. Filter by enabled, template_key.

FieldTypeMay be empty
idtext
bodytextyes
created_attext
enabledboolean
subjecttextyes
template_keytext
updated_attext

workspace_pricing_packages

Saved pricing packages. updated_since reads updated_at. Money: left out for a role that may not see prices.

FieldTypeMay be empty
idtext
created_attext
descriptiontextyes
display_ordernumber
itemsjson
nametext
updated_attext

workspace_role_edits

What each built-in role may do here. updated_since reads updated_at. Filter by preset_key.

FieldTypeMay be empty
preset_keytext
permissionsjson
updated_attext
updated_bytextyes

workspace_roles

Team roles. updated_since reads updated_at.

FieldTypeMay be empty
idtext
can_billboolean
can_delete_jobsboolean
can_exportboolean
can_see_moneyboolean
created_attext
nametext
sees_all_jobsboolean
updated_attext

workspace_showcases

The company showcase page. updated_since reads updated_at.

FieldTypeMay be empty
created_attext
headlinetextyes
introtextyes
publishedboolean
updated_attext

workspace_storm_list_auto

Automatic storm lists. updated_since reads updated_at.

FieldTypeMay be empty
assignee_idstext[]
colortext
created_attext
dedupe_daysnumberyes
enabledboolean
last_built_datetextyes
last_run_attextyes
last_skipped_reasontextyes
min_propertiesnumber
min_size_innumber
property_capnumber
updated_attext

workspace_teams

Teams (who leads whose jobs). updated_since reads created_at.

FieldTypeMay be empty
idtext
created_attext
created_bytextyes
nametext

workspace_territories

Company territories. updated_since reads updated_at. Filter by kind, state_code.

FieldTypeMay be empty
idtext
confirmed_attextyes
county_fipstextyes
county_nametextyes
created_attext
kindtext
labeltext
latitudenumberyes
longitudenumberyes
radius_minumberyes
state_codetextyes
updated_attext

workspaces

The company. updated_since reads updated_at.

FieldTypeMay be empty
idtext
nametext
auto_archive_after_daysnumber
auto_archive_completed_enabledboolean
card_payments_enabledboolean
company_addresstextyes
company_citytextyes
company_emailtextyes
company_licensetextyes
company_phonetextyes
company_statetextyes
company_websitetextyes
company_ziptextyes
created_attextyes
financing_labeltextyes
financing_urltextyes

At their own endpoint

TableWhere
activitiesGET /jobs/{id}/timeline
audit_eventsGET /audit_log
canvassing_pinsGET /pins
carrier_scopesGET /jobs/{id}/carrier_scopes
communication_logGET /messages
contactsGET /contacts
email_draftsGET /email_drafts
estimate_line_itemsGET /estimates/{id}/line_items
estimatesGET /estimates
filesGET /files
invoice_line_itemsGET /invoices/{id}
invoicesGET /invoices
job_costsGET /job_costs
job_measurementsGET /jobs/{id}/measurements
job_notesGET /notes
job_paymentsGET /payments
job_peopleGET /jobs/{id}/people
jobsGET /jobs
pipeline_stagesGET /stages
pipelinesGET /pipelines
product_catalogGET /products
storm_list_propertiesGET /storm_lists/{id}/properties
storm_listsGET /storm_lists
supplement_submissionsGET /supplements
tasksGET /tasks
webhook_subscriptionsGET /webhooks
workspace_membersGET /users

Never handed out, and why

TableWhy
ai_asksHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_briefsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_company_lagsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_company_processHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_deliveriesHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_email_repliesHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_eventsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_exam_casesHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_examplesHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_job_stateHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_logHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_memoryHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_patternsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_phone_callsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_policy_rulesHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_policy_statsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_proactive_stateHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_promise_cursorsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_promise_readsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_promisesHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_routinesHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_run_stepsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_runsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_shortcutsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_suggestionsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_teammatesHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_text_chunksHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_text_repliesHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_tidy_seenHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_trustHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_usageHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_workflow_findingsHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
ai_workspacesHailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages
api_keysthe company's keys: named and dated on Settings → API & MCP; a key never lists keys
api_oauth_codesa one-time code while an app connects
app_link_sms_sendsa log that stops the app's download link being texted twice
appointment_messages_senta log that stops an appointment message going twice; the messages themselves are in GET /messages
appointment_type_lengthsone row per kind of appointment, keyed by the kind: set_appointment_length names it, so there is nothing to find first
billing_mismatchesHailMate's billing of the company: its plan, charges and receipts are on Settings → Plan
calendar_feedsa person's own secret calendar link: whoever holds it reads their schedule
checkout_offer_usesHailMate's billing of the company: its plan, charges and receipts are on Settings → Plan
checkout_payment_failuresHailMate's billing of the company: its plan, charges and receipts are on Settings → Plan
client_field_stampswhich phone last changed a field, kept to merge offline saves
code_answer_reportsbetween the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work
companycam_connectionsa connection to another company's service, holding its sign-in; it is set up on its own settings screen
companycam_photo_failuresa connection's or a background job's own work queue; what it made is in the records it made
custom_field_definitionsthe shop's field setup, a settings screen only an owner or admin opens (every action that changes it is noApiKeys)
customer_agreementsbetween the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work
data_export_destination_secretsthe secret key of the company's own storage: read only by the server that writes the exports, never by a person or a key
deleted_contactsthe Recently deleted bin, emptied after 30 days: every delete, restore and purge is a line kept for good in GET /audit_log (filter action=job.deleted,contact.deleted,record.deleted,media.deleted)
deleted_jobsthe Recently deleted bin, emptied after 30 days: every delete, restore and purge is a line kept for good in GET /audit_log (filter action=job.deleted,contact.deleted,record.deleted,media.deleted)
deleted_mediathe Recently deleted bin, emptied after 30 days: every delete, restore and purge is a line kept for good in GET /audit_log (filter action=job.deleted,contact.deleted,record.deleted,media.deleted)
deleted_recordsthe Recently deleted bin, emptied after 30 days: every delete, restore and purge is a line kept for good in GET /audit_log (filter action=job.deleted,contact.deleted,record.deleted,media.deleted)
document_number_countersthe next invoice, estimate and job number; the numbers themselves are on each record
estimate_totalsfacts the app keeps about a job for reports and answers (its dates, totals, place, building code, roof pictures); read them as the job's own fields: GET /jobs, or the jobs export (POST /v1/actions/run_export_now)
google_calendar_accountsa connection to another company's service, holding its sign-in; it is set up on its own settings screen
google_calendar_event_linksa connection's or a background job's own work queue; what it made is in the records it made
google_calendar_eventsa person's own Google Calendar, copied in to show beside HailMate's appointments (GET /tasks)
google_calendar_routesa person's own Google Calendar, copied in to show beside HailMate's appointments (GET /tasks)
google_calendarsa person's own Google Calendar, copied in to show beside HailMate's appointments (GET /tasks)
help_chatsbetween the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work
hq_broadcast_sendsbetween the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work
hq_crm_demo_notesbetween the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work
hq_crm_peoplebetween the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work
hq_crm_settingsbetween the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work
hq_crm_sourcesbetween the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work
inbox_hidden_threadsone person's own inbox view, kept by the app
job_auto_measure_queuea connection's or a background job's own work queue; what it made is in the records it made
job_card_picturesfacts the app keeps about a job for reports and answers (its dates, totals, place, building code, roof pictures); read them as the job's own fields: GET /jobs, or the jobs export (POST /v1/actions/run_export_now)
job_code_factsfacts the app keeps about a job for reports and answers (its dates, totals, place, building code, roof pictures); read them as the job's own fields: GET /jobs, or the jobs export (POST /v1/actions/run_export_now)
job_followupsa connection's or a background job's own work queue; what it made is in the records it made
job_jurisdictionsfacts the app keeps about a job for reports and answers (its dates, totals, place, building code, roof pictures); read them as the job's own fields: GET /jobs, or the jobs export (POST /v1/actions/run_export_now)
job_locationsfacts the app keeps about a job for reports and answers (its dates, totals, place, building code, roof pictures); read them as the job's own fields: GET /jobs, or the jobs export (POST /v1/actions/run_export_now)
job_number_countersthe next invoice, estimate and job number; the numbers themselves are on each record
job_stage_milestonesfacts the app keeps about a job for reports and answers (its dates, totals, place, building code, roof pictures); read them as the job's own fields: GET /jobs, or the jobs export (POST /v1/actions/run_export_now)
location_shiftswhere a teammate is, minute by minute: seen live on the team map by those allowed, never handed to another app
login_sharing_alertsHailMate's own check for one login shared by several people
measurement_provider_connectionsa connection to another company's service, holding its sign-in; it is set up on its own settings screen
measurement_shadow_runsfacts the app keeps about a job for reports and answers (its dates, totals, place, building code, roof pictures); read them as the job's own fields: GET /jobs, or the jobs export (POST /v1/actions/run_export_now)
member_location_latestwhere a teammate is, minute by minute: seen live on the team map by those allowed, never handed to another app
member_locationswhere a teammate is, minute by minute: seen live on the team map by those allowed, never handed to another app
onboarding_projectsbetween the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work
payment_import_profileshow one processor's file is read, keyed by its column headers: save_payment_import_profile names them, so there is nothing to find first
product_feedbackbetween the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work
profilesa person's own profile: GET /me says who is acting, GET /users lists teammates
property_lookupsa person's owner lookups, counted for the paid lookup; the owner it found is saved on the door and the contact
property_record_areasfacts the app keeps about a job for reports and answers (its dates, totals, place, building code, roof pictures); read them as the job's own fields: GET /jobs, or the jobs export (POST /v1/actions/run_export_now)
push_tokensthe phones a person gets their own alerts on, listed on their own settings screen (the one action that changes it is noApiKeys)
quickbooks_account_choicesQuickBooks' own lists and the choices made for them on Settings → QuickBooks; what was sent is quickbooks_sync_records
quickbooks_connectionsa connection to another company's service, holding its sign-in; it is set up on its own settings screen
quickbooks_desktop_connectionsa connection to another company's service, holding its sign-in; it is set up on its own settings screen
quickbooks_desktop_sessionsa connection to another company's service, holding its sign-in; it is set up on its own settings screen
quickbooks_listsQuickBooks' own lists and the choices made for them on Settings → QuickBooks; what was sent is quickbooks_sync_records
quickbooks_outboxa connection's or a background job's own work queue; what it made is in the records it made
quickbooks_settingsQuickBooks' own lists and the choices made for them on Settings → QuickBooks; what was sent is quickbooks_sync_records
report_job_datesfacts the app keeps about a job for reports and answers (its dates, totals, place, building code, roof pictures); read them as the job's own fields: GET /jobs, or the jobs export (POST /v1/actions/run_export_now)
report_job_factsfacts the app keeps about a job for reports and answers (its dates, totals, place, building code, roof pictures); read them as the job's own fields: GET /jobs, or the jobs export (POST /v1/actions/run_export_now)
report_job_facts_dirtya connection's or a background job's own work queue; what it made is in the records it made
roof_picture_setsfacts the app keeps about a job for reports and answers (its dates, totals, place, building code, roof pictures); read them as the job's own fields: GET /jobs, or the jobs export (POST /v1/actions/run_export_now)
save_failuresthe app's own log of saves that failed, for HailMate's support
saved_payment_methodsa card on file
solar_paid_callsfacts the app keeps about a job for reports and answers (its dates, totals, place, building code, roof pictures); read them as the job's own fields: GET /jobs, or the jobs export (POST /v1/actions/run_export_now)
spotio_connectionsa connection to another company's service, holding its sign-in; it is set up on its own settings screen
spotio_eventsa connection's or a background job's own work queue; what it made is in the records it made
spotio_importsa connection's or a background job's own work queue; what it made is in the records it made
spotio_outboxa connection's or a background job's own work queue; what it made is in the records it made
subscription_eventsHailMate's billing of the company: its plan, charges and receipts are on Settings → Plan
supplement_answer_logthe supplement engine's own working state; the claims and their items are supplement_cases, supplement_gaps and supplement_asks
supplement_eval_labelsthe supplement engine's own working state; the claims and their items are supplement_cases, supplement_gaps and supplement_asks
supplement_rerun_queuea connection's or a background job's own work queue; what it made is in the records it made
supplement_rule_answersthe supplement engine's own working state; the claims and their items are supplement_cases, supplement_gaps and supplement_asks
supplement_scope_linesthe supplement engine's own working state; the claims and their items are supplement_cases, supplement_gaps and supplement_asks
supplement_unasked_paidthe supplement engine's own working state; the claims and their items are supplement_cases, supplement_gaps and supplement_asks
supplement_usagethe supplement engine's own working state; the claims and their items are supplement_cases, supplement_gaps and supplement_asks
supplier_connectionsa connection to another company's service, holding its sign-in; it is set up on its own settings screen
support_requestsbetween the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work
work_order_shotsone row per required shot on a work order, keyed by the work order and the shot: add_work_order_shot names both
workflow_eventsa connection's or a background job's own work queue; what it made is in the records it made
workspace_activation_touchesHailMate's billing of the company: its plan, charges and receipts are on Settings → Plan
workspace_dunningHailMate's billing of the company: its plan, charges and receipts are on Settings → Plan
workspace_group_admin_grantsbookkeeping of what a company admin was given in each location
workspace_invitation_locationsthe locations an invitation covers, read with the invitation on Settings → Team
workspace_list_optionsone row per option, keyed by its list and its key: save_list_options names both, and the built-ins are the app's own
workspace_referral_codesHailMate's billing of the company: its plan, charges and receipts are on Settings → Plan
workspace_seat_overage_chargesHailMate's billing of the company: its plan, charges and receipts are on Settings → Plan
workspace_supplement_claim_chargesHailMate's billing of the company: its plan, charges and receipts are on Settings → Plan
workspace_twilio_configthe texting carrier registration, which holds the carrier's own sign-in
workspace_usage_countersHailMate's billing of the company: its plan, charges and receipts are on Settings → Plan