DELETE call deletes all the entries.

[injulkarnilesh]

I am providing json file as a db source containing post elements as in : https://gist.github.com/injulkarnilesh/4cfd42501bfd5c13885f
Rest of the calls work fine
GET /posts/
GET /posts/3
POST /posts/
These calls work as expected.

But on
DELETE /posts/3
Response says
Response does not contain any data.
with status 204.
and json data in the file gets emptied to
{
"posts": []
}

Shouldn't it delete only the mentioned post rather than all the posts?

[typicode]

Actually, JSON-Server deletes dependent resources. For example, if you delete a post, it will delete comments that are associated with the post.

To do so, JSON-Server will look at the database and remove entries that references other entries that don't exist (based on the parentId property).

This is why all your posts got deleted. They are referencing users that don't exist.

To fix it, you can either remove the ̀userId` property or add an users table like this:

{
  "users": [
    { "id": 1 },
    { "id": 2 }
  ],
  "posts": {
    // ...
  }
}

Tell me if it solvers your problem?

[injulkarnilesh]

Worked like a charm.
Thanks a lot.

[aboudard]

Hello, just a quick note for anyone having such issues :
If you ever have an Entity post that uses an id field because json-server works by default with this name, AND you also have another postId field (reflecting you own future database), you will encounter the same "delete all" behavior. All you need to do is align the values of these 2 fields.

{
    "id": 1,
    "postId": "PI524"
}

will be deleted every time, instead, align values :

{
    "id": "PI524",
    "postId": "PI524"
}

[Mahmoudibrahim03]

Hello, just a quick note for anyone having such issues : If you ever have an Entity post that uses an id field because json-server works by default with this name, AND you also have another postId field (reflecting you own future database), you will encounter the same "delete all" behavior. All you need to do is align the values of these 2 fields.

{
    "id": 1,
    "postId": "PI524"
}

will be deleted every time, instead, align values :

{
    "id": "PI524",
    "postId": "PI524"
}

what if I need to relate items like (questions - answers ) with form ID and each one should have its own id also @aboudard