Announcements
No record found.
How to get expand fields data in webapi query ... can anyone share in query i have expand = st_account_contact_accountid(select = accountnumber).How to get this relationship accountnumber
*This post is locked for comments
Hi,
Try to use the expand as shown below.
$expand=st_account_contact_accountid($select=accountnumber)
See the link below for more details.
https://community.dynamics.com/crm/b/joegilldynamicscrm/archive/2016/03/23/web-api-querying-with-expand
Hope this helps.
Hi nithya gopinath,
i have expand in between query so for comes to expand fileds data we need to convert it to fetchxml or we need to convert entire query into fetchxml?
Convert the entire query to fetch xml.
Hi!I think you should try CRM Restbuilder solution, it will help you to create any query you want.Try to use this article:github.com/.../releasesHope it helpsPlease mark it As Answered or Verified if it did help you.ThanksVladhttp://dynamicalabs.com/
Scenario 1:-
I got solution for expand query. No need to convert into fetchxml. when we use results[i].[st_account_contact_accountid@odata.nextLink]. we will get results in the form of query for particular to that expand fields then normally we can go with webapi retrieve and we will get results.
Scenario 2:-
results[i].[st_account_contact_accountid][fieldsname] it will return fields data.
Scenario 3:-
If want we can convert all the query into fetchxml.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
ScottDurow 2
