RevRex MVP Backend

Google review fetch + emergency complaint flagging for field-service teams.

This deployment exposes a server-side fetch endpoint that ingests Google reviews for a Place ID, stores them in Neon Postgres, and flags 1-star reviews mentioning emergency or after-hours issues.

Endpoint

POST /api/reviews/fetch?place_id=PLACE_ID

Environment

DATABASE_URL
GOOGLE_MAPS_API_KEY

Quick Test

curl -X POST \

"https://revrex.nanocorp.app/api/reviews/fetch?place_id=YOUR_PLACE_ID"

Reviews are stored in businesses and reviews. The API auto-creates the schema on first use and also ships a SQL migration for direct database setup.

Flagging rules match these keywords on 1-star reviews: emergency, emergency call, after-hours, after hours, urgent.