Grab specific values from json to put in data array

Question

I'm trying to grab certain bits of data out of my JSON response to put in an array. This is my JSON response, and what I am interested in is the "counts" which is hourly, separated by either page "statement" or "logon".

{
   "report":{
      "type":"trended",
      "elements":[
         {
            "id":"page",
            "name":"Page"
         }
      ],
      "reportSuite":{
         "id":"retail",
         "name":"GlobPROD"
      },
      "period":"Wed.  3 Oct. 2018 - Fri.  5 Oct. 2018",
      "metrics":[
         {
            "id":"pageviews"
         }
      ],
      "segments":[
         {
            "id":"s13bb443734ab6a764639ff37",
            "name":"Information"
         }
      ],
      "data":[
         {
            "name":"Wed.  3 Oct. 2018",
            "year":2018,
            "month":10,
            "day":3,
            "hour":0,
            "breakdown":[
               {
                  "name":"CATEGORY:>Statement",
                  "url":"",
                  "counts":[
                     "242"
                  ]
               },
               {
                  "name":"CATEGORY:>Log On",
                  "url":"...CheckId.do",
                  "counts":[
                     "237"
                  ]
               }
            ],
            "breakdownTotal":[
               "2123"
            ]
         },
         {
            "name":"Wed.  3 Oct. 2018 (Hour 1)",
            "year":2018,
            "month":10,
            "day":3,
            "hour":1,
            "breakdown":[
               {
                  "name":"CATEGORY:>Statement",
                  "url":"",
                  "counts":[
                     "152"
                  ]
               },
               {
                  "name":"CATEGORY:>Log On",
                  "url":"",
                  "counts":[
                     "135"
                  ]
               }
            ],
            "breakdownTotal":[
               "1140"
            ]
         }

So what I am after is firstly to be able to split out the hourly data between statement and login, and secondly build an array of the data hour by hour.

logindata: [237, 135]

statementdata: [242, 152]

I've read that I can try and grab values using something a bit like this:

 var t = JSON.parse('{"name": "", "skills": "", "jobtitel": "Entwickler", "res_linkedin": "GwebSearch"}');

But how can I create a little loop to grab all the values I specify like in my example?

From where is 137 ?

Mihai Alexandru-Ionut
– Mihai Alexandru-Ionut

2018-10-08 12:21:30 +00:00
Commented Oct 8, 2018 at 12:21 — Mihai Alexandru-Ionut
– Mihai Alexandru-Ionut, Commented Oct 8, 2018 at 12:21
@MihaiAlexandru-Ionut Sorry, it was 135

Jimmy
– Jimmy

2018-10-08 12:22:40 +00:00
Commented Oct 8, 2018 at 12:22 — Jimmy
– Jimmy, Commented Oct 8, 2018 at 12:22

Nenad Vracar · Accepted Answer · 2018-10-08 12:30:45Z

You could use reduce method with forEach inside and build an object where each CATEGORY is separate property.

const data = {"report":{"type":"trended","elements":[{"id":"page","name":"Page"}],"reportSuite":{"id":"retail","name":"GlobPROD"},"period":"Wed.  3 Oct. 2018 - Fri.  5 Oct. 2018","metrics":[{"id":"pageviews"}],"segments":[{"id":"s13bb443734ab6a764639ff37","name":"Information"}],"data":[{"name":"Wed.  3 Oct. 2018","year":2018,"month":10,"day":3,"hour":0,"breakdown":[{"name":"CATEGORY:>Statement","url":"","counts":["242"]},{"name":"CATEGORY:>Log On","url":"...CheckId.do","counts":["237"]}],"breakdownTotal":["2123"]},{"name":"Wed.  3 Oct. 2018 (Hour 1)","year":2018,"month":10,"day":3,"hour":1,"breakdown":[{"name":"CATEGORY:>Statement","url":"","counts":["152"]},{"name":"CATEGORY:>Log On","url":"","counts":["135"]}],"breakdownTotal":["1140"]}]}}

const result = data.report.data.reduce((r, e) => {
  e.breakdown.forEach(el => {
    let key = el.name.split(':>')[1];
    if(!r[key]) r[key] = []
    r[key].push(...el.counts)
  })
  return r;
}, {})

console.log(result)

Bartios · Accepted Answer · 2018-10-08 12:42:28Z

1

I think (if the json structure is always the same) you could do it like this:

for( let item in json.report.data ){
  for( let subItem in item.breakdown ){
    if( subItem.name === "CATEGORY:>Statement" ){
      //do something with subItem.counts, the statement counts
    } else if( subItem.name === "CATEGORY:>Log On" ){
      //do something with subItem.counts, the logOn counts
    }
  }
}

answered Oct 8, 2018 at 12:42

Bartios

995 bronze badges

Collectives™ on Stack Overflow

Grab specific values from json to put in data array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related