News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Cannot expand 'cus...

Microsoft Dynamics CRM (Archived)

Cannot expand 'customerid' field on quote with Web API - V9

(1) Share

Report

Report

Posted on by Community Member Microsoft Employee

Using the following with a GET request I can retrieve a number of fields from the quote, including the price-list lookup:

https://myorg.crm4.dynamics.com/api/data/v9.1/quotes("ID")?$select="quoteid,quotenumber,name,revisionnumber,description,paymenttermscode,billto_line1,billto_line2,billto_line3,billto_city,billto_postalcode,billto_stateorprovince,billto_country,pricelevelid&$expand=pricelevelid($select=name)"

however the below does not work:

https://myorg.crm4.dynamics.com/api/data/v9.1/quotes("ID")?$select="quoteid,quotenumber,name,revisionnumber,description,paymenttermscode,billto_line1,billto_line2,billto_line3,billto_city,billto_postalcode,billto_stateorprovince,billto_country,pricelevelid&$expand=customerid($select=name)"

With the following error:

"Could not find a property named 'customerid' on type 'Microsoft.Dynamics.CRM.quote'

Can anyone point me in the right direction?

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

RaviKashyap 55,410 on at

Like (0)

Report

RE: Cannot expand 'customerid' field on quote with Web API - V9

You can refer this thread as well for more details-

community.dynamics.com/.../304254
Verified answer

RaviKashyap 55,410 on at

Like (2)

Report

RE: Cannot expand 'customerid' field on quote with Web API - V9

Hi,

CustomerId is a customer entity which can hold either account or contact. So, Instead of customerid you need to use the schema name which is customerid_account if you want to reteieve the customer which is account-

Refer this-

myonlineorg.crm6.dynamics.com/.../quotes(0F89DCAF-2D9D-E811-A968-000D3AE0562F)$select=quoteid,quotenumber,name,revisionnumber,description,paymenttermscode,billto_line1,billto_line2,billto_line3,billto_city,billto_postalcode,billto_stateorprovince,billto_country,pricelevelid&$expand=customerid_account($select=name)

Hope this helps.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans