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

unexpected output when using _embed with persons table

Open timstallinger opened this issue 7 months ago • 0 comments

Version beta-3:

in db.json:

{
  "persons": [
    { "id": 0, "name": "Tim", "lastName": "S", "role": "developer" }
  ],
  "feedbacks": [
    { "id": 0, "personId": 0, "text": "Great dev"}
  ]
}

when requesting http://localhost:3000/feedbacks?_embed=person, I get

[
  {
    "id": 0,
    "personId": 0,
    "text": "Great dev"
  }
]

notice, how the person has not been embedded. However when I change the table name to something else like employees

{
  "employees": [
    { "id": 0, "name": "Tim", "lastName": "S", "role": "developer" }
  ],
  "feedbacks": [
    { "id": 0, "employeeId": 0, "text": "Great dev"}
  ]
}

I get the full expected result from http://localhost:3000/feedbacks?_embed=employee:

[
  {
    "id": 0,
    "employeeId": 0,
    "text": "Great dev",
    "employee": {
      "id": 0,
      "name": "Tim",
      "lastName": "S",
      "role": "developer"
    }
  }
]

Is persons a reserved table name or am I doing something wrong?

timstallinger avatar Mar 19 '25 14:03 timstallinger