How to get value from json object using jquery?

Question

I have the following ajax call and the json feed it returns. how do I get the value of the data object i.e. FRI from the feed using jquery?

$.ajax({
    url: query,
    type: "GET",
    dataType: "json"
    success: function(data) {
        var day = // get data value from json
        $("#Day").val(day);
    }
});    

{
   "name":"workdays",
   "columns":[
      "day"
   ],
   "data":[
      [
         "FRI"
      ]
   ]
}

* update *

What would be the syntax be if the results were returned as jsonp as follows, how can you extract the value 'FRI' :

import({
  "Results":{
    "work_days":{
        "empid":100010918994,
        "day":"FRI"
     }
  }
});

You access it just as you would a normal Javascript object. I'm not too sure I understand what exactly you are asking... data.data? — Lix
– Lix, Commented Dec 7, 2015 at 14:59
it's json. (j)ava(s)cript (o)bject (n)otation. you access the decoded json like you would any other javascript data structure, because json IS javascript. — Marc B
– Marc B, Commented Dec 7, 2015 at 15:02
@MarcB: Saying "json IS javascript" is very misleading. Its syntax looks like a subset of JavaScript, but then some of JavaScript looks like C. So would we say JavaScript IS C? In fact, JSON/JavaScript are even more distinct since JSON is not in any way a programming language. — user1106925
– user1106925, Commented Dec 7, 2015 at 15:07
it may be a subset, but far too many people have the idea that json is magically special and requires special handling. — Marc B
– Marc B, Commented Dec 7, 2015 at 15:10

Arg0n · Accepted Answer · 2015-12-14 09:58:52Z

4

This is just JavaScript, not jQuery.

var data = {
   "name":"workdays",
   "columns":[
      "day"
   ],
   "data":[
      [
         "FRI"
      ]
   ]
}

data.data[0][0]; //FRI

UPDATE

var obj = {
  "Results":{
    "work_days":{
        "empid":100010918994,
        "day":"FRI"
     }
  }
}

obj.Results.work_days.day //FRI

edited Dec 14, 2015 at 9:58

answered Dec 7, 2015 at 15:02

Arg0n

8,4532 gold badges26 silver badges39 bronze badges

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

1 Comment

adam78 Over a year ago

How can you get the same value if the results were returned as jsonp - see updated post.

Ronny Coolen · Accepted Answer · 2015-12-07 15:01:33Z

3

If the latter json is the json you get from the server, you can get the data like this:

var day = data.data[0][0];

This will put the value FRI in the variable day.

EDIT: If you use a recent browser, you can always do console.log(data) and look in your javascript console what is in the variable

answered Dec 7, 2015 at 15:01

Ronny Coolen

1705 bronze badges

Comments

Jay · Accepted Answer · 2015-12-07 15:43:50Z

1

    $.ajax({
    url: query,
    type: "GET",
    dataType: "json"
    success: function(data) {
        var day = data.data[0][0] // get data value from json
        $("#Day").val(day);
    }
});    

{
   "name":"workdays",
   "columns":[
      "day"
   ],
   "data":[
      [
         "FRI"
      ]
   ]
}

edited Dec 7, 2015 at 15:43

answered Dec 7, 2015 at 15:00

Jay

7571 gold badge12 silver badges38 bronze badges

1 Comment

Arg0n Over a year ago

OP is asking how to get 'FRI', not 'day'.

michal pavlik · Accepted Answer · 2015-12-07 15:00:16Z

0

json is javascript object, so you can access to any his property:

data.name
data.columns
data.data

answered Dec 7, 2015 at 15:00

michal pavlik

3485 silver badges20 bronze badges

Comments

Omar Mowafi · Accepted Answer · 2015-12-07 15:01:18Z

0

You don't need jquery data is a javascript object (hash). You can access the data as follow:

data.columns

Or

data["columns"]

answered Dec 7, 2015 at 15:01

Omar Mowafi

8545 silver badges13 bronze badges

Comments

Dragos · Accepted Answer · 2015-12-07 15:01:35Z

0

For retrieving the 'data' field

$.ajax({
url: query,
type: "GET",
dataType: "json"
success: function(data) {
    var day = data['data']; // get data value from json
    $("#Day").val(day);
}
});    

{
   "name":"workdays",
   "columns":[
   "day"
],
"data":[
   [
     "FRI"
   ]
]
}

answered Dec 7, 2015 at 15:01

Dragos

78610 silver badges33 bronze badges

Comments

CGalvao · Accepted Answer · 2015-12-07 15:03:24Z

0

Have you ever checked the data.d variable?

success: function(data) {
   console.log(data.d); //prints the value
}

answered Dec 7, 2015 at 15:03

CGalvao

172 bronze badges

Collectives™ on Stack Overflow

How to get value from json object using jquery?

7 Answers 7

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related