Filters: ?select=?order=?limit=?column=eq.value. Responses cap at 1,000 rows — page with &offset= or results truncate with no error.
Certificates of analysis
Feed
What it holds
Rows
coas
every certificate record, all sources
8387
coa_library
the portal's combined library
8385
coa_lots
lots with parsed potency / microbial
3176
coa_pdf_index
which lots have a certificate file on record
5679
coa_smartsheet
raw submission-tracker rows
5209
coa_sync_status
last sync outcome
20
Sales & operations
Feed
What it holds
Rows
sop_shipments
shipment lines, all channels
2924
sop_live
recreational actuals by month & category
100
sop_live_b2b
B2B actuals by month & category
110
sop_actuals_by_month
units by category & ship month
193
sop_b2b_reconcile
B2B sliced for reconciliation
31
sop_sync_status
last sync outcome
20
Regulatory
Feed
What it holds
Rows
reg_news
regulatory feed, refreshed hourly
850
reg_countries
country register
51
reg_country_sources
sources behind each country
12
Procurement & finance
Feed
What it holds
Rows
procurement_lots
flower procurement lots
40
fp_lots
same, portal shape
40
erp_rows
ERP records
524
Project management
Feed
What it holds
Rows
pm_tasks
tasks
76
pm_projects
projects
4
pm_people
people directory
33
pm_automations
automation rules
1
pm_email_outbox
outbound notification queue
0
Shared app storage (your app writes here)
Feed
What it holds
Rows
app_state
universal store — the block below uses this
0
crm_rec_state
Recreational CRM
1
crm_b2b_state
B2B CRM
0
crm_intl_state
International CRM
0
sellthru_state
Sell-Through
1
sop_state
S&OP shared inputs
1
qms_state
QMS
1
Thin today — present but barely populated
Feed
What it holds
Rows
products
product master
1
companies
company master
6
inventory_on_hand
on-hand inventory
1
lots
lots
1
Worth knowing
Every app shares one store, separated by the name you choose. Any signed-in colleague could in principle read or write another app's space — the boundary is the company sign-in, not a wall between apps. If your app will hold something sensitive, ask for its own isolated area instead.
When to ask
Self-serve covers everything above. You still need a hand for: an app that must hold sensitive data in its own isolated area, a new automatic import from SharePoint or Smartsheet, or file and PDF storage.