Extracting specific data from json using jquery

Question

From the following json snippet:

cbfunc22({
  query: {
    count: 2,
      created: "2012-06-18T11:18:15Z",
      lang: "en-US",
      results: {
        tbody: [{
            tr: [{
                class: "day",
                td: [{
                    class: "dayname",
                    p: "Monday"
                  },
                  {
                    class: "weather",
                    p: "Sunny Intervals"
                  },

I can extract Monday using jQuery as follows:

data.query.results.tbody[0].tr[0].td[0].p

How do I extract Sunny Intervals ?

data.query.results.tbody[0].tr[0].td[1].p jsfiddle.net/joycse06/RYdvs — Prasenjit Kumar Nag
– Prasenjit Kumar Nag, Commented Jun 18, 2012 at 11:25
That's not JSON. (Given the function syntax at the beginning is it perhaps the return of a jsonp call?). You need to be careful about object literals that have unquoted property names if you're going to include names ("class") that are JS reserved words. — nnnnnn
– nnnnnn, Commented Jun 18, 2012 at 11:34

Rab Khan · Accepted Answer · 2012-06-18 11:30:00Z

2

data.query.results.tbody[0].tr[0].td[1].p

answered Jun 18, 2012 at 11:30

Rab Khan

35.7k4 gold badges52 silver badges66 bronze badges

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

Comments

Arvind Bhardwaj · Accepted Answer · 2012-06-18 11:25:52Z

1

$('tbody > tr > td > p:nth-child(2)')

answered Jun 18, 2012 at 11:25

Arvind Bhardwaj

5,3215 gold badges38 silver badges50 bronze badges

Comments

Cranio · Accepted Answer · 2012-06-18 11:28:53Z

Just use:

data.query.results.tbody[0].tr[0].td[1].p

If you indent your code correctly the solution is more apparent:

cbfunc22(
{
    query: {
        count: 2,
        created: "2012-06-18T11:18:15Z",
        lang: "en-US",
        results: {
            tbody: [
                    {
                        tr: [
                                {
                                    class: "day",
                                    td: [
                                         {
                                               class: "dayname",
                                           p: "Monday"
                                         },
                                         {
                                           class: "weather",
                                           p: "Sunny Intervals"
                                         },

nnnnnn · Accepted Answer · 2012-06-18 11:29:02Z

0

td is an array, so index 0 gives the first element, index 1 gives the second:

data.query.results.tbody[0].tr[0].td[1].p

and so forth...

answered Jun 18, 2012 at 11:29

nnnnnn

150k30 gold badges210 silver badges247 bronze badges

Comments

Bhavesh G · Accepted Answer · 2012-06-18 11:35:30Z

0

td[0] is for Monday so td[1] is for Sunny Intervals and so on

so Sunny Intervals can be extracted by,

data.query.results.tbody[0].tr[0].td[1].p

answered Jun 18, 2012 at 11:35

Bhavesh G

3,0285 gold badges47 silver badges69 bronze badges

Collectives™ on Stack Overflow

Extracting specific data from json using jquery

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Related