Retrieve xml childnode using Odata in dynamics CRM

Question

I've a problem when i try to pass a childnode attribute as a parameter using Odata in dynamics crm 2015!

for example: when i pass a parentnode it works fine!

but when i pass a child node it does not work : https://ServerURL/XRMServices/2011/OrganizationData.svc/InvoiceSet?$select=Name,InvoiceNumber,TotalAmount,TransactionCurrencyId&$filter=CustomerId/Name eq 'AttributeValue'

i also tried the "$expand" function but it doesn't work! https://ServerURL/XRMServices/2011/OrganizationData.svc/InvoiceSet?$expand=Account_Invoice&$filter=Account/Name eq 'AttributeValue'

Your help will be greatly appreciated

See this answer for a tool that will solve your problem http://stackoverflow.com/a/36937298/38425 — Polshgiant, May 02 '16 at 14:10

score 0 · Accepted Answer · answered May 03 '16 at 09:07

Did you try using the OData Query designer?

You could build the query using the UI to make sure it works without wasting time messing with the OData query uri.

Also, please do not use the ServerUrl (assuming you are using .serverUrl()) on client side, always use the clientUrl() property. CRM might be deployed on a different machine name / url than the Url exposed via IIS.

Retrieve xml childnode using Odata in dynamics CRM

1 Answers1