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.

Use these endpoints to manage the full lifecycle of a place record — from initial creation through updates and eventual deletion. All endpoints are prefixed with /api/Places.

​
GET /api/Places

Returns an array of all place records. 
curl -X GET https://your-api-host/api/Places

​
Response

​
place_id
integer
Unique identifier for the place.
​
name
string
Display name of the place.
​
type_id
integer
Numeric ID of the place type.
​
name_type
string
Human-readable label for the place type (read-only, resolved by the database).
​
description
string
Optional text description of the place.
​
address
string
Street or postal address.
​
city_id
integer
Numeric ID of the city.
​
name_city
string
Human-readable city name (read-only, resolved by the database).
​
opening_hours
string
Opening hours as a free-form string (e.g. "Mon–Fri 9 am–6 pm").
​
fees
string
Admission or usage fees as a free-form string.
​
coordinates
string
Geographic coordinates (e.g. "4.7110,-74.0721").
​
contact_phone
string
Contact phone number.
​
contact_email
string
Contact email address.
​
social_media
string
Social media handle or URL.
​
status
integer
Active state of the place. 1 = active, 0 = inactive.
​
creation_date
string (ISO 8601)
Timestamp when the place was created.

​
Error codes

CodeMeaning
500Internal server error while retrieving places.

​
GET /api/Places/{id}

Returns a single place record by its ID.

​
Path parameters

​
id
integer
required
The numeric ID of the place to retrieve.
curl -X GET https://your-api-host/api/Places/7

​
Response

Returns a single Places object with the same fields listed under GET /api/Places.

​
Error codes

CodeMeaning
404No place found with the given ID.
500Internal server error while retrieving the place.

​
POST /api/Places

Creates a new place record.

​
Request body

​
name
string
required
Display name of the place.
​
type_id
integer
Numeric ID of the place type.
​
description
string
Optional text description of the place.
​
address
string
Street or postal address.
​
city_id
integer
Numeric ID of the city where the place is located.
​
opening_hours
string
Opening hours as a free-form string.
​
fees
string
Admission or usage fees as a free-form string.
​
coordinates
string
Geographic coordinates, e.g. "4.7110,-74.0721".
​
contact_phone
string
Contact phone number.
​
contact_email
string
Contact email address.
​
social_media
string
Social media handle or URL.
curl -X POST https://your-api-host/api/Places \
  -H "Content-Type: application/json" \
  -d '{
    "name": "Parque El Virrey",
    "type_id": 3,
    "description": "Urban park in Bogotá",
    "address": "Calle 88, Bogotá",
    "city_id": 1,
    "opening_hours": "Daily 6 am–8 pm",
    "fees": "Free",
    "coordinates": "4.6780,-74.0491",
    "contact_phone": "+57 1 123 4567",
    "contact_email": "[email protected]",
    "social_media": "@parqueelvirrey"
  }'

​
Response

"Lugar insertado exitosamente."

​
Error codes

CodeMeaning
500Internal server error while inserting the place.

​
PUT /api/Places/{id}

Updates an existing place record. You must supply all editable fields; omitted optional fields are set to null.

​
Path parameters

​
id
integer
required
The numeric ID of the place to update.

​
Request body

​
name
string
required
Display name of the place.
​
type_id
integer
Numeric ID of the place type.
​
description
string
Text description of the place.
​
address
string
Street or postal address.
​
city_id
integer
Numeric ID of the city.
​
opening_hours
string
Opening hours as a free-form string.
​
fees
string
Admission or usage fees.
​
coordinates
string
Geographic coordinates.
​
contact_phone
string
Contact phone number.
​
contact_email
string
Contact email address.
​
social_media
string
Social media handle or URL.
​
status
integer
Active state. 1 = active, 0 = inactive. Prefer the dedicated activate/deactivate endpoints for toggling status.
curl -X PUT https://your-api-host/api/Places/7 \
  -H "Content-Type: application/json" \
  -d '{
    "name": "Parque El Virrey (Renovado)",
    "type_id": 3,
    "city_id": 1,
    "status": 1
  }'

​
Response

"Lugar con ID 7 actualizado exitosamente."

​
Error codes

CodeMeaning
500Database or server error while updating the place.

​
PUT /api/Places/activate/{id}

Sets the status of a place to active.

​
Path parameters

​
id
integer
required
The numeric ID of the place to activate.
curl -X PUT https://your-api-host/api/Places/activate/7

​
Response

"Lugar con ID 7 activado correctamente."

​
Error codes

CodeMeaning
500Internal server error while activating the place.

​
PUT /api/Places/deactivate/{id}

Sets the status of a place to inactive.

​
Path parameters

​
id
integer
required
The numeric ID of the place to deactivate.
curl -X PUT https://your-api-host/api/Places/deactivate/7

​
Response

"Lugar con ID 7 desactivado correctamente."

​
Error codes

CodeMeaning
500Internal server error while deactivating the place.

​
DELETE /api/Places/{id}

Permanently deletes a place record from the database.

​
Path parameters

​
id
integer
required
The numeric ID of the place to delete.
curl -X DELETE https://your-api-host/api/Places/7

​
Response

"Lugar con ID 7 eliminado exitosamente."

​
Error codes

CodeMeaning
500Database or server error while deleting the place.

Build docs developers (and LLMs) love

Get started for freeTalk to us