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)') |