Options and Limitations

Refine the results of your query by using query options.

• $search
• $top and $skip
• $filter
• $orderby
• $format

This section will help you go through query options supported by Envi OData API and common scenarios for using them. Envi OData API is based on OData protocol v4.0 but has its custom implementation, so currently, not all query options are supported. Envi API allows using query options for all resources that return lists of entities, except those for which actions or functions are applied to OData.

Also, Envi OData API defines a set of logical operators that evaluate True or False. Logical operators are typically used in the $filter query option to filter the set of resources. For more details, go to the $filter article. The concept of logical operators is simple. They allow the program to make a decision based on multiple conditions. Each operand is considered a condition that can be evaluated True or False. These operands can combine multiple Boolean expressions or values and provide a single Boolean output.

$search

The $search system query option allows searching through all available entity fields in a collection of resources that are addressed by the request URL. The expression specified by $search consists of the search value only, which is treated as the like expression.

• The expression of the item evaluates True for at least one of the fields included in the response.
• The expression of resources evaluates False or Null for all searchable fields omitted in the response.

Request Example

https://<HOSTNAME>/odata/Inventory?$search="inv" 

(for example, <HOSTNAME> = api-demo.envi.net)

The following request example filters target records set based on the inv search value. If any searchable fields contain inv, the entity is included in the response.

Since no $top option is specified, only the first 20 records are included in the response. Except for the $top and $skip options, @odata.nextLink includes the $search option.

Response example

{
    "@odata.context": "https://api-demo.envi.net/odata/$metadata#Inventory",
    "@odata.count": 174,
    "value": [
    {
    ....
    "organizationName": "Invision Test Org",
    ....
    },
    {
    ....
    "inventoryNo": "Inv #10",
    ....
    },
    {
    ....
    "classificationName": "Capital Inventory",
    ....
    },
    ....
    {....}
    ],
    "@odata.nextLink": "https://api-demo.envi.net/odata/Inventory?$search=inv&$top=20&$skip=20"
    }

$top and $skip

The $top system query option requests the number of items in the queried collection included in the result.

Due to the $top operator max value, the current limit is 5 000 records within one API request. When the specified $top value is greater than the limit, you will receive the response—400 Bad Request.

The $skip query option requests the number of items in the queried collection that should be skipped and not included in the response. If the $top option is not provided, Envi API automatically adds $top=20 to the initial query. So, the response contains only the first 20 records.

Request Example

https://<HOSTNAME>/odata/Inventory 

(for example, <HOSTNAME> = api-demo.envi.net)

Since neither the $top nor $skip options are specified, the system uses default values, so a response contains the first 20 records from the matched list, and @odata.nextLink is composed based on default values.

Response Example

