json-server icon indicating copy to clipboard operation
json-server copied to clipboard

Implicit foreign key mapping not working

Open Tzal3x opened this issue 1 year ago • 1 comments

It should be possible to be able to find the entries of another entity by using the foreign key.

For example let's say we have two entities: users and companies.

Each users entry has a companyId.

The json server should be able to fetch all the users of a company.

i.e.

Given the following db.json :

{
  "users": [
    { "id": "23", "firstName": "Bill", "age": 20, "companyId": "1" },
    { "id": "40", "firstName": "Alex", "age": 40, "companyId": "2" },
    { "id": "41", "firstName": "Nick", "age": 40, "companyId": "2" }
  ],
  "companies": [
    { "id": "1", "name": "Apple", "description": "iphone" },
    { "id": "2", "name": "Google", "description": "search" }
  ]
}

Running the server with npx json-server db.json

Expected behavior

curl http://localhost:3000/companies/2/users
[
    { "id": "40", "firstName": "Alex", "age": 40, "companyId": "2" },
    { "id": "41", "firstName": "Nick", "age": 40, "companyId": "2" }
]

Actual behavior

$ curl http://localhost:3000/companies/2/users
Not Found

Tzal3x avatar Jul 04 '24 10:07 Tzal3x