Answered

Table permissions for using GET with Web API

Like (0) Share

Report

Posted on 19 Nov 2021 12:27:51 by Community Power Pla...

I'm using the newly implemented query data (GET) function in the Portal Web API. It works perfectly on tables with global access type table permissions, but when I try with the parent access type I get an error:

"code":"90040120","message":"You don’t have permission to read the X table.","type":"EntityPermissionReadIsMissing"

I verified that my user has access to this table through fetching the same data with FETCH XML and Liquid.
Is this a bug, or is there something I'm missing?

I have the same question (2)

All responses (4)

Answers (1)

Verified answer

Christian Leverenz 1,214 on 19 Nov 2021 at 16:06:26

Like (1)

Report

Re: Table permissions for using GET with Web API

Hi @Anonymous ,
did not use that feature yet but i could imagine, that you have to add the table holding the (parent)relationship to the web api enabled stuff as well.
Not sure butthis is what i would do 🙂
Have fun,
Christian

Was this reply helpful? Yes No
Community Power Pla... on 22 Nov 2021 at 11:48:57

Like (1)

Report

Re: Table permissions for using GET with Web API

Hi,
thank you for the suggestion!
I had the webapi site setting enabled for the table I was requesting, but when I enabled it for the relationship-table as well it worked!

Was this reply helpful? Yes No
Community Power Pla... on 22 Nov 2021 at 13:41:41

Like (0)

Report

Re: Table permissions for using GET with Web API

Sorry, I was a bit too quick to mark this as solved..
I've encountered a new error when using the request now:

{"error":{"code":"9004010D","message":"Common Data Service error occurred.","cdscode":"0x0","innererror":{"code":"0x0","message":"Could not find a property named 'access_controller_contact' on type 'Microsoft.Dynamics.CRM.access_controller'."}}}

I've tried enabling the webapi setting for this many-to-many relationship as well, without any luck. Any other suggestions?

Was this reply helpful? Yes No
Christian Leverenz 1,214 on 22 Nov 2021 at 16:04:49

Like (0)

Report

Re: Table permissions for using GET with Web API

@Anonymous
hm, when i see this kind of message, its usually true. Are you sure, that the right connecting entity was stated in the request? So, i am not that deep in that but is access_controller_contact really the name of a (connecting)table or is this a kind of message from the authorization controller trying to connect contact scoped tablepermissions to something?
I sometimes had also issues, when too many tablepermissions were applied to a table, becausae it exceeded somehow a limit of linked-entities as the fetch is extended by applying ~~entity~~table permissions.
So, may be try to reduce the tablepermissions just for a test when there are many tablepermissions or the requested tables.
Have fun,
Christian

Was this reply helpful? Yes No

Join the conversation

Community site session details

Table permissions for using GET with Web API

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Chiara Carbone – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Leaderboard > Power Pages

Featured topics

Product updates

Community site session details

Table permissions for using GET with Web API

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Chiara Carbone – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Pages

Featured topics

Product updates