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.

The SolSQL API exposes read-only endpoints for audit logs and comment statistics. You can use these endpoints to monitor data-change activity across all tables, track user registration events, and analyze comment volume over time.
All endpoints on this page are read-only. They do not support POST, PUT, or DELETE operations.

​
Audit logs

​
GET /api/vw_logs

Returns the full audit log. Each entry records a data-change event on a specific table. 
curl -X GET https://your-api-host/api/vw_logs
Response — 200 OK 
[
  {
    "Id": 1,
    "Table_name": "places",
    "Action_type": "INSERT",
    "description": "New place added: Parque El Poblado",
    "action_timestamp": "2024-03-15T10:32:00"
  }
]
​
Id
integer
Unique identifier for the log entry.
​
Table_name
string
The name of the database table where the action occurred.
​
Action_type
string
The type of operation that was performed (e.g. INSERT, UPDATE, DELETE).
​
description
string
A human-readable summary of the action that was logged.
​
action_timestamp
string (datetime)
The date and time when the action occurred, in ISO 8601 format.

​
Registration logs

​
GET /api/vw_logs_register

Returns aggregated registration activity. Each entry groups registration events by date and action type. 
curl -X GET https://your-api-host/api/vw_logs_register
Response — 200 OK 
[
  {
    "Fecha": "2024-03-15T00:00:00",
    "Action_type": "INSERT",
    "Total": 12
  }
]
​
Fecha
string (datetime)
The date for which this registration summary applies.
​
Action_type
string
The type of registration action (e.g. INSERT).
​
Total
integer
The number of registration events of this action type on the given date.

​
Comment statistics

​
GET /api/vw_totalcomments_date

Returns the total number of comments grouped by date. Use this endpoint to visualize comment activity over time. 
curl -X GET https://your-api-host/api/vw_totalcomments_date
Response — 200 OK 
[
  { "Fecha": "2024-03-15T00:00:00", "Total": 47 },
  { "Fecha": "2024-03-16T00:00:00", "Total": 32 }
]
​
Fecha
string (datetime)
The date for which the comment count is aggregated.
​
Total
integer
The number of comments posted on that date.

​
GET /api/vw_totalcomments_users

Returns the total number of comments grouped by user. Use this endpoint to identify the most active commenters. 
curl -X GET https://your-api-host/api/vw_totalcomments_users
Response — 200 OK 
[
  { "name": "Maria Lopez", "total": 38 },
  { "name": "Carlos Ruiz", "total": 21 }
]
​
name
string
The name of the user who posted the comments.
​
total
integer
The total number of comments posted by this user.

​
Error codes

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

Build docs developers (and LLMs) love

Get started for freeTalk to us