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.

I have the same question (0)

All responses (3)

Answers (0)

Guido Preite 54,086 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

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/

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No