Field Definitions
Property Fields
Field
Type
Description
property_id
string
Unique property identifier
address
string
Street address (max 255 chars)
city
string
City name
state
string
2-letter state code (CA, NY, etc)
zip
string
ZIP/postal code
price
number
List price in USD
bedrooms
integer
Number of bedrooms
bathrooms
number
Full/half bathrooms (e.g., 3.5)
sqft
integer
Square footage of living space
status
string
active, pending, sold, expired, withdrawn
list_date
date
YYYY-MM-DD format
mls_id
string
MLS number
property_type
string
See Property Types section
lot_size
string
e.g., '0.25 acres'
year_built
integer
Construction year
Registrant Fields
Field
Type
Description
registrant_id
string
Unique lead identifier
first_name
string
Lead first name
last_name
string
Lead last name
email
string
Email address (RFC 5322)
phone
string
Phone number (various formats accepted)
registration_date
date-time
When lead registered
property_id
string
Associated property
status
string
new, contacted, qualified, converted, closed
lead_source
string
open_house, website, search, inquiry
answers
array
Custom form responses
Common Data Types
string: Text data, variable length
integer: Whole numbers (no decimals)
number: Decimal numbers (e.g., bathrooms: 2.5)
boolean: true or false
date: YYYY-MM-DD format
date-time: YYYY-MM-DDTHH:MM:SSZ (UTC)
array: List of items [item1, item2]
object: Named key-value pairs {key: value}
