Microsoft’ data service commonly provide RESTful interfaces that utilize OData syntax. Beside the option to retrieve all records beloning to a entity you have the ability to specify additional filter criteria for your query. The filter employs various syntax and operators, including acronyms such as eq for equal and gt for greater than, among others.
| Symbol | Operator | Example |
|---|---|---|
| eq | = | $filter=size eq 100 |
| ne | != | $filter=size ne 200 |
| gt | > | $filter=size gt 50 |
| ge | >= | $filter=size ge 100 |
| lt | < | $filter=size lt 300 |
| le | <= | $filter=size le 125 |
| and | & | $filter=size gt 100 and size lt 200 |
| or | | | $filter=size lt 10 or size gt 400 |
| not | ! | $filter=not size eq 100 |
| () | precedence | $filter=(size eq 100) or (...) |
The query response has the following schema.
{
odata.metadata: "http://.../$metadata",
value:
[
{
name: "Crocodile",
url: "https://en.wikipedia.org/wiki/Crocodile"
},
{
name: "Alligator",
url: "https://en.wikipedia.org/wiki/American_alligator"
}
]
}