Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) How to get expand fiel...

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

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (5)

Answers (4)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: 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

Hi,

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: 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

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/.../releases

Hope it helps

Please mark it As Answered or Verified if it did help you.

Thanks

Vlad
http://dynamicalabs.com/
Verified answer

Nithya Gopinath 17,074 on at

Like (0)

Report

RE: 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

Convert the entire query to fetch xml.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: 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

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?
Verified answer

Nithya Gopinath 17,074 on at

Like (1)

Report
RE: 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

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.