Understand Schema
How sheet headers become API fields
Sheetfront uses row 1 as column headers. Each visible header becomes a JSON field in API responses and can be used by forms or mini pages.
Example
| Name | Price | Active |
|---|---|---|
| Widget A | 29.99 | TRUE |
{
"data": [
{ "name": "Widget A", "price": 29.99, "active": true }
]
}Header Rules
| Sheet header | API field |
|---|---|
Product Name | product_name |
Price ($) | price |
QTY | qty |
duplicate Name | name, name_1 |
| blank header | column_a |
Value Rules
| Cell value | API value |
|---|---|
29.99 | 29.99 |
TRUE / FALSE | true / false |
| empty cell | null |
| formula | computed value |
Renaming a header changes the API field name. Update clients before changing production sheets.
Refresh Schema
After changing headers, open the connection and click Refresh Schema.
Visibility
Use the connection Configuration tab to hide columns that should not appear publicly. Hidden columns are excluded from API responses, mini-page search, filters, metadata, and mapping choices.