{
    "@odata.context": "https://api-demo.envi.net/odata/$metadata#Inventory",
    "@odata.count": 17521,
    "value": [
    {
    "inventoryId": "732adaec-fd14-44e5-b3d6-603fe893bc15",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    {....},
    ....
    {....}
    ],
    "@odata.nextLink": "https://api-demo.envi.net/odata/Inventory?$top=20&$skip=20"
    }

Request Example

https://<HOSTNAME>/odata/Inventory?$top=5

(for example, <HOSTNAME> = api-demo.envi.net)

Since the $top option is specified, the system returns the first 5 records from the matched list, and @odata.nextLink is composed based on this value.

Response Example

{
    "@odata.context": "https://api-demo.envi.net/odata/$metadata#Inventory",
    "@odata.count": 17521,
    "value": [
    {
    "inventoryId": "732adaec-fd14-44e5-b3d6-603fe893bc15",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    {....},
    ....
    {....}
    ],
    "@odata.nextLink": "https://api-demo.envi.net/odata/Inventory?$top=5&$skip=5"
    }

Request Example

https://<HOSTNAME>/odata/Inventory?$skip=10

(for example, <HOSTNAME> = api-demo.envi.net)

Since the $skip option is specified, but $top is not, the system skips the first 10 records and uses a default value for the $top option, so the next 20 records from the matched list (after 10 records that are skipped) are returned, and @odata.nextLink is composed based on the following value.

Response Example

{
    "@odata.context": "https://api-demo.envi.net/odata/$metadata#Inventory",
    "@odata.count": 17521,
    "value": [
    {
    "inventoryId": "732adaec-fd14-44e5-b3d6-603fe893bc15",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    {....},
    ....
    {....}
    ],
    "@odata.nextLink": "https://api-demo.envi.net/odata/Inventory?$top=20&$skip=30"
    }

$filter

The $filter system query option allows clients to filter a collection of resources addressed by a request URL. The expression specified with the$filter is evaluated for each resource in the collection, and only items, in which the expression is evaluated True are included in the response. Resources in which the expression is evaluated False or Null are skipped in the response. Property names should be specified in lowerCamelCase.

Now, Envi API allows filtering by the following functions:

• Contains—treated as the like expression. The system searches the specified value in any part of the property.

Also, Envi API supports the following logical operations:

• Equals—treated as the Strict match expression. It means that a specified property should exactly be matched with a provided value.

Request Example

https://<HOSTNAME>/odata/Inventory?$filter=notes eq 'Capital Item'

(for example, <HOSTNAME> = api-demo.envi.net)

This request example filters target records set based on the value of notes property, and if it equals Capital Item, an entity will be included in the resulting set.

Since no $top option is specified, only the first 20 records will be included. Except for the $top and $skip options, @odata.nextLink in the response will include the $filter option.

Response Example

{
    "@odata.context": "https://api-demo.envi.net/odata/$metadata#Inventory",
    "@odata.count": 52,
    "value": [
    {
    ....
    "notes": "Capital Item",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    {
    ....
    "notes": "Capital Item",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    ....
    {....}
    ],
    "@odata.nextLink": "https://api-demo.envi.net/odata/Inventory?$filter=notes%20eq%20%27%21%20Capital%20Item%27&$top=20&$skip=20"
    }

Request Example

https://<HOSTNAME>/odata/Inventory?$filter=contains(notes, 'Capital')

(for example, <HOSTNAME> = api-demo.envi.net)

This request example filters target records set based on the value of notes property, and if it contains Capital in any part of the text, an entity will be included in the resulting set.

Since no $top option is specified, only the first 20 records will be included. Except for the $top and $skip options, @odata.nextLink in the response will include the $filter option.

Response Example

{
    "@odata.context": "https://api-demo.envi.net/odata/$metadata#Inventory",
    "@odata.count": 92,
    "value": [
    {
    ....
    "notes": "Capital Item",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    {
    ....
    "notes": "Not Capital",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
      ....
    },
    {
    ....
    "notes": "Can be treated as Capital",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    ....
    {....}
    ],
    "@odata.nextLink": "https://api-demo.envi.net/odata/Inventory?$filter=contains%28notes,%20%27Capital%27%29&$top=20&$skip=20"
    }

Logical operators

Also, the $filter query option supports the following logical operators:

and

The logical and operator evaluates True if both the left and right operands evaluate True, otherwise it evaluates False.

Example

https://api-demo.envi.net/odata/Inventory?$filter=classificationName eq 'MEDICATION' and inventoryNo eq 'DEXAMT'

or

The logical or operator evaluates True if one of the left or right operands evaluates True, otherwise it evaluates False.

Example

https://api-demo.envi.net/odata/Inventory?$filter=classificationName eq 'MEDICATION' or contains(inventoryDescription, 'DEXAMT')

in

The in operator returns True if the left operand is a member of the right operand. The right operand must be either a comma-separated list of values enclosed in parentheses or a single expression that resolves to a collection. Also, the in operator enables a shorthand way of writing multiple eq expressions joined by or.

Example

https://api-demo.envi.net/odata/Inventory?$filter=classificationName eq 'MEDICATION' or classificationName eq = 'DEXAMT' 

https://api-demo.envi.net/odata/Inventory?$filter=classificationName in ('MEDICATION', 'DEXAMT')

The in operator is supported in the following lists:

• Addresses
• Classifications
• Facilities
• Inventory
• Inventory Activity
• Inventory Locations
• Inventory Locations Cost and Quantity
• Inventory Location Extended
• Inventory Snapshots
• Inventory Snapshot Item Details
• Inventory Vendors
• Manufacturers
• Matched Invoices
• Matched Invoice Items
• Purchase Orders
• Purchase Orders Items
• Receipts
• Receipts Items
• PAR Areas
• PAR Area Items
• PO Confirmations
• PO Confirmations Items
• Requisition Fill Items
• Requisition Fills
• Requisition Items
• Requisitions
• Vendor Addresses
• Vendor Contacts
• Vendor Email Configurations
• Vendor Facilities
• Vendor Fax Configurations
• Vendors

gt

The gt operator returns True if the left operand is greater than the right operand, otherwise it returns False. This operator supports decimal, integer, and dates values.

Example

https://api-demo.envi.net/odata/PurchaseOrders?$filter=unitCost gt 1.2345 

The gt operator is supported in the following lists:

• Addresses
• Classifications
• Facilities
• Inventory
• Inventory Location Extended
• Inventory Locations
• Inventory Snapshots
• Inventory Snapshot Item Details
• Inventory Vendors
• Manufacturers
• Matched Invoice Items
• Matched Invoices
• Purchase Orders
• Purchase Orders Items
• Receipts
• Receipts Items
• PAR Areas
• PAR Area Items
• PO Confirmations
• PO Confirmations Items
• Requisition Fill Items
• Requisition Fills
• Requisition Items
• Requisitions
• Vendor Addresses
• Vendor Contacts
• Vendor Email Configurations
• Vendor Facilities
• Vendor Fax Configurations
• Vendors

ge

The ge operator returns True if the left operand is greater than or equal to the right operand, otherwise it returns False. This operator supports decimal, integer, and dates values.

Example

https://api-demo.envi.net/odata/PurchaseOrders?$filter=lastUpdated ge YYYY-MM-DD

The ge operator is supported in the following lists:

• Addresses
• Classifications
• Facilities
• Inventory
• Inventory Location Extended
• Inventory Locations
• Inventory Snapshots
• Inventory Snapshot Item Details
• Inventory Vendors
• Manufacturers
• Matched Invoice Items
• Matched Invoices
• Purchase Orders
• Purchase Orders Items
• Receipts
• Receipts Items
• PAR Areas
• PAR Area Items
• PO Confirmations
• PO Confirmations Items
• Requisition Fill Items
• Requisition Fills
• Requisition Items
• Requisitions
• Vendor Addresses
• Vendor Contacts
• Vendor Email Configurations
• Vendor Facilities
• Vendor Fax Configurations
• Vendors

lt

The lt operator returns True if the left operand is less than the right operand, otherwise it returns False. This operator supports decimal, integer, and dates values.

Example

https://api-demo.envi.net/odata/PurchaseOrders?$filter=unitCost lt 1.2345

The lt operator is supported in the following lists:

• Addresses
• Classifications
• Facilities
• Inventory
• Inventory Location Extended
• Inventory Locations
• Inventory Snapshots
• Inventory Snapshot Item Details
• Inventory Vendors
• Manufacturers
• Matched Invoice Items
• Matched Invoices
• Purchase Orders
• Purchase Orders Items
• Receipts
• Receipts Items
• PAR Areas
• PAR Area Items
• PO Confirmations
• PO Confirmations Items
• Requisition Fill Items
• Requisition Fills
• Requisition Items
• Requisitions
• Vendor Addresses
• Vendor Contacts
• Vendor Email Configurations
• Vendor Facilities
• Vendor Fax Configurations
• Vendors

le

The le operator returns True if the left operand is less than or equal to the right operand, otherwise it returns False. This operator supports decimal, integer, and dates values.

Example

https://api-demo.envi.net/odata/PurchaseOrders?$filter=lastUpdated le YYYY-MM-DD

The le operator is supported in the following lists:

• Addresses
• Classifications
• Facilities
• Inventory
• Inventory Location Extended
• Inventory Locations
• Inventory Snapshots
• Inventory Snapshot Item Details
• Inventory Vendors
• Manufacturers
• Matched Invoice Items
• Matched Invoices
• Purchase Orders
• Purchase Orders Items
• Receipts
• Receipts Items
• PAR Areas
• PAR Area Items
• PO Confirmations
• PO Confirmations Items
• Requisition Fill Items
• Requisition Fills
• Requisition Items
• Requisitions
• Vendor Addresses
• Vendor Contacts
• Vendor Email Configurations
• Vendor Facilities
• Vendor Fax Configurations
• Vendors

Warning

You can use only one type of logical operators at once.

Example

https://api-demo.envi.net/odata/Inventory?$filter=classificationName eq 'MEDICATION' and inventoryNo eq '27417' and contains(inventoryDescription, '27417')

OR

https://api-demo.envi.net/odata/Inventory?$filter=classificationName eq 'MEDICATION' or inventoryNo eq '27417' or contains(inventoryDescription, '27417')

You cannot mix logical operators together as in the following example. In such cases, you’ll receive the 400 Bad Request response.

Example

https://api-demo.envi.net/odata/Inventory?$filter=classificationName eq 'MEDICATION' and inventoryNo eq '27417' or contains(inventoryDescription, '27417')

Use logical operators only with different fields for searching, as in the following example. You’ll receive the 400 Bad Request response if you specify the same fields.

Example

https://api-demo.envi.net/odata/Inventory?$filter=classificationName eq 'MEDICATION' and inventoryNo eq '27417' and contains(inventoryDescription, '27417')

$orderby

The $orderby system query option allows clients to request resources in either ascending using asc or descending orders using desc. If asc or desc values are not specified, then resources are displayed in ascending order.

Property name should be specified in lowerCamelCase.

Now, Envi API supports sorting by only one field at a time.

Request Example

https://<HOSTNAME>/odata/Inventory?$orderby inventoryNo

(for example, <HOSTNAME> = api-demo.envi.net)

This sample request sorts target records set by the value of the inventoryNo property in ascending order.

Since the $top option is not specified, only the first 20 records are included. Except for the $top and $skip options, @odata.nextLink also includes the $orderby in the response.

Response Example

{
    "@odata.context": "https://api-demo.envi.net/odata/$metadata#Inventory",
    "@odata.count": 92,
    "value": [
    {
    ....
    "inventoryNo": "#1011",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    {
    ....
    "inventoryNo": "#1025",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    {
    ....
    "inventoryNo": "#1523",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    ....
    {....}
    ],
    "@odata.nextLink": "https://api-demo.envi.net/odata/Inventory?$orderby=inventoryNo&$top=20&$skip=20"
    }

Request Example

https://<HOSTNAME>/odata/Inventory?$orderby inventoryNo desc

(for example, <HOSTNAME> = api-demo.envi.net)

This sample request sorts target records set by the value of the inventoryNo property in descending order.

Since the $top option is not specified, only the first 20 records are included. Except for the $top and $skip options, @odata.nextLink also includes the $orderby in the response.

Response Example

{
    "@odata.context": "https://api-demo.envi.net/odata/$metadata#Inventory",
    "@odata.count": 92,
    "value": [
    {
    ....
    "inventoryNo": "#13975",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    {
    ....
    "inventoryNo": "#12579",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    {
    ....
    "inventoryNo": "#10256",
    "organizationId": "05e36af1-0676-4216-aa3f-aa1ba787aaec"
    ....
    },
    ....
    {....}
    ],
    "@odata.nextLink": "https://api-demo.envi.net/odata/Inventory?$orderby=inventoryNo%20desc&$top=20&$skip=20"
    }

$format

The $format system query option allows requesting a response in a particular format. When you don’t have access, you can request headers for the standard content-type and odata.metada level specifications. The $format takes precedence over standard content-type negotiation.

You can find examples of how to use the $format in the Metadata section.