Relation between 2 tables with Data API

Hello everyone,

Today, I would like to share a problem of performance. I have 2 tables :

  • Client : composed of 3 fields (mail, temporary password et building)
  • Building : composed of 3 fields (name, street, city)

Obviously, I dont count the id field from the both table. I use some API request from an external frontend. I would like to retrieve the city of the customer’s building. So, currently, i’m using 2 GET request. Firstly, to pick up the id of the customer’s building, then put it in the second fetch request to get the city.

You are agree with me that it’s not the best way. So I was wondering if it exists a process such as “relationnal table” to do whole this process directly in one GET request ?

Thanks in advance

Hello,

Does anyone have any ideas?

Thanks in advance

This topic was automatically closed after 70 days. New replies are no longer allowed.