SQLPage as an API endpoint

[Pieter3033]

I am trying to figure out how to create a API endpoint to post data in my database.

I was trying sqlpage.variables('post') but it only accepts 'Content-Type: application/x-www-form-urlencoded'

Essentially i need to post data from a API with Content-Type specifically being application/json.

Is this possible in SQLPage, or should a custom component/ function be built to achieve this?

[lovasoa]

Hi @Pieter3033 ! Long time no see ! How have you been doing ?

It is currently not possible to read json request bodies, but it's on my long list of planned features. See #316

[Pieter3033]

Hi @lovasoa , good to hear from you. Been held up with work these last few months but things are going well thanks and yourself?

Could you possibly guide me in the right direction to either create a custom javascript/ component for the time being or perhaps attempting to create it to align with SQLPage's code for a future update?

[lovasoa]

You know what, I'll build it for the next update. I've delayed that one for too long !

I'll add two functions,

• sqlpage.request_body() that returns the body as a string (on which you can then use your database's json functions)
• sqlpage.request_body_base64() that encodes the request body as base64, for easily storing the results, or converting it to a data-url.

example

echo_server.sql

select 'shell-empty' as component, sqlpage.request_body() as html;

result

❯ http -v 'localhost:8080/echo_server' test=42
POST /echo_server HTTP/1.1
Accept: application/json, */*;q=0.5
Accept-Encoding: gzip, deflate
Connection: keep-alive
Content-Length: 14
Content-Type: application/json
Host: localhost:8080
User-Agent: HTTPie/3.2.3

{
    "test": "42"
}


HTTP/1.1 200 OK
content-encoding: gzip
content-security-policy: script-src 'self' 'nonce-4653502835151526632'
content-type: text/html; charset=utf-8
date: Mon, 10 Feb 2025 09:43:35 GMT
server: sqlpage v0.33.0
transfer-encoding: chunked
vary: accept-encoding

{
    "test": "42"
}

(the next version also allows dropping the .sql at the end of URLs)

[Pieter3033]

That would work perfectly thank you Ophir.

[lovasoa]

I implemented it, it will be in v0.33, to be released soon. You can already try it with lovasoa/sqlpage:main on docker.