Querying Data

The Querying Data section explains how to retrieve information from ERP.net using the Domain API. All queries use standard OData conventions, with some ERP.net-specific extensions.

OData Basics

ERP.net exposes entities (repositories) through an OData-compliant service. Each entity represents a type of data in the system, such as Customer, Order, or Product.

• Service Root URL: The base URL for all queries. Example: https://testdb.my.erp.net/api/domain/odata/

• Entity Types: Each entity can be queried independently. Common entities include:

• Crm_Sales_Customers

• Crm_Sales_SalesOrders

• General_Products_Products

In This Section

• Query Options
  Explains the URL parameters used for querying data.

• Query Builder
  ERP.net includes a Visual Query Designer to simplify query creation

• Query Tool
  The ERP.net Query Tool allows you to experiment with Domain API requests directly in the browser.

• Filterable References
  Filter by properties of a referenced object.

• Examples
  Useful examples and common tasks.