Does OData expand work with Mendix OData feeds?
0
Hi I have an OData feed which I am consuming in PBI. In order to try and cut down on the load / query times in the refresh I am trying to do my filtering on the OData feed directly. I am however experiencing some issues with using expand. I have a Table CaseManagement which is associated to the table Clinician, when I do CaseManagement$select=ID,CaseIdentifier,CaseManagement_Clinician it correctly shows me the two column and the associated Record for Clinician. Instead of expanding the record (which queries the source for every line in PBI) I want to only see the Clinician.Name field in my table. The issue that arises is that adding the expand query does not fail but it also does not return anything, even if I also add a select. I am using the recommended settings within Mendix Does anyone have any experience in achieving what I am trying to do and can help me understand what I am doing wrong or if it is a limitation? Thanks Grant
asked
Grant Finlay
2 answers
1
Yes, expand is supported. Here's and example using the rest client in visual studio code.
The url used is as follows:
http://query-demo:8080/odata/shopapi/v1/Customers?
$top=10&
$skip=0&
$count=true&
$orderby=CustomerId&
$select=CustomerId,FirstName,LastName,EmailAddress,DateOfBirth&
$expand=BillingAddress($select=AddressId,Streetname),DeliveryAddress($select=AddressId,Streetname)
answered
Andrej Koelewijn
1
I was able to resolve this issue by instead of using Expand in the OData URL string including the association in the Select string and enclosing everything in the Table.ExpandRecordColumn function.
answered
Grant Finlay