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

Copper Contributor

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?

1 Reply
Does anyone know the answer to this one?