Odata: expose many to many relation not possible?

1
Hi all, I thought publishing OData is straightforward, but now I'm stuck. I just want to expose a *-* relation. I found this forum post from 2 years ago where the answer is: it's not possible. Is this still true? Is there a best practice or a workaround for this issue?
asked
4 answers
4

Hi Fabian,

I have filed a ticket for this in April 2017. The answer then was that the request wasa scheduled for a release within 6 months. Have not heard about the change yet, as far as i know it is still not supported.

Work around is as Andrej suggest within the domain model

Kind regards,
Maarten Bongers

 

answered
1

I want to expose my accounts and companies to PowerBI with OData, but OData has its limitations.

OData services have a option to publish many to many associtions as links since 7.21. This link looks like this https://app.mendixcloud.com/odata/app/parties(22799473113563137)/Accounts. 

This is not a table with a account id and party id. We can use these links in Azure if we write custom logic in Azure, but we don't want that, so we are going to stick to the solution in 8618 going to create a account – party entity.

@Mendix I dont like your solution for idea 564 and would like to expose a many to many association as an association table.

https://forum.mendix.com/link/questions/8618

https://forum.mendix.com/link/questions/88818

https://forum.mendix.com/link/questions/95322

Best regards

answered
0

For future reference about this. This behavior is described on this documentation page: OData Representation

 

Mendix Data Type: Reference set (not supported)

 

 

answered
0

Then you must also show this idear: https://forum.mendix.com/link/ideas/564

So at least it seems it is planned.

Regards,

Ronald

 

answered