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