News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Query OData

Microsoft Dynamics CRM (Archived)

Query OData

(0) Share

Report

Report

Posted on by Ricardo Rodrigues d...

690

Good afternoon guys,

I'm trying to get all the Orders where the Primary Account and a specific ID are, however I'm getting the message "attributeName".

1273.Sem-t_ED00_tulo.jpg

This URL I'm using in the browser to see the data it brings me

The query is:

Http: // srvdynamics: 5555 / Learned / XRMServices / 2011 / OrganizationData.svc / SalesOrderSet? $ Select = AccountId, CreatedBy, CustomerId, Name, OrderNumber & $ expand = order_customer_accounts & $ filter = order_customer_accounts / ParentAccountId / eq Id (guid'F054438C- ABD5-E611-80B7-000C2989B1A8 '),

What can it be?

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Nithya Gopinath 17,074 on at

Like (0)

Report
RE: Query OData

Hi,

Can you try the following query?

https://[YourOrganisationRootURL]/XRMServices/2011/OrganizationData.svc/SalesOrderSet$select=AccountId,CreatedBy,CustomerId,Name,OrderNumber&$expand=order_customer_accounts&$filter=order_customer_accounts/ParentAccountId/Id eq guid'F054438C-ABD5-E611-80B7-000C2989B1A8'
Suggested answer

Nadeeja Bomiriya 6,804 on at

Like (0)

Report
RE: Query OData

Hi Ricardo,

Try this.

/SalesOrderSet$select=AccountId,CreatedBy,CustomerId,Name,OrderNumber&$expand=order_customer_accounts&$filter=order_customer_accounts/ParentAccountId/Id eq (guid'F054438C-ABD5-E611-80B7-000C2989B1A8')

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans