Remove first element of JSON object array

Question

I'm struggling to find a way to cut down this JSON array so I can use the values remaining. Below is what's returned to me from the API I'm fetching and I'm looking to remove the excess so I just have an array with the LGA results. Really unsure where to even start.

{
  "query": {
    "offence": "Dangerous Operation of a Vehicle",
    "area": "",
    "age": "",
    "year": "",
    "gender": ""
  },
  "result": [
    {
      "LGA": "Aurukun Shire Council",
      "total": 156,
      "lat": -13.354875,
      "lng": 141.729058
    },
    {
      "LGA": "Balonne Shire Council",
      "total": 99,
      "lat": -28.464607,
      "lng": 148.189292
    },
    {
      "LGA": "Yarrabah Shire Council",
      "total": 28,
      "lat": -16.910135,
      "lng": 145.868659
    }
  ]
}

Please provive a really question => stackoverflow.com/help/how-to-ask — dungmidside
– dungmidside, Commented Jun 1, 2019 at 15:41
Please remove the extra data and only keep the data required to clarify your question. — Vikash Pathak
– Vikash Pathak, Commented Jun 1, 2019 at 19:24

JackOfAshes - Mohit Gawande · Accepted Answer · 2019-06-01 15:29:36Z

1

You can try:

response.data.result = response.data.result.slice(1)

answered Jun 1, 2019 at 15:29

JackOfAshes - Mohit Gawande

5563 silver badges10 bronze badges

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

Comments

TeWu · Accepted Answer · 2019-06-01 19:56:02Z

1

You can use Array.prototype.map function to transform your result:

const response = getYourJsonFromAPI()
response.result.map(result => result.LGA)

which returns:

["Aurukun Shire Council", "Balonne Shire Council", "Yarrabah Shire Council"]

answered Jun 1, 2019 at 19:56

TeWu

6,7142 gold badges25 silver badges37 bronze badges

Comments

Janiis · Accepted Answer · 2019-06-01 15:27:54Z

0

I'm not sure how you get the response from API, but you can try:

console.log(response.data.result);

answered Jun 1, 2019 at 15:27

Janiis

1,5961 gold badge14 silver badges22 bronze badges

Comments

alencarfff · Accepted Answer · 2019-06-01 16:04:40Z

0

for example, if you want only LGA values, you could use something like that:

let parsedJson = JSON.parse(json);                //parse json to object
let onlyLGAValues = {};                           //create a new dictionary

parsedJson.result.forEach(function(key, index){   //for each result
    onlyLGAValues[index] = key.LGA;               //push the LGA value in the new dictionary
}); 

console.log(onlyLGAValues);

expected output:

{0: "Aurukun Shire Council", 1: "Balonne Shire Council", ... 77: "Yarrabah Shire Council"}

answered Jun 1, 2019 at 16:04

alencarfff

11 bronze badge

Comments

Neil · Accepted Answer · 2019-06-01 19:26:57Z

0

If I am reading your question correctly, you want to get a string array containing the LGA properties:

const data = {
  query: {
    offence: "Dangerous Operation of a Vehicle",
    area: "",
    age: "",
    year: "",
    gender: ""
  },
  result: [{}, {}] // your current large array
};

const lgaArray = data.result.map(({ LGA }) => ({ LGA }));

console.table(lgaArray);

A screenshot to give a visual aid:

edited Jun 1, 2019 at 19:26

answered Jun 1, 2019 at 19:20

Neil

9662 gold badges12 silver badges33 bronze badges

Collectives™ on Stack Overflow

Remove first element of JSON object array

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related