| api | توضیحات |
|---|---|
| GET api/Goods | لیست کالا ها |
| GET api/Goods/5 | نمایش یک کالا |
| POST api/Goods | ایجاد یک کالا |
| DELETE api/Goods/5 | حذف یک کالا |
| api | توضیحات |
|---|---|
| GET api/Suggestions | لیست پیشنهاد ها |
| GET api/Suggestions/5 | نمایش یک پیشنهاد |
|
Option |
Description |
|---|---|
|
|
Directs that related records should be retrieved in the record or collection being retrieved. |
|
|
Specifies an expression or function that must evaluate to true for a record to be returned in the collection. |
|
|
Determines what values are used to order a collection of records. |
|
|
Specifies a subset of properties to return. |
|
|
Sets the number of records to skip before it retrieves records in a collection. |
|
|
Determines the maximum number of records to return. |
|
Operator |
Description |
Example |
|---|---|---|
|
eq |
Equal |
/AccountSet?$filter=Address1_City eq 'Redmond' |
|
ne |
Not equal |
/AccountSet?$filter=Address1_City ne null |
|
gt |
Greater than |
/AccountSet?$filter=CreditLimit/Value gt 1000 |
|
ge |
Greater than or equal |
/AccountSet?&$filter=CreditLimit/Value ge 1000 |
|
Lt |
Less than |
/AccountSet?$filter=CreditLimit/Value lt 1000 |
|
le |
Less than or equal |
/AccountSet?$filter=CreditLimit/Value le 1000 |
|
and |
Logical and |
/AccountSet?$filter=CreditLimit/Value ge 1000 and Address1_StateOrProvince eq 'TX' |
|
or |
Logical or |
/AccountSet?$filter=AccountCategoryCode/Value eq 2 or AccountRatingCode/Value eq 1 |
|
not |
Logical Negation |
/AccountSet?$filter=(AccountCategoryCode/Value ne null) and not (AccountCategoryCode/Value eq 1) |
|
Function |
Example |
|---|---|
|
startswith |
/AccountSet?$filter=startswith(Name, 'a') |
|
substringof |
/AccountSet?$filter=substringof('store',Name) |
|
endswith |
/AccountSet?$filter=endswith(Name, '(sample)') |