Microsoft Dynamics 365 | Integration, Dataverse...

FetchXml not working for some entities

(0) Share

Report

Posted on by Community Member

Using fetchXml the query is not working for few entities.

We are using the following URL to get the data.

xxxxxxxx.crm.dynamics.com/.../optionsets?fetchXml=<fetch><entity name="optionset"><all-attributes/></entity></fetch>

It gives the error:

{"error":{"code":"0x80040800","message":"The 'RetrieveMultiple' method does not support entities of type 'optionset'. MessageProcessorCache returned MessageProcessor.Empty. "}}

We are using the above URL as a get query from Java program.

All responses (3)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: FetchXml not working for some entities

Hi DBSync,

Yes, some of entities don't support RetrieveMultiple/Fetch XML. Here is a supported list of V9:

docs.microsoft.com/.../microsoft.xrm.sdk.iorganizationservice.retrievemultiple
Suggested answer

Bipin D365 28,961 Moderator on at

Like (0)

Report

RE: FetchXml not working for some entities

Hi,

Are you trying to fetch optionset integer value and Text value ?

If Yes, then check out below docs link to know the correct query which will be used to retrieve attribute defintion.

docs.microsoft.com/.../query-metadata-web-api

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/
Guido Preite 54,077 Moderator on at

Like (0)

Report

RE: FetchXml not working for some entities

the error message is clear, if you explain what you are trying to accomplish maybe there is an alternative way instead using fetchxml against that entity