Microsoft Dynamics 365 | Integration, Dataverse...

Error code:"90040120" - "You don’t have permission to read the OptionSetMetadataBase table"

(0) Share

Report

Posted on by Orlando Batista

120

We are looking the way to get the list of value for an Option Set from Dynamics 365 and we are trying to extract this value from this URL:

https://{client}.powerappsportals.com/_api/GlobalOptionSetDefinitions(Name='cr754_color')

And we are receiving the following error:

{"error":{"code":"90040120","message":"You don’t have permission to read the OptionSetMetadataBase table."}}


We have already setup this Site Settings in our Portal environment:

WebAPI/enableReadOperationPreview = true

Webapi/OptionSetMetadataBase/enabled = true

Webapi/OptionSetMetadataBase/fields = *

Autoservicio-Site-settings.png_2D00_640x480.png_2D00_640x480.png_2D00_640x480.png_2D00_640x480.png_2D00_640x480.png_2D00_640x480.png_2D00_640x480.png

Now we are trying to create a new permission for the table OptionSetMetadaBase, but this table is not in the list.

How can we accomplish without having access to this table? Or is there any way we can select this table from the list?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hi Orlando Batista,

Your URL is wrong. It should be https://[organization URI]/api/data/v9.0/GlobalOptionSetDefinitions.

Please refer to this doc: https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/optionsetmetadatabase?view=dynamics-ce-odata-9

My test:

URL: https://xxxx.crm.dynamics.com/.../GlobalOptionSetDefinitions(Name='cr2f9_salesstagecode')

Result:

Was this reply helpful? Yes No
Orlando Batista 120 on at

Like (0)

Report

Thanks Steve, for your response. One important thing I forgot to mention is that I need to access this list from Dynamics 365 Portals API. As you saw in my post we have already setup almost everything for this to work from this environment. All we are missing the security permission to used this table from Dynamics 365 Portals.

Was this reply helpful? Yes No