Forum Discussion

bastiaaf's avatar
bastiaaf
Frequent Visitor
7 years ago

Custom data connector - relationships

I'm working on a Custom data connector which is retrieving data - via REST API's - from an HR Cloud Platform. While all is working well, and with the (Personal) gateway I'm even able to refresh th...
bastiaaf's avatar
bastiaaf
Frequent Visitor
7 years ago

Anonymous, I did, but either I don't get the example or it's not meant for what I want to do...

Currently this is the result:


With this piece of code:

        #"CompanyLocation" = Table.NestedJoin(#"Companies",{"ID"},OTGConnector.GetLocations(),{"Company.Id"},"CompanyLocations",JoinKind.LeftOuter),
        #"CompanyLocationExpanded" = Table.ExpandTableColumn(#"CompanyLocation","CompanyLocations", {"Company.Id"})


So <Companies> is extended with the "Company.Id" attribute of <Locations>.

However what I want to achieve is the actual relationship in the model:

 

Currently, I have to explain my users to go to a menu-item and "autodetect" the relationships, which seems to be hard for them.
Would be great if I can simply code what the relationship should be...