in reply to Re^3: Complex filter queries in a REST API
in thread Complex filter queries in a REST API

Thanks for this suggestion. I was clearly overthinking the situation.

I need to comply to the REST style and must use a GET request, but my cases are small enough that using a JSON string should be possible. And SQL abstract is already familiar, so implementation should not be an issue. I will test this approach.

Kind regards

  • Comment on Re^4: Complex filter queries in a REST API

Replies are listed 'Best First'.
Re^5: Complex filter queries in a REST API
by bliako (Abbot) on Mar 26, 2021 at 15:52 UTC

    Just to clarify (and to others): I merely said that *I* use POST. Nothing stops you using GET+JSON but the max URI length.

    In my first post I deleted accidentally a serious caveat: that with a SQL::Abstract-style query you are exposing the structure of your DB to the client unless you alias field and table names.

    bw, bliako

[reply]

In Section Seekers of Perl Wisdom