On this page
Getting all of it, and keeping it current
- Everything at once:
POST /v1/actions/run_export_nowmakes 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_sinceto 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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
active | boolean | |
cadence | text | |
condition | text | |
created_at | text | |
last_checked_on | text | yes |
last_fired_at | text | yes |
last_value | number | yes |
spec | json | |
threshold | number | |
updated_at | text |
analytics_views
Charts in Reports (yours and the team's). updated_since reads updated_at. Filter by owner_id, made_by.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
made_by | text | |
owner_id | text | yes |
position | number | |
size | text | |
spec | json | |
title | text | |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | json | |
api_key_id | text | yes |
created_at | text | |
duration_ms | number | yes |
error_code | text | yes |
error_message | text | yes |
method | text | |
request_id | text | |
route | text | |
status | number |
automation_runs
Automation runs. updated_since reads created_at. Filter by automation_type, status.
| Field | Type | May be empty |
|---|---|---|
id | text | |
automation_type | text | |
created_at | text | |
detail | json | |
event_key | text | |
status | text |
calendar_members
Who is on each calendar. updated_since reads created_at. Filter by calendar_id, user_id.
| Field | Type | May be empty |
|---|---|---|
calendar_id | text | |
user_id | text | |
sees_all | boolean | |
created_at | text |
calendars
Calendars (Sales, Production, ...). updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
id | text | |
auto_join_roles | text[] | |
color | text | |
created_at | text | |
created_by | text | yes |
default_for_types | text[] | |
members_see_all | boolean | |
name | text | |
position | number | |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
contact_id | text | yes |
contact_name | text | yes |
contact_phone | text | yes |
created_at | text | |
direction | text | |
from_user_id | text | |
phone_number_id | text | yes |
seconds_before | number | yes |
status | text | |
to_user_id | text |
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.
| Field | Type | May be empty |
|---|---|---|
knock_id | text | |
accuracy_m | number | yes |
created_at | text | |
distance_m | number | yes |
is_mocked | boolean | |
knocked_at | text | |
missing | text | yes |
pin_id | text | |
position_at | text | yes |
reviewed_at | text | yes |
reviewed_by | text | yes |
source | text | |
user_id | text | yes |
canvassing_knocks
Door knocks: every knock on every door. updated_since reads knocked_at. Filter by pin_id, user_id, knock_result.
| Field | Type | May be empty |
|---|---|---|
id | text | |
knock_result | text | |
knocked_at | text | |
pin_id | text | |
user_id | text | yes |
canvassing_pin_history
A door's result over time. updated_since reads changed_at. Filter by pin_id, source, new_pin_type.
| Field | Type | May be empty |
|---|---|---|
id | text | |
changed_at | text | |
new_pin_type | text | |
old_pin_type | text | yes |
pin_id | text | |
source | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
amount | number | |
commission_ids | text[] | |
counts_as_draw | boolean | |
created_at | text | |
kind | text | |
note | text | yes |
occurred_on | text | |
period_end | text | yes |
period_start | text | yes |
user_id | text |
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.
| Field | Type | May be empty |
|---|---|---|
user_id | text | |
base_pay_is_draw | boolean | |
base_pay_starts_on | text | yes |
base_pay_weekly | number | yes |
created_at | text | |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
flat_amount | number | yes |
job_type | text | yes |
lead_source | text | yes |
rate_percent | number | |
rule_id | text | yes |
setter_rule_id | text | yes |
when_split | boolean |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
basis | text | |
company_cut_percent | number | |
created_at | text | |
flat_amount | number | |
is_active | boolean | |
rate_percent | number | |
updated_at | text | |
user_id | text | yes |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
basis | text | |
company_cut_percent | number | |
created_at | text | |
flat_amount | number | |
is_active | boolean | |
rate_percent | number | |
updated_at | text | |
user_id | text | yes |
commission_settings
When commissions come due. updated_since reads updated_at. Money: left out for a role that may not see prices.
| Field | Type | May be empty |
|---|---|---|
created_at | text | |
owed_when | text | |
setup | text | yes |
updated_at | text |
companycam_project_links
Jobs linked to CompanyCam projects. updated_since reads updated_at. Filter by job_id, companycam_project_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
companycam_project_id | text | |
created_at | text | |
created_by | text | yes |
job_id | text | |
last_pulled_at | text | yes |
link_source | text | |
project_name | text | yes |
project_url | text | yes |
updated_at | text |
crew_days_off
Crews' days off. updated_since reads updated_at. Filter by crew_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
crew_id | text | |
starts_on | text | |
ends_on | text | |
reason | text | yes |
created_by | text | yes |
crew_documents
Crews' papers. updated_since reads created_at. Filter by crew_id, kind.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
crew_id | text | yes |
expires_on | text | yes |
file_name | text | yes |
kind | text | |
label | text | yes |
storage_path | text | |
uploaded_by | text | yes |
crew_invites
Crew and sub invitations. updated_since reads updated_at. Filter by crew_id, status, kind, sub_company_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
crew_id | text | yes |
invited_by | text | yes |
is_lead | boolean | |
joined_at | text | yes |
kind | text | |
language | text | |
last_sent_at | text | yes |
name | text | |
phone | text | |
send_count | number | |
status | text | |
sub_company_id | text | yes |
updated_at | text | |
user_id | text | yes |
work_order_id | text | yes |
crew_join_requests
Helpers asking to join a crew. updated_since reads created_at. Filter by crew_id, status, job_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
crew_id | text | yes |
decided_at | text | yes |
decided_by | text | yes |
invite_id | text | yes |
job_id | text | yes |
name | text | |
phone | text | |
status | text | |
work_order_id | text | yes |
crew_members
Who is on each crew. updated_since reads created_at. Filter by crew_id, user_id, is_lead.
| Field | Type | May be empty |
|---|---|---|
crew_id | text | |
user_id | text | |
is_lead | boolean | |
created_at | text |
crew_paper_requests
Papers asked of crews (insurance, W-9…). updated_since reads created_at. Filter by crew_id, sub_company_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
crew_id | text | yes |
fulfilled_at | text | yes |
kinds | text[] | |
last_sent_at | text | yes |
note | text | yes |
requested_by | text | yes |
sent_to | text | yes |
sub_company_id | text | yes |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
crew_id | text | yes |
label | text | |
position | number | |
rate | number | |
unit | text | |
updated_at | text |
crews
Crews. updated_since reads updated_at. Filter by active, contact_id, kind, sub_company_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
active | boolean | |
color | text | |
contact_id | text | yes |
created_at | text | |
email | text | yes |
kind | text | |
name | text | |
notes | text | yes |
phone | text | yes |
squares_per_day | number | yes |
sub_company_id | text | yes |
trades | text[] | |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
created_by | text | yes |
delta | number | |
note | text | yes |
reason | text | |
storm_list_id | text | yes |
data_export_destinations
Your own storage scheduled exports are written to (never its secret). updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
id | text | |
access_key_id | text | |
bucket | text | |
created_at | text | |
created_by | text | yes |
endpoint | text | |
last_check_ok | boolean | yes |
last_checked_at | text | yes |
last_delivered_at | text | yes |
last_error | text | yes |
name | text | |
path_style | boolean | |
prefix | text | |
region | text | |
updated_at | text | |
updated_by | text | yes |
data_export_runs
Export files made (scheduled, now, by the API). updated_since reads created_at. Filter by kind, schedule_id, status, requested_by.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
deliver_to_schedule | boolean | |
delivered | json | |
delivered_to | json | yes |
error | text | yes |
expires_at | text | |
file_bytes | number | yes |
file_name | text | yes |
finished_at | text | yes |
format | text | |
items | json | |
kind | text | |
name | text | |
parts | json | |
requested_by | text | yes |
row_count | number | yes |
schedule_id | text | yes |
started_at | text | yes |
status | text |
data_export_schedules
Scheduled exports. updated_since reads updated_at. Filter by cadence, created_by, paused, destination_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
cadence | text | |
created_at | text | |
created_by | text | |
deliver_emails | text[] | |
deliver_members | text[] | |
destination_id | text | yes |
failure_count | number | |
format | text | |
hour | number | |
items | json | |
last_run_at | text | yes |
last_run_id | text | yes |
last_status | text | yes |
month_day | number | yes |
name | text | |
next_run_at | text | |
paused | boolean | |
paused_reason | text | yes |
time_zone | text | |
updated_at | text | |
weekday | number | yes |
data_feeds
Live links (owners and admins). updated_since reads created_at. Filter by created_by.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
created_by | text | |
item | json | |
last_used_at | text | yes |
name | text | |
revoked_at | text | yes |
use_count | number |
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.
| Field | Type | May be empty |
|---|---|---|
action | text | |
created_at | text | |
entity_type | text | |
previous | json | yes |
record_id | text | |
run_id | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
counts | json | |
created_at | text | |
created_by | text | yes |
file_name | text | yes |
finished_at | text | yes |
row_count | number | |
source | text | |
status | text | |
undone_at | text | yes |
undone_by | text | yes |
document_templates
Contract templates. updated_since reads updated_at. Filter by doc_type.
| Field | Type | May be empty |
|---|---|---|
id | text | |
blocks | json | |
created_at | text | yes |
description | text | yes |
doc_type | text | |
name | text | |
pdf_form | json | yes |
updated_at | text | yes |
email_location_senders
The mailbox each location's automated email is sent from. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
mailbox_id | text | yes |
set_by | text | yes |
updated_at | text |
email_mailbox_locations
Which locations share a company mailbox. updated_since reads created_at. Filter by mailbox_id.
| Field | Type | May be empty |
|---|---|---|
mailbox_id | text | |
everyone | boolean | |
created_at | text |
email_mailbox_members
Who shares each company mailbox. updated_since reads created_at. Filter by mailbox_id, user_id.
| Field | Type | May be empty |
|---|---|---|
mailbox_id | text | |
user_id | text | |
created_at | text |
email_signatures
Email signatures. updated_since reads updated_at. Filter by is_default, user_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
body | text | |
created_at | text | |
design | json | yes |
format | text | |
html | text | yes |
is_default | boolean | |
name | text | |
updated_at | text | |
user_id | text |
email_templates
Email templates. updated_since reads updated_at. Filter by is_shared.
| Field | Type | May be empty |
|---|---|---|
id | text | |
body | text | |
created_at | text | |
is_shared | boolean | |
name | text | |
subject | text | |
updated_at | text |
email_thread_assignments
Who owns each email thread. updated_since reads assigned_at. Filter by thread_id, user_id.
| Field | Type | May be empty |
|---|---|---|
thread_id | text | |
user_id | text | |
assigned_at | text | |
assigned_by | text | yes |
estimate_auto_drafts
Estimates a measurement report drafted. Filter by job_id, estimate_id, state.
| Field | Type | May be empty |
|---|---|---|
id | text | |
estimate_id | text | yes |
job_id | text | |
measurement_id | text | yes |
start_ref | text | |
state | text | |
drafted_at | text | |
refitted_at | text | yes |
estimate_photos
Photos on an estimate. updated_since reads created_at. Filter by estimate_id, file_id, section_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
caption | text | yes |
created_at | text | yes |
display_order | number | |
estimate_id | text | |
file_id | text | yes |
file_name | text | yes |
include_in_pdf | boolean | |
media_kind | text | |
mime_type | text | yes |
photo_url | text | |
section_id | text | yes |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
description | text | yes |
display_order | number | |
estimate_id | text | |
is_enabled | boolean | |
name | text | |
tier_key | text | |
updated_at | text |
estimate_sections
Sections of an estimate. updated_since reads updated_at. Filter by estimate_id, section_type.
| Field | Type | May be empty |
|---|---|---|
id | text | |
content | json | yes |
created_at | text | yes |
display_order | number | |
estimate_id | text | |
is_visible | boolean | yes |
section_type | text | |
show_title | boolean | |
tier | text | yes |
title | text | yes |
updated_at | text | yes |
estimate_settings
Estimate and invoice settings. updated_since reads updated_at. Money: left out for a role that may not see prices.
| Field | Type | May be empty |
|---|---|---|
id | text | |
boldsign_sender_email | text | yes |
boldsign_sender_status | text | yes |
company_insurance_info | text | yes |
company_license_number | text | yes |
created_at | text | yes |
default_cost_per_square | number | yes |
default_labor_cost_per_square | number | yes |
default_material_cost_per_square | number | yes |
default_price_per_square | number | yes |
default_tax_rate | number | yes |
default_terms_and_conditions | text | yes |
default_valid_days | number | yes |
deposit_percent | number | yes |
invoice_default_due_days | number | yes |
invoice_default_notes | text | yes |
invoice_default_tax_rate | number | yes |
invoice_default_terms | text | yes |
min_margin_percent | number | yes |
pdf_primary_color | text | yes |
updated_at | text | yes |
estimate_signers
Who signs an estimate. updated_since reads updated_at. Filter by estimate_id, status.
| Field | Type | May be empty |
|---|---|---|
id | text | |
boldsign_signer_status | text | yes |
created_at | text | yes |
estimate_id | text | |
signed_at | text | yes |
signer_email | text | |
signer_name | text | |
signer_order | number | yes |
signer_role | text | yes |
status | text | yes |
updated_at | text | yes |
estimate_templates
Estimate templates. updated_since reads updated_at. Money: left out for a role that may not see prices.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
created_by | text | yes |
description | text | yes |
name | text | |
template_data | json | |
updated_at | text |
estimate_view_events
When a homeowner opened an estimate. updated_since reads created_at. Filter by estimate_id, event_type.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | yes |
estimate_id | text | |
event_data | json | yes |
event_type | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
description | text | yes |
display_order | number | |
estimate_id | text | |
is_recommended | boolean | |
name | text | |
price | number | yes |
section_id | text | |
term_label | text | yes |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
entity_type | text | |
external_id | text | |
internal_id | text | |
source | text | |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
file_id | text | |
amount | number | yes |
check_number | text | yes |
completed_at | text | yes |
cost_category | text | yes |
created_at | text | |
dismissed_at | text | yes |
document_date | text | yes |
document_kind | text | yes |
payer_type | text | yes |
status | text |
homeowner_lead_offers
Homeowner leads offered to the company. updated_since reads created_at. Filter by request_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
claimed_at | text | yes |
created_at | text | |
distance_mi | number | yes |
notified_at | text | yes |
notify_channel | text | yes |
releases_at | text | |
request_id | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
amount | number | |
created_at | text | |
customer_email | text | yes |
customer_name | text | yes |
customer_phone | text | yes |
date_received | text | |
deposited | boolean | |
description | text | yes |
invoice_number | text | yes |
job_number | text | yes |
kind | text | |
notes | text | yes |
original_reference | text | yes |
payment_id | text | yes |
payment_method | text | yes |
processor | text | |
processor_fee | number | yes |
processor_reference | text | |
resolved_at | text | yes |
state | text | |
waiting_because | text | yes |
inspection_templates
Inspection checklists. updated_since reads updated_at. Filter by archived.
| Field | Type | May be empty |
|---|---|---|
id | text | |
archived | boolean | |
based_on | text | yes |
created_at | text | |
description | text | yes |
items | json | |
name | text | |
rules | json | yes |
updated_at | text |
inspections
Inspections. updated_since reads updated_at. Filter by job_id, status, template_key.
| Field | Type | May be empty |
|---|---|---|
id | text | |
answers | json | |
damage | text | yes |
finished_at | text | yes |
items | json | |
job_id | text | |
slope_count | number | |
started_at | text | |
status | text | |
template_key | text | |
template_name | text | |
updated_at | text |
job_access_requests
Teammates asking to see a job. updated_since reads created_at. Filter by job_id, user_id, resolution.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
job_id | text | |
resolution | text | yes |
resolved_at | text | yes |
resolved_by | text | yes |
user_id | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
item_id | text | |
file_id | text | |
job_id | text | |
position | number | |
created_by | text | yes |
created_at | text |
job_checklist_items
Items on a job's checklists. updated_since reads updated_at. Filter by checklist_id, job_id, status.
| Field | Type | May be empty |
|---|---|---|
id | text | |
checklist_id | text | |
created_at | text | |
heading | text | yes |
job_id | text | |
label | text | |
note | text | yes |
photo_file_id | text | yes |
position | number | |
quantity | number | yes |
status | text | |
status_at | text | yes |
status_by | text | yes |
unit | text | yes |
updated_at | text |
job_checklist_templates
Company job checklists. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
id | text | |
auto_add_stage_ids | text[] | |
created_at | text | |
items | json | |
name | text | |
position | number | |
starter_key | text | yes |
updated_at | text |
job_checklists
Checklists on jobs. updated_since reads updated_at. Filter by job_id, template_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
added_at_stage_id | text | yes |
added_by | text | yes |
created_at | text | |
job_id | text | |
name | text | |
removed_at | text | yes |
template_id | text | yes |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
amount | number | |
basis | text | |
basis_amount | number | |
company_cut_percent | number | |
created_at | text | |
flat_amount | number | |
job_id | text | |
note | text | yes |
paid_at | text | yes |
rate_percent | number | |
role | text | |
status | text | |
updated_at | text | |
user_id | text |
job_document_signers
Who signs a contract. updated_since reads updated_at. Filter by document_id, status.
| Field | Type | May be empty |
|---|---|---|
id | text | |
boldsign_signer_status | text | yes |
created_at | text | yes |
document_id | text | |
signed_at | text | yes |
signer_email | text | |
signer_name | text | |
signer_order | number | |
signer_role | text | |
status | text | |
updated_at | text | yes |
job_documents
Contracts and job documents. updated_since reads updated_at. Filter by job_id, status, template_id, doc_type.
| Field | Type | May be empty |
|---|---|---|
id | text | |
blocks | json | |
created_at | text | yes |
doc_type | text | |
document_number | text | |
job_id | text | |
pdf_generated_at | text | yes |
pdf_url | text | yes |
sent_at | text | yes |
signature_field_defs | json | yes |
signature_method | text | yes |
signed_at | text | yes |
signed_pdf_url | text | yes |
signers | json | yes |
status | text | |
template_id | text | yes |
title | text | |
updated_at | text | yes |
job_role_settings
Which roles a company uses on its jobs. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
canvasser_on | boolean | |
project_manager_on | boolean | |
created_at | text | |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
job_id | text | |
created_at | text | |
source | text | |
updated_at | text | |
user_id | text |
job_site_links
Job-site sign links. updated_since reads updated_at. Filter by job_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
guest_uploads | boolean | |
job_id | text | |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
entered_at | text | |
entered_known | boolean | |
job_id | text | |
left_at | text | yes |
left_known | boolean | |
moved_by | text | yes |
next_stage | text | yes |
pipeline_id | text | yes |
stage | text |
lead_link_events
Leads that came in through a lead link. updated_since reads received_at. Filter by lead_link_id, outcome, job_id, contact_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
contact_id | text | yes |
detail | text | yes |
job_id | text | yes |
lead_link_id | text | |
outcome | text | |
payload | json | yes |
received_at | text |
lead_links
Lead links. updated_since reads updated_at. Filter by enabled, kind, pipeline_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
assigned_to | text | yes |
created_at | text | |
enabled | boolean | |
kind | text | |
last_received_at | text | yes |
lead_source | text | yes |
name | text | |
pipeline_id | text | yes |
price_page | boolean | |
received_count | number | |
stage_key | text | yes |
updated_at | text |
leaderboard_contests
Leaderboard contests (a number, days and a prize). updated_since reads updated_at. Filter by metric, scope.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
created_by | text | yes |
ends_on | text | |
metric | text | |
prize | text | yes |
scope | text | |
starts_on | text | |
title | text | |
updated_at | text |
leaderboard_goals
Leaderboard goals (a target per number). updated_since reads updated_at. Filter by per.
| Field | Type | May be empty |
|---|---|---|
metric | text | |
per | text | |
target | number | |
updated_at | text | |
updated_by | text | yes |
mail_do_not_mail
Homes never to mail. updated_since reads created_at. Filter by reason.
| Field | Type | May be empty |
|---|---|---|
id | text | |
address | text | |
address_key | text | |
created_at | text | |
created_by | text | yes |
reason | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
audience | json | |
automation | text | yes |
canceled_at | text | yes |
card_count | number | |
cents_per_card | number | |
code | text | |
content | json | |
created_at | text | |
created_by | text | yes |
delivered_at | text | yes |
error | text | yes |
followup_days | number | yes |
followup_of | text | yes |
homes_found | number | |
job_id | text | yes |
mail_date | text | yes |
mailed_at | text | yes |
paid_at | text | yes |
paid_by | text | yes |
product_key | text | |
provider | text | yes |
refunded_cents | number | |
sent_at | text | yes |
source | text | |
status | text | |
storm_date | text | yes |
summary | json | |
template_key | text | |
title | text | |
total_cents | number | |
updated_at | text |
mail_recipients
Homes a mailing went to. updated_since reads created_at. Filter by order_id, status, job_id, lead_job_id, pin_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
address | text | |
assessed_value | number | yes |
city | text | yes |
code | text | |
created_at | text | |
delivered_at | text | yes |
distance_mi | number | yes |
hail_size_in | number | yes |
job_id | text | yes |
latitude | number | yes |
lead_at | text | yes |
lead_job_id | text | yes |
longitude | number | yes |
order_id | text | |
owner_occupied | boolean | yes |
pin_id | text | yes |
rank | number | |
scan_count | number | |
scanned_at | text | yes |
skip_reason | text | yes |
state | text | yes |
status | text | |
to_address | text | yes |
to_address2 | text | yes |
to_city | text | yes |
to_name | text | yes |
to_state | text | yes |
to_zip | text | yes |
year_built | number | yes |
zip | text | yes |
mail_scans
A mailing's QR codes scanned. updated_since reads created_at. Filter by order_id, recipient_id, kind, job_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
job_id | text | yes |
kind | text | |
order_id | text | |
recipient_id | text | yes |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | yes |
description | text | yes |
display_order | number | |
line_total | number | |
material_order_id | text | |
name | text | |
product_id | text | yes |
quantity | number | |
supplier_description | text | yes |
supplier_item_number | text | yes |
unit_cost | number | |
uom | text | yes |
updated_at | text | yes |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
basis | text | |
created_at | text | |
description | text | yes |
display_order | number | |
min_quantity | number | |
name | text | |
per_unit | number | |
product_id | text | yes |
round_up | boolean | |
supplier_item_number | text | yes |
template_id | text | |
unit_cost | number | |
uom | text | yes |
updated_at | text | |
waste_pct | number |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
name | text | |
notes | text | yes |
supplier_id | text | yes |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
additional_charges | json | |
created_at | text | yes |
delivery_address | text | yes |
delivery_date | text | yes |
delivery_notes | text | yes |
estimate_id | text | yes |
job_id | text | yes |
notes | text | yes |
order_number | text | |
sent_at | text | yes |
status | text | |
subtotal | number | |
supplier_id | text | yes |
tax_amount | number | |
tax_rate | number | |
total_amount | number | |
updated_at | text | yes |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
address | text | yes |
city | text | yes |
completed_at | text | yes |
cost_amount | number | yes |
created_at | text | |
error_message | text | yes |
external_order_id | text | yes |
job_cost_id | text | yes |
job_id | text | |
measurement_id | text | yes |
ordered_at | text | |
product | json | |
provider | text | |
quoted_max | number | yes |
quoted_min | number | yes |
report_file_id | text | yes |
requested_by | text | yes |
state | text | yes |
status | text | |
updated_at | text | |
zip | text | yes |
member_activity
When each teammate was last active. updated_since reads last_active_at. Filter by user_id.
| Field | Type | May be empty |
|---|---|---|
user_id | text | |
last_active_at | text |
money_targets
Monthly money goals. updated_since reads updated_at. Money: left out for a role that may not see prices.
| Field | Type | May be empty |
|---|---|---|
created_at | text | |
monthly_collected_goal | number | yes |
monthly_overhead | number | yes |
monthly_sold_goal | number | yes |
updated_at | text | |
updated_by | text | yes |
note_mentions
Teammates mentioned in notes. updated_since reads created_at. Filter by job_id, mentioned_user_id, note_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | yes |
job_id | text | |
mentioned_user_id | text | |
note_id | text |
notifications
Alerts. updated_since reads created_at. Filter by job_id, read, task_id, type, user_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | yes |
job_id | text | yes |
message | text | yes |
note_id | text | yes |
read | boolean | yes |
read_at | text | yes |
snoozed_until | text | yes |
task_id | text | yes |
title | text | |
type | text | |
user_id | text |
partner_portals
Partner portals. updated_since reads updated_at. Filter by enabled. Money: left out for a role that may not see prices.
| Field | Type | May be empty |
|---|---|---|
id | text | |
company_name | text | |
contact_email | text | yes |
created_at | text | |
data_rate_cents | number | yes |
enabled | boolean | |
last_seen_at | text | yes |
max_properties_per_build | number | yes |
parcels_enabled | boolean | |
slug | text | |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
created_by | text | yes |
file_name | text | yes |
line_count | number | |
processor | text | |
recorded_count | number | |
refund_count | number | |
skipped_count | number | |
total_amount | number | |
undone_at | text | yes |
undone_by | text | yes |
phone_line_members
Who answers each phone line. updated_since reads created_at. Filter by phone_number_id, user_id.
| Field | Type | May be empty |
|---|---|---|
phone_number_id | text | |
user_id | text | |
created_at | text |
phone_number_requests
Teammates asking for a phone number. updated_since reads created_at. Filter by status, user_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
note | text | yes |
phone_number_id | text | yes |
resolved_at | text | yes |
resolved_by | text | yes |
status | text | |
user_id | text |
photo_comments
Comments on photos. updated_since reads created_at. Filter by file_id, pin_photo_id, user_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
body | text | |
created_at | text | |
file_id | text | yes |
mentioned_user_ids | text[] | |
pin_photo_id | text | yes |
user_id | text |
photo_galleries
Shared photo galleries. updated_since reads created_at. Filter by job_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
expires_at | text | yes |
job_id | text | |
last_viewed_at | text | yes |
revoked_at | text | yes |
title | text | |
view_count | number |
photo_gallery_items
Photos in a shared gallery. Filter by gallery_id, file_id.
| Field | Type | May be empty |
|---|---|---|
gallery_id | text | |
file_id | text | |
position | number |
photo_report_templates
Photo report templates. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
id | text | |
body | json | |
created_at | text | |
name | text | |
updated_at | text |
photo_suggestions
Suggested photo captions. updated_since reads created_at. Filter by file_id, status.
| Field | Type | May be empty |
|---|---|---|
file_id | text | |
accepted_at | text | yes |
caption | text | yes |
created_at | text | |
damage | text | yes |
dismissed_at | text | yes |
roof_phase | text | yes |
shot_key | text | yes |
status | text |
pin_photos
Photos on a door knock. updated_since reads created_at. Filter by pin_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | yes |
description | text | yes |
file_path | text | |
filename | text | yes |
latitude | number | yes |
longitude | number | yes |
mime_type | text | yes |
pin_id | text | |
tags | text[] | |
taken_at | text | yes |
thumbnail_path | text | yes |
pipeline_stage_people
Who is put on a job at each stage. updated_since reads created_at. Filter by stage_id, user_id.
| Field | Type | May be empty |
|---|---|---|
stage_id | text | |
user_id | text | |
created_at | text | |
created_by | text | yes |
proposal_templates
Proposal templates. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
id | text | |
cover_intro_text | text | yes |
cover_title | text | yes |
created_at | text | yes |
created_by | text | yes |
description | text | yes |
footer_text | text | yes |
is_default | boolean | yes |
name | text | |
terms_and_conditions | text | yes |
updated_at | text | yes |
valid_days | number | yes |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
body | text | |
channel | text | |
contact_id | text | yes |
created_at | text | |
job_id | text | yes |
last_error | text | yes |
made_at | text | |
send_at | text | yes |
sent_at | text | yes |
status | text | |
subject | text | yes |
to_emails | text[] | |
to_phone | text | yes |
updated_at | text | |
user_id | text |
quickbooks_sync_log
What went to and came from QuickBooks. updated_since reads at. Filter by entity_type, entity_id, direction, action, target.
| Field | Type | May be empty |
|---|---|---|
id | text | |
action | text | |
at | text | |
direction | text | |
entity_id | text | yes |
entity_type | text | |
label | text | yes |
message | text | yes |
quickbooks_id | text | yes |
target | text |
quickbooks_sync_records
Records in QuickBooks, with their QuickBooks ids. updated_since reads updated_at. Filter by entity_type, entity_id, sync_status, target.
| Field | Type | May be empty |
|---|---|---|
id | text | |
attached_pdf | text | yes |
created_at | text | |
entity_id | text | |
entity_type | text | |
last_error | text | yes |
origin | text | |
quickbooks_id | text | yes |
removed_in_books | text | yes |
sync_status | text | |
synced_at | text | yes |
target | text | |
updated_at | text |
rep_territories
Reps' territories. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
id | text | |
archived_at | text | yes |
assignee_ids | text[] | |
color | text | |
created_at | text | |
geojson | json | |
name | text | |
updated_at | text |
roof_facts
Roof facts on a job. updated_since reads updated_at. Filter by job_id.
| Field | Type | May be empty |
|---|---|---|
job_id | text | |
created_at | text | |
facts | json | |
updated_at | text | |
vision_photo_count | number | yes |
vision_ran_at | text | yes |
vision_requested_at | text | yes |
roof_readings
Satellite roof readings. updated_since reads measured_at.
| Field | Type | May be empty |
|---|---|---|
id | text | |
address | text | yes |
building_name | text | yes |
created_by | text | yes |
facet_count | number | yes |
imagery_date | text | yes |
imagery_quality | text | yes |
latitude | number | |
longitude | number | |
measured_at | text | |
pitch_degrees | number | yes |
predominant_pitch | text | yes |
total_area_sqft | number | |
total_squares | number | |
tree_cover_share | number | yes |
saved_reports
Saved reports (yours and the team's). updated_since reads updated_at. Filter by owner_id, folder, pinned, template_key.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
description | text | yes |
folder | text | yes |
owner_id | text | yes |
pinned | boolean | |
spec | json | |
template_key | text | yes |
title | text | |
updated_at | text | |
view | json |
scheduled_automation_messages
Automation messages waiting to send. updated_since reads updated_at. Filter by automation_type, contact_id, job_id, rule_id, status.
| Field | Type | May be empty |
|---|---|---|
id | text | |
automation_type | text | |
contact_id | text | yes |
created_at | text | |
job_id | text | |
resolved_at | text | yes |
rule_id | text | |
send_after | text | |
status | text | |
trigger_stage_key | text | |
updated_at | text |
scheduled_emails
Emails scheduled to send later. updated_since reads updated_at. Filter by contact_id, job_id, status, user_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
contact_id | text | yes |
created_at | text | |
job_id | text | yes |
send_at | text | |
sent_at | text | yes |
status | text | |
subject | text | |
to_emails | text[] | |
updated_at | text | |
user_id | text |
showcase_photos
Photos on the company showcase. Filter by file_id.
| Field | Type | May be empty |
|---|---|---|
file_id | text | |
added_at | text | |
height | number | yes |
width | number | yes |
sister_contact_links
Contacts shared with a sister company. updated_since reads created_at. Filter by record_id, link_group, origin.
| Field | Type | May be empty |
|---|---|---|
record_id | text | |
created_at | text | |
created_by | text | yes |
how | text | |
link_group | text | |
origin | text | |
sent_from_workspace_id | text | yes |
sister_job_links
Jobs shared with a sister company. updated_since reads created_at. Filter by record_id, link_group, origin.
| Field | Type | May be empty |
|---|---|---|
record_id | text | |
created_at | text | |
created_by | text | yes |
how | text | |
link_group | text | |
origin | text | |
sent_from_workspace_id | text | yes |
sms_broadcast_recipients
Who a text blast went to. updated_since reads created_at. Filter by broadcast_id, contact_id, job_id, status.
| Field | Type | May be empty |
|---|---|---|
id | text | |
broadcast_id | text | |
contact_id | text | yes |
created_at | text | |
delivered_at | text | yes |
error | text | yes |
first_name | text | yes |
job_id | text | yes |
last_name | text | yes |
phone | text | |
sent_at | text | yes |
skip_reason | text | yes |
status | text |
sms_broadcasts
Text blasts. updated_since reads updated_at. Filter by status.
| Field | Type | May be empty |
|---|---|---|
id | text | |
body | text | |
completed_at | text | yes |
created_at | text | |
name | text | yes |
scheduled_for | text | yes |
started_at | text | yes |
status | text | |
total_recipients | number | |
updated_at | text |
sms_conversation_assignments
Who owns each text conversation. updated_since reads assigned_at. Filter by conversation_id, user_id.
| Field | Type | May be empty |
|---|---|---|
conversation_id | text | |
user_id | text | |
assigned_at | text | |
assigned_by | text | yes |
sms_conversations
Text conversations. updated_since reads updated_at. Filter by contact_id, status, user_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
contact_id | text | yes |
contact_phone | text | |
created_at | text | yes |
last_direction | text | yes |
last_message_at | text | yes |
last_message_preview | text | yes |
status | text | yes |
unread_count | number | yes |
updated_at | text | yes |
user_id | text | yes |
spotio_appointments
Appointments from Spotio. updated_since reads updated_at. Filter by lead_spotio_id, task_id.
| Field | Type | May be empty |
|---|---|---|
spotio_id | text | |
completed | boolean | |
created_at | text | |
deleted_at | text | yes |
duration_minutes | number | yes |
last_event_at | text | yes |
lead_spotio_id | text | yes |
starts_at | text | yes |
task_id | text | yes |
updated_at | text |
spotio_leads
Leads from Spotio. updated_since reads updated_at. Filter by spotio_id, job_id, contact_id, credited_user_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
address | text | yes |
city | text | yes |
contact_id | text | yes |
created_at | text | |
credited_user_id | text | yes |
deleted_at | text | yes |
job_id | text | yes |
last_visit_at | text | yes |
last_visit_result | text | yes |
latitude | number | yes |
longitude | number | yes |
name | text | yes |
owner_spotio_id | text | yes |
pin_id | text | yes |
pushed_at | text | yes |
spotio_id | text | |
spotio_updated_at | text | yes |
stage_id | text | yes |
spotio_reps
Reps in Spotio, and who each is here. updated_since reads updated_at. Filter by user_id, suspended.
| Field | Type | May be empty |
|---|---|---|
spotio_user_id | text | |
appointments | number | |
doors | number | |
email | text | yes |
first_seen_at | text | |
last_seen_at | text | |
matched_by | text | yes |
name | text | yes |
phone | text | yes |
spotio_role | text | yes |
suspended | boolean | |
updated_at | text | |
user_id | text | yes |
storm_digest_settings
Morning storm digest settings. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
created_at | text | |
enabled | boolean | |
immediate_alert_size_in | number | yes |
min_cell_count | number | |
min_size_in | number | |
updated_at | text | |
whole_us | boolean |
storm_list_segments
Parts of a storm list. updated_since reads updated_at. Filter by storm_list_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
filters | json | |
name | text | |
piece_count | number | yes |
storm_list_id | text | |
updated_at | text |
sub_companies
Subcontractor companies. updated_since reads updated_at. Filter by active, owner_user_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
active | boolean | |
created_at | text | |
language | text | |
name | text | |
notes | text | yes |
owner_name | text | yes |
owner_phone | text | yes |
owner_user_id | text | yes |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
amount | number | yes |
bucket | text | yes |
carrier_name | text | yes |
case_id | text | yes |
code | text | yes |
coverage | text | yes |
created_at | text | |
item | text | |
job_id | text | yes |
photo_backed | boolean | |
quantity | number | yes |
round | number | |
sent_at | text | yes |
state | text | yes |
submission_id | text | |
unit | text | yes |
unit_price | number | yes |
supplement_case_events
What happened on a supplement claim. updated_since reads created_at. Filter by case_id, kind.
| Field | Type | May be empty |
|---|---|---|
id | text | |
case_id | text | |
created_at | text | |
kind | text | |
payload | json |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
assigned_to | text | yes |
carrier_scope_id | text | yes |
claim_kind | text | |
created_at | text | |
depreciation_deadline | text | yes |
dollars_approved | number | |
dollars_found | number | |
dollars_sent | number | |
job_id | text | |
next_action | text | yes |
next_action_at | text | yes |
round | number | |
sent_at | text | yes |
stage | text | |
updated_at | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
amount | number | yes |
bucket | text | |
case_id | text | |
code | text | yes |
confidence | number | |
created_at | text | |
included | boolean | |
issue | text | |
item | text | |
note | text | yes |
priority | text | |
question | text | yes |
rule_key | text |
supplement_intake_queue
Carrier paperwork waiting for a job. updated_since reads created_at. Filter by carrier_scope_id, matched_job_id, status.
| Field | Type | May be empty |
|---|---|---|
id | text | |
candidate_job_ids | text[] | |
carrier_scope_id | text | yes |
created_at | text | |
filename | text | yes |
matched_job_id | text | yes |
resolved_at | text | yes |
source | text | |
status | text |
supplier_item_mappings
Suppliers' item numbers. updated_since reads updated_at. Filter by provider, match_kind.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
last_used_at | text | |
match_key | text | |
match_kind | text | |
provider | text | |
supplier_description | text | yes |
supplier_item_number | text | |
times_used | number | |
uom | text | yes |
updated_at | text |
suppliers
Suppliers. updated_since reads updated_at. Filter by is_active.
| Field | Type | May be empty |
|---|---|---|
id | text | |
account_number | text | yes |
address | text | yes |
contact_name | text | yes |
created_at | text | yes |
email | text | yes |
is_active | boolean | yes |
name | text | |
notes | text | yes |
phone | text | yes |
updated_at | text | yes |
task_series
Repeating tasks and appointments. updated_since reads updated_at. Filter by assigned_to.
| Field | Type | May be empty |
|---|---|---|
id | text | |
assigned_to | text | yes |
created_at | text | |
created_by | text | yes |
ended_on | text | yes |
generated_through | text | |
rule | json | |
starts_on | text | |
template | json | |
updated_at | text |
text_from_lines
Which line each kind of text leaves from. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
defaults | json | |
created_at | text | |
updated_at | text |
user_email_accounts
Connected mailboxes. updated_since reads updated_at. Filter by user_id, status, mailbox_type.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
display_name | text | yes |
email_address | text | |
label | text | yes |
last_error | text | yes |
last_synced_at | text | yes |
mailbox_type | text | |
provider | text | |
serves_all_locations | boolean | |
status | text | |
updated_at | text | |
user_id | text | yes |
user_phone_numbers
Phone numbers and voicemail. updated_since reads updated_at. Filter by status, user_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | yes |
forward_to_hail_tracker | boolean | |
phone_number | text | |
port_status | text | yes |
status | text | |
updated_at | text | yes |
user_id | text | yes |
voicemail_enabled | boolean | |
voicemail_greeting_text | text | yes |
voicemail_max_length_seconds | number |
webhook_deliveries
Webhook deliveries to the company's own addresses. updated_since reads created_at. Filter by subscription_id, event, status, resource_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
attempts | number | |
created_at | text | |
delivered_at | text | yes |
event | text | |
last_error | text | yes |
next_attempt_at | text | |
resource | text | |
resource_id | text | |
response_status | number | yes |
status | text | |
subscription_id | text |
work_order_issues
Issues crews report on work orders. updated_since reads created_at. Filter by job_id, status, work_order_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
created_by | text | yes |
decided_at | text | yes |
decided_by | text | yes |
file_ids | text[] | |
job_id | text | |
note | text | |
quantity | number | yes |
status | text | |
unit | text | yes |
work_order_id | text |
work_order_logs
Crews' daily logs on work orders. updated_since reads created_at. Filter by job_id, work_order_id, day.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
created_by | text | yes |
day | text | |
file_ids | text[] | |
job_id | text | |
note | text | |
work_order_id | text |
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.
| Field | Type | May be empty |
|---|---|---|
id | text | |
body | text | |
created_at | text | |
created_by | text | yes |
file_ids | text[] | |
job_id | text | |
language | text | yes |
work_order_id | text |
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.
| Field | Type | May be empty |
|---|---|---|
work_order_id | text | |
amount | number | yes |
cost_id | text | yes |
lines | json | |
paid_at | text | yes |
updated_at | text | |
updated_by | text | yes |
work_order_punch_items
Punch list items on work orders. updated_since reads created_at. Filter by job_id, work_order_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
created_by | text | yes |
done_at | text | yes |
done_by | text | yes |
file_ids | text[] | |
job_id | text | |
position | number | |
text | text | |
work_order_id | text |
work_order_time_entries
Time clocked on work orders. updated_since reads created_at. Filter by job_id, user_id, work_order_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
clock_in | text | |
clock_out | text | yes |
created_at | text | |
job_id | text | |
user_id | text | |
work_order_id | text |
work_orders
Work orders. updated_since reads updated_at. Filter by crew_id, job_id, status, trade.
| Field | Type | May be empty |
|---|---|---|
id | text | |
accepted_at | text | yes |
arrival_time | text | yes |
auto_created | boolean | |
calendar_task_id | text | yes |
check_task_id | text | yes |
checked_at | text | yes |
checked_by | text | yes |
colors | text | yes |
created_at | text | |
crew_id | text | yes |
days | number | |
depends_on | text | yes |
finished_at | text | yes |
hoa_status | text | yes |
homeowner_signed_at | text | yes |
homeowner_signer_name | text | yes |
homeowner_told_at | text | yes |
job_id | text | |
material_order_id | text | yes |
materials_notes | text | yes |
on_way_at | text | yes |
permit_status | text | yes |
photo_items | json | |
position | number | |
required_shots | text[] | |
scope | json | |
scope_note | text | yes |
site_notes | text | yes |
source_estimate_id | text | yes |
squares | number | yes |
start_date | text | yes |
started_at | text | yes |
status | text | |
title | text | yes |
trade | text | |
trades | text[] | |
updated_at | text |
workflow_runs
Workflow runs. updated_since reads updated_at. Filter by workflow_id, job_id, status.
| Field | Type | May be empty |
|---|---|---|
id | text | |
attempts | number | |
created_at | text | |
error | text | yes |
event_id | text | yes |
job_id | text | yes |
resume_after | text | yes |
status | text | |
updated_at | text | |
workflow_id | text |
workflows
Workflows. updated_since reads updated_at. Filter by enabled.
| Field | Type | May be empty |
|---|---|---|
id | text | |
actions | json | |
conditions | json | |
created_at | text | |
description | text | |
enabled | boolean | |
name | text | |
trigger | json | |
updated_at | text |
workspace_automations
Automation settings. updated_since reads updated_at. Filter by type, enabled.
| Field | Type | May be empty |
|---|---|---|
id | text | |
config | json | |
created_at | text | |
enabled | boolean | |
type | text | |
updated_at | text |
workspace_certifications
Certifications. updated_since reads created_at. Filter by certification_program_id.
| Field | Type | May be empty |
|---|---|---|
id | text | |
certification_program_id | text | yes |
created_at | text | |
credential_number | text | yes |
custom_badge_label | text | yes |
custom_logo_url | text | yes |
custom_organization | text | yes |
custom_program | text | yes |
display_order | number |
workspace_location_settings
Team map and knock check settings. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
knock_check_feet | number | |
team_map | boolean | |
updated_at | text | |
updated_by | text | yes |
workspace_mail_settings
Postcard settings. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
created_at | text | |
followup_days | number | |
followup_default | boolean | |
license_number | text | yes |
missed_auto_enabled | boolean | |
neighbors_auto_cards | number | |
neighbors_auto_enabled | boolean | |
phone | text | yes |
rep_monthly_limit_cents | number | |
reps_can_send | boolean | |
return_address | text | yes |
return_city | text | yes |
return_name | text | yes |
return_state | text | yes |
return_zip | text | yes |
skip_recent_days | number | |
storm_auto_enabled | boolean | |
storm_auto_max_cards | number | |
storm_auto_max_cents | number | |
storm_auto_min_hail | number | |
storm_auto_send | boolean | |
updated_at | text | |
updated_by | text | yes |
website | text | yes |
workspace_message_templates
Customer message wording. updated_since reads updated_at. Filter by enabled, template_key.
| Field | Type | May be empty |
|---|---|---|
id | text | |
body | text | yes |
created_at | text | |
enabled | boolean | |
subject | text | yes |
template_key | text | |
updated_at | text |
workspace_pricing_packages
Saved pricing packages. updated_since reads updated_at. Money: left out for a role that may not see prices.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
description | text | yes |
display_order | number | |
items | json | |
name | text | |
updated_at | text |
workspace_role_edits
What each built-in role may do here. updated_since reads updated_at. Filter by preset_key.
| Field | Type | May be empty |
|---|---|---|
preset_key | text | |
permissions | json | |
updated_at | text | |
updated_by | text | yes |
workspace_roles
Team roles. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
id | text | |
can_bill | boolean | |
can_delete_jobs | boolean | |
can_export | boolean | |
can_see_money | boolean | |
created_at | text | |
name | text | |
sees_all_jobs | boolean | |
updated_at | text |
workspace_showcases
The company showcase page. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
created_at | text | |
headline | text | yes |
intro | text | yes |
published | boolean | |
updated_at | text |
workspace_storm_list_auto
Automatic storm lists. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
assignee_ids | text[] | |
color | text | |
created_at | text | |
dedupe_days | number | yes |
enabled | boolean | |
last_built_date | text | yes |
last_run_at | text | yes |
last_skipped_reason | text | yes |
min_properties | number | |
min_size_in | number | |
property_cap | number | |
updated_at | text |
workspace_teams
Teams (who leads whose jobs). updated_since reads created_at.
| Field | Type | May be empty |
|---|---|---|
id | text | |
created_at | text | |
created_by | text | yes |
name | text |
workspace_territories
Company territories. updated_since reads updated_at. Filter by kind, state_code.
| Field | Type | May be empty |
|---|---|---|
id | text | |
confirmed_at | text | yes |
county_fips | text | yes |
county_name | text | yes |
created_at | text | |
kind | text | |
label | text | |
latitude | number | yes |
longitude | number | yes |
radius_mi | number | yes |
state_code | text | yes |
updated_at | text |
workspaces
The company. updated_since reads updated_at.
| Field | Type | May be empty |
|---|---|---|
id | text | |
name | text | |
auto_archive_after_days | number | |
auto_archive_completed_enabled | boolean | |
card_payments_enabled | boolean | |
company_address | text | yes |
company_city | text | yes |
company_email | text | yes |
company_license | text | yes |
company_phone | text | yes |
company_state | text | yes |
company_website | text | yes |
company_zip | text | yes |
created_at | text | yes |
financing_label | text | yes |
financing_url | text | yes |
At their own endpoint
| Table | Where |
|---|---|
activities | GET /jobs/{id}/timeline |
audit_events | GET /audit_log |
canvassing_pins | GET /pins |
carrier_scopes | GET /jobs/{id}/carrier_scopes |
communication_log | GET /messages |
contacts | GET /contacts |
email_drafts | GET /email_drafts |
estimate_line_items | GET /estimates/{id}/line_items |
estimates | GET /estimates |
files | GET /files |
invoice_line_items | GET /invoices/{id} |
invoices | GET /invoices |
job_costs | GET /job_costs |
job_measurements | GET /jobs/{id}/measurements |
job_notes | GET /notes |
job_payments | GET /payments |
job_people | GET /jobs/{id}/people |
jobs | GET /jobs |
pipeline_stages | GET /stages |
pipelines | GET /pipelines |
product_catalog | GET /products |
storm_list_properties | GET /storm_lists/{id}/properties |
storm_lists | GET /storm_lists |
supplement_submissions | GET /supplements |
tasks | GET /tasks |
webhook_subscriptions | GET /webhooks |
workspace_members | GET /users |
Never handed out, and why
| Table | Why |
|---|---|
ai_asks | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_briefs | HailMate 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_lags | HailMate 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_process | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_deliveries | HailMate 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_replies | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_events | HailMate 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_cases | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_examples | HailMate 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_state | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_log | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_memory | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_patterns | HailMate 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_calls | HailMate 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_rules | HailMate 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_stats | HailMate 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_state | HailMate 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_cursors | HailMate 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_reads | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_promises | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_routines | HailMate 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_steps | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_runs | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_shortcuts | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_suggestions | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_teammates | HailMate 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_chunks | HailMate 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_replies | HailMate 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_seen | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_trust | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_usage | HailMate 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_findings | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
ai_workspaces | HailMate AI's own working memory (what it read, planned and learned); what it did is on the job's timeline and in Messages |
api_keys | the company's keys: named and dated on Settings → API & MCP; a key never lists keys |
api_oauth_codes | a one-time code while an app connects |
app_link_sms_sends | a log that stops the app's download link being texted twice |
appointment_messages_sent | a log that stops an appointment message going twice; the messages themselves are in GET /messages |
appointment_type_lengths | one row per kind of appointment, keyed by the kind: set_appointment_length names it, so there is nothing to find first |
billing_mismatches | HailMate's billing of the company: its plan, charges and receipts are on Settings → Plan |
calendar_feeds | a person's own secret calendar link: whoever holds it reads their schedule |
checkout_offer_uses | HailMate's billing of the company: its plan, charges and receipts are on Settings → Plan |
checkout_payment_failures | HailMate's billing of the company: its plan, charges and receipts are on Settings → Plan |
client_field_stamps | which phone last changed a field, kept to merge offline saves |
code_answer_reports | between the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work |
companycam_connections | a connection to another company's service, holding its sign-in; it is set up on its own settings screen |
companycam_photo_failures | a connection's or a background job's own work queue; what it made is in the records it made |
custom_field_definitions | the shop's field setup, a settings screen only an owner or admin opens (every action that changes it is noApiKeys) |
customer_agreements | between the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work |
data_export_destination_secrets | the 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_contacts | the 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_jobs | the 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_media | the 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_records | the 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_counters | the next invoice, estimate and job number; the numbers themselves are on each record |
estimate_totals | facts 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_accounts | a connection to another company's service, holding its sign-in; it is set up on its own settings screen |
google_calendar_event_links | a connection's or a background job's own work queue; what it made is in the records it made |
google_calendar_events | a person's own Google Calendar, copied in to show beside HailMate's appointments (GET /tasks) |
google_calendar_routes | a person's own Google Calendar, copied in to show beside HailMate's appointments (GET /tasks) |
google_calendars | a person's own Google Calendar, copied in to show beside HailMate's appointments (GET /tasks) |
help_chats | between the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work |
hq_broadcast_sends | between the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work |
hq_crm_demo_notes | between the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work |
hq_crm_people | between the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work |
hq_crm_settings | between the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work |
hq_crm_sources | between the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work |
inbox_hidden_threads | one person's own inbox view, kept by the app |
job_auto_measure_queue | a connection's or a background job's own work queue; what it made is in the records it made |
job_card_pictures | facts 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_facts | facts 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_followups | a connection's or a background job's own work queue; what it made is in the records it made |
job_jurisdictions | facts 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_locations | facts 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_counters | the next invoice, estimate and job number; the numbers themselves are on each record |
job_stage_milestones | facts 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_shifts | where a teammate is, minute by minute: seen live on the team map by those allowed, never handed to another app |
login_sharing_alerts | HailMate's own check for one login shared by several people |
measurement_provider_connections | a connection to another company's service, holding its sign-in; it is set up on its own settings screen |
measurement_shadow_runs | facts 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_latest | where a teammate is, minute by minute: seen live on the team map by those allowed, never handed to another app |
member_locations | where a teammate is, minute by minute: seen live on the team map by those allowed, never handed to another app |
onboarding_projects | between the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work |
payment_import_profiles | how 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_feedback | between the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work |
profiles | a person's own profile: GET /me says who is acting, GET /users lists teammates |
property_lookups | a person's owner lookups, counted for the paid lookup; the owner it found is saved on the door and the contact |
property_record_areas | facts 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_tokens | the phones a person gets their own alerts on, listed on their own settings screen (the one action that changes it is noApiKeys) |
quickbooks_account_choices | QuickBooks' own lists and the choices made for them on Settings → QuickBooks; what was sent is quickbooks_sync_records |
quickbooks_connections | a connection to another company's service, holding its sign-in; it is set up on its own settings screen |
quickbooks_desktop_connections | a connection to another company's service, holding its sign-in; it is set up on its own settings screen |
quickbooks_desktop_sessions | a connection to another company's service, holding its sign-in; it is set up on its own settings screen |
quickbooks_lists | QuickBooks' own lists and the choices made for them on Settings → QuickBooks; what was sent is quickbooks_sync_records |
quickbooks_outbox | a connection's or a background job's own work queue; what it made is in the records it made |
quickbooks_settings | QuickBooks' own lists and the choices made for them on Settings → QuickBooks; what was sent is quickbooks_sync_records |
report_job_dates | facts 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 | facts 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_dirty | a connection's or a background job's own work queue; what it made is in the records it made |
roof_picture_sets | facts 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_failures | the app's own log of saves that failed, for HailMate's support |
saved_payment_methods | a card on file |
solar_paid_calls | facts 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_connections | a connection to another company's service, holding its sign-in; it is set up on its own settings screen |
spotio_events | a connection's or a background job's own work queue; what it made is in the records it made |
spotio_imports | a connection's or a background job's own work queue; what it made is in the records it made |
spotio_outbox | a connection's or a background job's own work queue; what it made is in the records it made |
subscription_events | HailMate's billing of the company: its plan, charges and receipts are on Settings → Plan |
supplement_answer_log | the supplement engine's own working state; the claims and their items are supplement_cases, supplement_gaps and supplement_asks |
supplement_eval_labels | the supplement engine's own working state; the claims and their items are supplement_cases, supplement_gaps and supplement_asks |
supplement_rerun_queue | a connection's or a background job's own work queue; what it made is in the records it made |
supplement_rule_answers | the supplement engine's own working state; the claims and their items are supplement_cases, supplement_gaps and supplement_asks |
supplement_scope_lines | the supplement engine's own working state; the claims and their items are supplement_cases, supplement_gaps and supplement_asks |
supplement_unasked_paid | the supplement engine's own working state; the claims and their items are supplement_cases, supplement_gaps and supplement_asks |
supplement_usage | the supplement engine's own working state; the claims and their items are supplement_cases, supplement_gaps and supplement_asks |
supplier_connections | a connection to another company's service, holding its sign-in; it is set up on its own settings screen |
support_requests | between the company and HailMate itself (its agreement, onboarding, support, HailMate's own sales records), not the company's work |
work_order_shots | one row per required shot on a work order, keyed by the work order and the shot: add_work_order_shot names both |
workflow_events | a connection's or a background job's own work queue; what it made is in the records it made |
workspace_activation_touches | HailMate's billing of the company: its plan, charges and receipts are on Settings → Plan |
workspace_dunning | HailMate's billing of the company: its plan, charges and receipts are on Settings → Plan |
workspace_group_admin_grants | bookkeeping of what a company admin was given in each location |
workspace_invitation_locations | the locations an invitation covers, read with the invitation on Settings → Team |
workspace_list_options | one 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_codes | HailMate's billing of the company: its plan, charges and receipts are on Settings → Plan |
workspace_seat_overage_charges | HailMate's billing of the company: its plan, charges and receipts are on Settings → Plan |
workspace_supplement_claim_charges | HailMate's billing of the company: its plan, charges and receipts are on Settings → Plan |
workspace_twilio_config | the texting carrier registration, which holds the carrier's own sign-in |
workspace_usage_counters | HailMate's billing of the company: its plan, charges and receipts are on Settings → Plan |
Keep reading