You can refine query results using system query options, which begin with the $ character. Add system query options to the URL to control the amount and order of data in the response. Custom query parameters lists additional parameters specific to Hybrid Data Pipeline . In addition, topics in this section describe settings to optimize response times when using the $inlineCount system parameter or when paging through result sets.

The following table lists the OData query string options that Hybrid Data Pipeline supports. For detailed information about the system query options, refer to the OData specification.
Table 1. Supported system query options
Option Description Support in Hybrid Data Pipeline
$expand

In addition to retrieving a record or collection, retrieve related records.

At present, supports expanding one level deep.
$filter

An expression or function that must evaluate to true for records that will be included in the response.

Supports all functionality except the isof scalar function.
$inlinecount Include a count of the number of Entries in the response. The count will be calculated after applying any $filter System Query Options present in the URI. See Improving performance when using inlineCount for more information.

Supports all standard functionality.
$orderby Determines the values used to order a collection of records.

Supports all standard functionality.
$count Returns the number of records in a collection, or if the collection has a filter, the number of records that match the filter.

Supports all standard functionality.
$value Gets the raw value of a property.

Supports all standard functionality.
$top Identifies a subset of records to return from a collection. To form this subset, select only the first N items of the set, where N is a positive integer. See Paging through results for more information. Supports all standard functionality.
$skip Identifies a subset of records to return from a collection. Define the subset by seeking N Entries into the Collection and selecting only the remaining Entries (starting with Entry N+1), where N is a positive integer. Supports all standard functionality.