Hi,
I need to get a list of accounts with their accountAddress as a list ,
and I Have this NavigationProperty in account Entity
how I can wite the query to join account and account address using "AccountAddressCollectionByAccount" NavigationProperty
Thanks
Like
Hi Moheman,
OData cannot perform such an operation in one action if calling /0/odata/Account endpoint. You can retrieve data from related entities (that are specified in lookup columns), but not from details. Or you need to perform OData request to AccountAddress collection and retrieve data on the related accounts there in the following manner:
https://o_drobina.tscrm.com/0/odata/AccountAddress?$expand=Account
Best regards,
Oscar
Hi Moheman,
OData cannot perform such an operation in one action if calling /0/odata/Account endpoint. You can retrieve data from related entities (that are specified in lookup columns), but not from details. Or you need to perform OData request to AccountAddress collection and retrieve data on the related accounts there in the following manner:
https://o_drobina.tscrm.com/0/odata/AccountAddress?$expand=Account
Best regards,
Oscar