Odata Query

(0) Share

Report

Posted on by Community Member

Hi All,

I'm trying to construct an OData query to retrieve data from Invoice entity. I can retrieve all the header records from Invoice However when I'm trying to query record from the related customer it's throwing me an error

here is a sample of my query

dynamics.com/api/data/v8.2/invoices(1A0D1E72-2C87-E711-814D-9CDC71557F61)?$select=Name,invoice_customer_accounts.name&$expand=invoice_customer_accounts

I need 2 thing from this query

1) all the related parent entity values.

2) all the related child entity values.(eg= line items)

Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (4)

Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Ankur,

I had a similar issue, which i had to verify the OData Metadata.

For the relationship you require, change the invoice_customer_accounts to customerid_account. I also noted the "Name" property needs to be in lower case, due to the schema name.

Try the following:

dynamics.com/api/data/v8.2/invoices(1A0D1E72-2C87-E711-814D-9CDC71557F61)?$select=name&$expand=customerid_account

Cheers!

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi Ankur,

Here is the rules to use expand -

http://[Organization URI]/api/data/v8.2/invoices(65f77a42-5f0e-e611-80e0-00155da84c03)?$select=invoicename,invoicefield1,invoicefield2&$expand=customerlookupid($select=customerfiledname1,customerfiledname2,customerfiledname3)

So the rule is you need to replace only lookup id of customer as per your lookup name.

&$expand = customerid

For more information please refer -

https://msdn.microsoft.com/en-us/library/mt770366.aspx

Go to section 2 the point 2.

Sample contact retrieve -

http://[Organization URI]/api/data/v8.2/accounts(65f77a42-5f0e-e611-80e0-00155da84c03)?$select=name,&$expand=primarycontactid($select=fullname,jobtitle,annualincome)

Hope this helps to build the query. You should use always logical name.

Was this reply helpful? Yes No
Verified answer

Mahendar Pal 45,095 on at

Like (0)

Report
Copy link

Link copied!

In addition to that , I will suggest you to write your query using Rest builder, which will help, using expend you can get child record with primary entity.

you can also refer my samples here: himbap.com/blog

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks for your answers my correct query looks something like this:

/api/data/v8.2/invoices(1A0D1E72-2C87-E711-814D-9CDC71557F61)?$select=name,invoicenumber,datedelivered,duedate,new_dbms_qbpaid_amount,billto_line1&$expand=customerid_account($select=name)

Was this reply helpful? Yes No