How do I access an object in an array from an API hosted by json-server

Question

I'm using json-server for hosting an API in my project.

What json-server gives me is http://localhost:3000/records.

{
    "record": [
        {
            "userID": "2",
            "userFirstName": "Arya",
            "userLastName": "Stark",
            "userMiddleName": "null",
            "roleName": "Admin",
            "roleID": "1"
        },
        {
            "userID": "1",
            "userFirstName": "John",
            "userLastName": "Snow",
            "userMiddleName": "null",
            "roleName": "Moderator",
            "roleID": "1"
        }
    ]
}

I'm using Postman for making GET request to the server.

How do I go into record array and access the object with userID as 2 ?

I tried this way but it's returning an empty object.

Please correct me if I'm wrong:

http://localhost:3000/records/record?userID=2

My actual JSON object file:

{
  "records": {
    "record": [
      {
        "userID": "2",
        "userFirstName": "Arya",
        "userLastName": "Stark",
        "userMiddleName": "null",
        "roleName": "Admin",
        "roleID": "1"
      },
      {
        "userID": "1",
        "userFirstName": "John",
        "userLastName": "Snow",
        "userMiddleName": "null",
        "roleName": "Moderator",
        "roleID": "1"
      }
    ]
  }
}

Have you written any server side code to handle such a request? If you just have a GET "/records" route on the server side then its not going to know what to do when it sees "/records/record?userID=2" — sharkdawg
– sharkdawg, Commented Feb 24, 2018 at 20:37
Okay so I'm not having any server side code. Just hoping if I could do a plain get request. @EndaMolloy — krsna
– krsna, Commented Feb 24, 2018 at 20:38
Unfortunately your server side is not going to magically know what to do. You can either write server side logic to handle the query string if you want to persist with such a route or simply have your /records route which returns the full object and then filter out what you want from there. — sharkdawg
– sharkdawg, Commented Feb 24, 2018 at 20:52

connexo · Accepted Answer · 2018-02-25 08:23:11Z

2

Just so slightly change your JSON structure:

{
  "records": [
    {
      "userID": "2",
      "userFirstName": "Arya",
      "userLastName": "Stark",
      "userMiddleName": "null",
      "roleName": "Admin",
      "roleID": "1"
    },
    {
      "userID": "1",
      "userFirstName": "John",
      "userLastName": "Snow",
      "userMiddleName": "null",
      "roleName": "Moderator",
      "roleID": "1"
    }
  ]
}

Then http://localhost:3000/records?userID=2 returns

[
  {
    "userID": "2",
    "userFirstName": "Arya",
    "userLastName": "Stark",
    "userMiddleName": "null",
    "roleName": "Admin",
    "roleID": "1"
  }
]

Aside from this solving the actual access problem I was also unable to find a solution to filter based on object properties that are part of an array which is stored in a property of your db.json object.

edited Feb 25, 2018 at 8:23

answered Feb 25, 2018 at 8:16

connexo

57.3k15 gold badges112 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

krsna Over a year ago

Yes. Finally I've had my actual json file modified as I couldn't find any resource help online.

Danny Dainton · Accepted Answer · 2018-02-25 07:44:58Z

1

Simple but have you tried just using /records/record/2 the json-server module takes most of the implementation away from the user and this may just work, as it’s designed to be a quick REST API to get people started.

Check out the examples on the documentation page or take a look at the API running here http://jsonplaceholder.typicode.com/ as it’s using the same code.

answered Feb 25, 2018 at 7:44

Danny Dainton

26.3k7 gold badges75 silver badges89 bronze badges

1 Comment

krsna Over a year ago

Unfortunately, I have tried this way as well but it did not work.

Dani Pani danipani · Accepted Answer · 2018-02-24 20:47:55Z

0

You have to change something on your server side to filter request according to the request parameters

Or just use javascript:

data.records.record.filter((user)=>user.userID==2)[0]

answered Feb 24, 2018 at 20:47

Dani Pani danipani

354 bronze badges

Collectives™ on Stack Overflow

How do I access an object in an array from an API hosted by json-server

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related