Having troubles successfully reading table data in Portals when there are many to many relationship tables involved. When I try to GET data from the lowest level table, it seems it can't follow the permissions "up" several levels to the Contacts table:
1. Fetch XML works perfectly based on logged in user so I know I have the table permissions set correctly. In fact everything else (Forms, Lists etc.) works as it should.
2. I have Global permissions on all of the tables and the Web API GET call works as expected for me.
3. When I give Global permissions to other users for the lowest level table, WEB API works as expected.
4. Web API calls work as expected for other tables when there are no MtoM relationships. So straight from Contacts to data table relationships.
5. I added Site Settings for all of the upper tables involved and even added * for the fields after trying a few columns.
{"error":{"code":"9004010D","message":"Common Data Service error occurred.","cdscode":"0x0","innererror":{"code":"0x0","message":"Could not find a property named 'imtx_entitypermission1' on type 'Microsoft.Dynamics.CRM.imtx_trackpermission'."}}}This is one of the errors when I simplified the call. imtx_trackpermission is the lowest MtoM table and imtx_entitypermission is the upper MtoM table.
Hopefully I'm missing something simple. Do I have to explicitly deal with the intersect tables?
