Forum Discussion

e5_pnolan's avatar
e5_pnolan
Copper Contributor
Aug 18, 2024

How does Copilot identify relationships\foreign keys across relational data?

I'm creating a connector with a custom API Graph. As the API Graph only supports a flat structure of data, how does Copilot identify relationships\foreign keys across relational data? For example, how do I expose customer details with associated addresses. This is a one-to-many relationship. I assume I would need a Customer Connector\API and a customerAddresses Connector\API. Would copilot automatically work out the relational data by seeing the customerId in the customer address record?

Resources