CRUD & filters

Select, insert, update, and delete over HTTP.

GET

terminal

curl "$PROJECT_URL/rest/products?limit=10&order=created_at.desc&active=eq.true" \
  -H "Authorization: Bearer $ANON_KEY"

Filter syntax: column=op.value where op is eq|neq|gt|gte|lt|lte|like|ilike|is.

POST

terminal

curl -X POST "$PROJECT_URL/rest/products" \
  -H "Authorization: Bearer $SERVICE_ROLE_KEY" \
  -H "Content-Type: application/json" \
  -d '{"name":"Keyboard","price":99}'

PATCH / DELETE

terminal

curl -X PATCH "$PROJECT_URL/rest/products/$ID" \
  -H "Authorization: Bearer $SERVICE_ROLE_KEY" \
  -H "Content-Type: application/json" \
  -d '{"price":79}'

curl -X DELETE "$PROJECT_URL/rest/products/$ID" \
  -H "Authorization: Bearer $SERVICE_ROLE_KEY"