Other property values may also be included. In this example, accountid is the primary key. The primary key property is always returned so you don't need to include it in your $select. OData-Version: "/api/data/v9.2/$metadata#accounts(name,revenue)", Request: GET /api/data/v9.2/accounts?$select=name,revenue&$top=1 The following example requests the name and revenue properties from one row of the accounts EntitySet resource: If you don't include a $select query option, all properties are returned. In OData, every column is represented as a property. Use the $select query option to choose which columns to return with your query. Only select the columns with data that you need. When you query data, it's important to limit the amount of data returned to optimize performance. More information: Use Web API functions Select columns With parameter aliases: GET [Organization ne can also use parameter aliases when using functions. Without parameter aliases: GET /api/data/v9.2/accounts?$select=name,revenue If the alias isn't assigned a value, it's assumed to be null. Parameter aliases allow you to use the same value multiple times in a request. You can use parameter aliases for $filter and $orderby query options, but not inside the $expand option. The Dataverse Web API doesn't support these OData query options: $skip, $search, $format. Separate each option after the first with an ampersand (&). Separate query options from the resource path with a question mark (?). You can apply multiple options to a query. Request a count of the matching resources included with the resources in the response. Don't use $top when you retrieve pages of data. Specify the number of items in the queried collection to be included in the result. Specify the related resources to be included in line with retrieved resources. Request a specific set of properties for each entity or complex type. The following table describes the OData query options the Dataverse Web API supports.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |