agur's avatar
agur
Icon for Advocate I rankAdvocate I
8 years ago
Status:
Accepted

Select query in odata v4 is ignored

When using $select in the query string for an OData v4 service it is ignored. For example: = OData.Feed("https://<org>.api.crm4.dynamics.com/api/data/v8.2/opportunities?$select=name,actualrevenue")...
APIS and Embedding
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello agur,

For OData V4 endpoints, we currently do not support querying directly via OData URLs. We are investigating support for this, but it involves significant changes to our OData connector, and we do not have an ETA at this time. For now, the solution is to query using the Query Editor or M script. The M script in this case would be:

 

let Source = OData.Feed("https://graph.microsoft.com/v1.0"),
    Groups = Source{[Name = "groups"]}[Data],
    Selected = Table.SelectColumns(Groups, "id")
in
    Selected

Completed Ideas