search_by_value

POST http://localhost:9925

Method for searching records by value. Returns an array of records. You can search on any attribute.

• operation (required) - must always be 'searchbyvalue'
• schema (required) - schema where the table you are searching lives
• table (required) - table you wish to search
• hashattribute (required) - hashattribute for table you are searching. defined in addtable
• searchattribute (required) - attribute you wish to search can be any attribute
• searchvalue (required) - value you wish to search - wild cards are allowed.
• getattriburtes (required) - define which attributes you want returned. Use '*' to return all attributes.

Request Body

{"operation"=>"search_by_value", "table"=>"dog", "schema"=>"dev", "hash_attribute"=>"id", "search_attribute"=>"breed", "search_value"=>"Mu*", "get_attributes"=>["name"]}

HEADERS

RESPONSES

status: OK

[{"name":"ENGLISH POINTER"},{"name":"ENGLISH SETTER"},{"name":"ENGLISH COCKER SPANIEL"},{"name":"ENGLISH TOY TERRIER (BLACK \u0026TAN)"},{"name":"ENGLISH SPRINGER SPANIEL"},{"name":"ENGLISH FOXHOUND"}]