I have a datamodel in Dataverse with two main tables
There is a many-to-many relationship between these two tables, and this is done (behind the scenes) by creating a relationship table. In my case it is called "gp_Document_gp_Role_gp_Role" (in my defense, naming is done automatically 😉).
I would like to list all entries in the relationship table for a specific Document (and also add rows to the table at a later point in time)
How do I do that?
Using the Dataverse "List rows" Connector I can find both the Documents table and the Roles table - but not the relationship table.
I think I can access it from the Web API like
https://myorgid.crm4.dynamics.com/api/data/v9.1/gp_documents(document_guid)/gp_Document_gp_Role_gp_Role
But it will become a virtual nightmare to configure access with app registrations in Azure, client secrets etc and have it deployed through multiple environments.
Is there a better way to do this?
Thanks
/Jesper
Copenhagen
