Skip to main content

Documentation Index

Fetch the complete documentation index at: https://mintlify.com/jparra-amell/api_solsql/llms.txt

Use this file to discover all available pages before exploring further.

Place types categorize every place registered in SolSQL. Examples include restaurant, park, museum, or hotel. Each place type has a human-readable name and an optional description. You assign a place type when you create or update a place.

Endpoints

GET /api/PlaceTypes

Returns all place types in the system.
curl -X GET https://your-api-host/api/PlaceTypes
Response — 200 OK
[
  { "Id": 1, "Name": "Restaurant", "Description": "Food and dining venues" },
  { "Id": 2, "Name": "Park",       "Description": "Public outdoor spaces" }
]
Id
integer
Unique identifier for the place type (type_id column).
Name
string
Short label for the place type (e.g. "Restaurant").
Description
string
Optional longer description of the place type.

GET /api/PlaceTypes/

Returns a single place type by its ID.

Path parameters

id
integer
required
The place type ID to look up.
curl -X GET https://your-api-host/api/PlaceTypes/1
Response — 200 OK Returns an array. If no place type exists with the given ID, the stored procedure returns an empty array.
[{ "Id": 1, "Name": "Restaurant", "Description": "Food and dining venues" }]
Response — 500 Internal Server Error
{ "message": "Unexpected error", "error": "<database error message>" }

POST /api/PlaceTypes

Creates a new place type.

Request body

Name
string
required
A short label for the new place type.
Description
string
An optional description that explains what this place type covers.
curl -X POST https://your-api-host/api/PlaceTypes \
  -H "Content-Type: application/json" \
  -d '{ "Name": "Museum", "Description": "Cultural and historical exhibition spaces" }'
Response — 200 OK
{ "message": "Place type created successfully" }

PUT /api/PlaceTypes/

Updates an existing place type.

Path parameters

id
integer
required
The ID of the place type to update.

Request body

Name
string
required
The updated label for the place type.
Description
string
The updated description for the place type.
curl -X PUT https://your-api-host/api/PlaceTypes/1 \
  -H "Content-Type: application/json" \
  -d '{ "Name": "Restaurant", "Description": "Food, dining, and café venues" }'
Response — 200 OK
{ "message": "Place type updated successfully" }

DELETE /api/PlaceTypes/

Deletes a place type by its ID.

Path parameters

id
integer
required
The ID of the place type to delete.
curl -X DELETE https://your-api-host/api/PlaceTypes/1
Response — 200 OK
{ "message": "Place type deleted successfully" }

Error codes

StatusMeaning
200Request succeeded.
500A database or server error occurred. The response body contains message and error fields with details.

Build docs developers (and LLMs) love