REST/ROA Architecture - Send database search/querying/filter/sorting parameters in URL? (>, <, IN, e

Posted by DutrowLLC on Stack Overflow See other posts from Stack Overflow or by DutrowLLC
Published on 2010-06-01T00:36:17Z Indexed on 2010/06/01 0:43 UTC
Read the original article Hit count: 310

Filed under:
|
|
|
|

I'm building a REST interface to my application using ROA (Resource Oriented Architecture) .

I'd like to give the client the ability to specify search parameters in URL. So a client could say "Give me all people who's:

  • "first_name" is equal to "BOB"
  • "age" is greater than "30"
  • sort by "last_name"

I was thinking something like:

GET /PEOPLE/{query_parameters}/{sort_parameters}

...or perhaps

GET /PEOPLE?query=<query_string>&sort=<sort_string>

...but I'm unsure what syntax would be good for specifying in the COLUMN_NAME-OPERATOR-VALUE triplicates. I was thinking perhaps something like:

column_name.operator.value

So the client could say:

GET /PEOPLE?query=first_name.EQUALS.bob&query=age.GREATER_THAN.30&sort=last_name.ASCENDING

I really don't want to re-invent the wheel here, are there some accepted ways that this is done? I am using Restlets, I don't know if that makes a difference.

© Stack Overflow or respective owner

Related posts about url

Related posts about rest