Hi all,
I have created a Power Page where calls are done to the web api. I have the following setup:
Contact is related to account
Account has a company
Product has a company
Now, i have a table permission for the 'Customer' web role for both the account and the company, and both are enabled in the api using site settings and both are returning the expected data.
Then, I wanted to include products on the portal. However, I cant get it to work as expected. I added a child permission to the company permission for the products table. I selected the table, and the relationship came popping up. When trying it in the web api, I got the following error:
{"error":{"code":"9004010D","message":"Common Data Service error occurred.","cdscode":"0x80040216","innererror":{"code":"0x80040216","message":"entityRelationshipRole for given navigation property not found"}}}
The relationship from products to company is many to one:
How can I best fix this (without just filtering on the companyid, since products from other companies should not be visible)
Thank you in advance!
