json group relevant data of multiple arrays

Question

So I'm currently fetching data from an API but the data I'm getting is very weird. For example if I want to get the temperature, humidity and date from the API for 1 specific location I will get something like this:

data: {temp="15",humidity=null,date=null,lat=50,long=5}
data: {temp=null,humidity="7",date=null,lat=50,long=5}
data: {temp=null,humidity=null,date="20190417",lat=50,long=5}

So it seems the API fetches everything individual, but instead of grouping it all together and sending 1 array it sends an array for every piece of information I request. Is it possible to take the relevant data out of each array and put it into 1 for each request I do? I would like to do the grouping with Javascript or JQuery. I know normally you have to post what you tried, but honestly at the moment I'm at a complete loss, just a starting point on how to tackle the problem would be nice.

Expected result

data: {temp="15",humidity="7",date="20190417",lat=50,long=5}

Can you share the code where you are making the request to API and logging the response? — nightgaunt
– nightgaunt, Commented Apr 17, 2019 at 9:35
@nightgaunt no, at the moment not. I only just tested the data through the API in the browser (and above is what I retrieve from my test). I will probably do it through a simple AJAX call. As I said I have no code to show at the moment. I'm just looking for a way to tackle the problem in the first place. — mr deadsven
– mr deadsven, Commented Apr 17, 2019 at 9:40
The reason I asked is because the solution will vary based on whether you make all three requests at once or one after another. If you make the requests one after another, below solutions are the best. Otherwise, you need to update your base result object upon receiving response. — nightgaunt
– nightgaunt, Commented Apr 17, 2019 at 9:43
@nightgaunt Ahh yes I see what you mean, the request will fetch all three at once. but I think I can manage to separate them and use Eddie's code to solve my problem. Thank for the info. — mr deadsven
– mr deadsven, Commented Apr 17, 2019 at 9:46

ponury-kostek · Accepted Answer · 2019-04-17 09:52:21Z

2

Use Object.entries to get entries from object, filter out null values, recreate object from entries (Object.fromEntries), merge all objects together (Object.assign)

const result = data.reduce((target_object, curr) => {
    const entries = Object.entries(curr);
    const filtered_entries = entries.filter(([key, value]) => value !== null);
    const filtered_object = Object.fromEntries(filtered_entries);
    Object.assign(target_object, filtered_object)
}, {});

const data = [{temp: "15", humidity: null, date: null, lat: 50, long: 5}, {temp: null, humidity: "7", date: null, lat: 50, long: 5}, {temp: null, humidity: null, date: "20190417", lat: 50, long: 5}];
const result = data.reduce((prev, curr) => Object.assign(prev, Object.fromEntries(Object.entries(curr).filter(([key, value]) => value !== null))), {});
console.log(result);

edited Apr 17, 2019 at 9:52

answered Apr 17, 2019 at 9:41

ponury-kostek

8,0835 gold badges27 silver badges33 bronze badges

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

Comments

Eddie · Accepted Answer · 2019-04-17 09:41:20Z

1

You can put the objects in one array and use reduce loop thru the array. Convert each object into an array using Object.keys and loop using forEach

let data1 = {temp:"15",humidity:null,date:null,lat:50,long:5}
let data2 = {temp:null,humidity:"7",date:null,lat:50,long:5}
let data3 = {temp:null,humidity:null,date:"20190417",lat:50,long:5}

let result = [data1, data2, data3].reduce((c, v) => {
  Object.keys(v).forEach(o => c[o] = c[o] || v[o]);
  return c;
}, {});

console.log(result);

answered Apr 17, 2019 at 9:41

Eddie

26.8k6 gold badges39 silver badges59 bronze badges

1 Comment

mr deadsven Over a year ago

Thanks, I did a quick test with the data I retrieved and it worked like a charm!

Collectives™ on Stack Overflow

json group relevant data of multiple arrays

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related