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 0

Like

1 comments
Best reply

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

Show all comments